repo.or.cz
/
pgsql.git
/
search
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
first
·
prev
·
next
vacuumlazy.c: Standardize rel_pages terminology.
2022-03-12
Peter Geoghegan
vacuum
l
azy
.
c: Stan
d
ardize rel_pages termi
n
ol
o
gy
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-03-12
Pete
r
Geoghe
g
an
vacuumlazy
.
c:
d
ocument
v
i
s
tes
t
and O
l
destXmin
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-03-12
Peter Geog
h
egan
N
o
rmalize heap_pr
e
p
are_freeze_tuple argument name
.
commit
|
commitdiff
|
tree
2022-02-25
Peter
Geoghegan
vac
u
umlazy
.
c: Remove obsolete
num_tuples f
i
e
l
d
.
commit
|
commitdiff
|
tree
2022-02-25
Peter Geoghegan
Remove u
n
n
ecessary heap_tu
p
l
e
_needs_freeze argument
.
commit
|
commitdiff
|
tree
2022-02-17
Pet
e
r
Geog
h
egan
Inc
r
eas
e
h
ash_m
e
m_mult
i
plier default to 2
.
0
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-17
Peter
Geoghegan
Avoid VACUUM r
e
ltuples distortion
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-15
Peter Geog
h
e
gan
Update
"
d
on'
t
truncate with failsafe"
rationale
.
commit
|
commitdiff
|
tree
2022-02-12
Pet
e
r G
e
oghegan
Co
n
soli
d
at
e
VACUUM
xid cutoff logi
c
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-12
Pet
e
r
G
eogheg
a
n
Add
VACUUM i
n
strumentat
i
on for scanned pa
g
es
,
relfr
o
zenxid
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-11
Peter Geoghegan
Simplify lazy_scan_heap's handling of
scan
n
ed pages
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-29
Pet
e
r
G
eogh
e
gan
vacu
u
ml
a
zy
.
c: Re
n
ame sta
t
e field for cons
i
stency
.
commit
|
commitdiff
|
tree
2022-01-15
Peter
Geo
g
hegan
Un
i
fy VACU
U
M VERBOSE and autovacuum logging
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-12
Peter Geogh
e
gan
Fix memory leak
i
n
indexUnchan
g
ed
h
i
nt mechanism
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-12
Peter Geoghe
g
an
v
acuum
l
azy
.
c: fix "
g
ar
b
age tuple
s
" reference
.
commit
|
commitdiff
|
tree
2021-12-09
Peter Geoghegan
Standar
d
ize
c
l
e
a
n
up lock terminology
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-30
Peter Geogheg
a
n
vacu
u
mlazy
.
c: fix remaining "dead tuple" referen
c
es
.
commit
|
commitdiff
|
tree
2021-11-29
Peter Geoghegan
vacuuml
a
zy
.
c: Rena
m
e dead_
t
uples t
o
dead_i
t
ems
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-28
Peter Geo
g
hegan
va
c
uumlazy
.
c: prefer th
e
term "cleanup
lock"
.
commit
|
commitdiff
|
tree
2021-11-27
Pet
e
r G
e
oghega
n
Update high level
vacuumlazy
.
c comments
.
commit
|
commitdiff
|
tree
2021-11-26
P
e
ter Geoghegan
Go b
a
ck
to co
n
sidering
H
OT
o
n pages marked f
u
ll
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-22
P
e
ter Geoghe
g
an
Remove lazy_scan_
h
ea
p
parall
e
l
V
ACUUM comment block
.
commit
|
commitdiff
|
tree
2021-11-13
Peter Geogh
e
gan
Explain pru
n
ing pgstat
s
acc
o
u
nting subtlet
i
es
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-11
Peter Geoghegan
Update heap
_
p
a
ge_prune() free spa
c
e
m
a
p comments
.
commit
|
commitdiff
|
tree
2021-11-11
P
eter Geoghegan
U
p
date a
n
other obsolete r
e
f
erence in vac
u
umlazy
.
c
.
commit
|
commitdiff
|
tree
2021-11-06
Peter Geoghegan
Upda
t
e
o
b
s
olet
e
r
e
ference
i
n vacuumlaz
y
.
c
.
commit
|
commitdiff
|
tree
2021-11-05
Peter G
e
o
ghega
n
Update obsolete heap pruning comments
.
commit
|
commitdiff
|
tree
2021-11-05
Peter G
e
oghegan
Add harden
i
ng to
c
atch in
v
alid
T
IDs in indexes
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-05
Peter Geo
g
h
e
gan
Add v
a
rious as
s
e
rtions to
h
eap
p
runi
n
g
c
o
d
e
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-04
Peter Geoghegan
Add an
o
ther
old commit to
git-blame-ignor
e
-
revs
.
commit
|
commitdiff
|
tree
2021-11-03
Peter Geoghegan
F
i
x paral
l
el amvacuumcl
e
anup safety bug
.
commit
|
commitdiff
|
tree
2021-11-02
Peter Ge
o
ghegan
Don'
t
o
v
erl
o
ok indexes during parallel VAC
U
U
M
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-29
Peter Geoghe
g
an
Demote pg_u
n
reach
a
ble() in
heapam to an
a
ssert
i
on
.
commit
|
commitdiff
|
tree
2021-10-27
Peter
G
eogheg
a
n
Remove obsolete n
b
tree LP_DEAD item
co
m
ments
.
commit
|
commitdiff
|
tree
2021-10-27
Peter
G
e
o
ghegan
Fix orderi
n
g o
f
items
in nbtree
error messa
g
e
.
commit
|
commitdiff
|
tree
2021-10-27
Peter Geoghegan
F
u
rther ha
r
den nbtree
p
o
sting
s
plit
c
ode
.
commit
|
commitdiff
|
tree
2021-10-15
Pe
t
er Geo
g
hegan
Re
m
ove ob
s
o
lete nb
t
ree deduplicat
i
on comments
.
commit
|
commitdiff
|
tree
2021-10-14
P
eter Ge
o
gheg
a
n
Remov
e
u
n
stable pg_amcheck tests
.
commit
|
commitdiff
|
tree
2021-10-13
Peter Geoghegan
pg_
a
mc
h
e
ck: a
v
oid unhel
p
ful verification
attempts
.
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-12
Peter
G
eogheg
a
n
Doc: normalize vacuum_multi
x
ac
t
_fails
a
fe_age ID
.
commit
|
commitdiff
|
tree
2021-10-12
Pete
r
G
eoghe
g
an
amcheck: Skip unlogge
d
relations in Ho
t
Standby
.
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-03
Peter Geo
g
hegan
Enable
dedup
l
i
cation i
n
syste
m
catalog i
n
dexes
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-27
Pete
r
Geog
h
egan
Remove unne
e
de
d
nbtree l
a
testR
e
movedXid comme
n
ts
.
commit
|
commitdiff
|
tree
2021-09-25
Peter Geoghegan
Update obsol
e
t
e
nbtree de
l
etion comm
e
n
t
s
.
commit
|
commitdiff
|
tree
2021-09-25
Pe
t
e
r Geog
h
egan
v
acuum
l
azy
.
c: Remove obsolete
'
onecall' commen
t
.
commit
|
commitdiff
|
tree
2021-09-24
Peter
G
eoghega
n
nbtree READ
M
E: A
d
d
n
o
te about latestR
e
mo
v
e
dXid
.
commit
|
commitdiff
|
tree
2021-09-23
P
e
t
e
r
Geog
h
egan
D
o
cument issue with heapam line poin
t
er
trun
c
ati
o
n
.
commit
|
commitdiff
|
tree
2021-09-22
Peter G
e
oghegan
Fix "single va
l
ue strategy" i
n
de
x
deletion issue
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-20
Pete
r
G
eogh
e
g
an
R
e
m
ove ov
e
rzealous inde
x
deletion a
s
sertion
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-17
Pe
t
er Geoghegan
pageinspe
c
t: Make page de
l
e
t
i
on el
o
g less chatty
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-01
Peter Ge
o
g
h
egan
VA
C
UUM VERBOSE: Don't repor
t
"pages removed"
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-31
Peter Geogh
e
gan
Remove obsolete nbtr
e
e
r
elati
o
n e
x
tension comment
.
commit
|
commitdiff
|
tree
2021-08-31
Peter Geoghegan
vacuu
m
lazy
.
c:
Correct pr
u
ne st
a
t
e
comment
.
commit
|
commitdiff
|
tree
2021-08-31
Peter
G
eoghegan
Remove unneeded old_
r
el_page
s
VACUUM state field
.
commit
|
commitdiff
|
tree
2021-08-31
Peter Geoghega
n
Add his
t
o
r
i
c
commit to
g
it-blame-ignore-revs file
.
commit
|
commitdiff
|
tree
2021-08-27
P
e
t
er Geoghe
g
an
track_io_
t
i
m
i
ng logging: Don't
special case 0 ms
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-27
Pe
t
er Geoghega
n
Reorder log_au
t
ovacuum_min_du
r
a
tion log out
p
ut
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-27
P
e
ter Ge
o
ghegan
vacuumlazy
.
c: Remove unnecessary
p
arentheses
.
commit
|
commitdiff
|
tree
2021-08-27
Peter
G
eoghegan
contrib/amche
c
k: Add h
e
apam CHECK_FOR_INTERRUPTS()
.
commit
|
commitdiff
|
tree
2021-08-04
Peter Geoghegan
Mak
e
v
acu
u
m_index
_
cleanup reloption RELOPT_TYPE
_
ENU
M
.
commit
|
commitdiff
|
tree
2021-07-20
Pete
r
Geog
h
egan
Do
c
: v
a
cuum_multi
x
act_failsafe_ag
e
i
s
multixact-
b
a
sed
.
commit
|
commitdiff
|
tree
2021-07-20
Peter Geoghegan
vacuumdb:
C
orrect
c
omme
n
t about
-
-force-in
d
e
x-cleanup
.
commit
|
commitdiff
|
tree
2021-06-28
Peter Geoghegan
Improve p
g
indent
r
elease workflow
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-28
Peter Geoghegan
Add pg
i
ndent
comm
i
t to git-blame-ignore-re
v
s f
i
le
.
commit
|
commitdiff
|
tree
2021-06-22
Peter Geoghegan
Add list of igno
r
able pgindent commi
t
s
for git-blame
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-21
Peter Geoghegan
Remove ov
e
rzealo
u
s VAC
U
U
M failsaf
e
asserti
o
ns
.
commit
|
commitdiff
|
tree
2021-06-19
Peter Geoghegan
Sup
p
ort di
s
ablin
g
index by
p
assing by
V
ACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-15
Peter Geoghegan
Re
m
ove
u
nn
e
ed
e
d
field
f
ro
m
VACUUM state
.
commit
|
commitdiff
|
tree
2021-05-28
Peter Ge
o
ghegan
Fi
x
VA
C
UUM VERBOSE's LP_DEAD
ite
m
pages output
.
commit
|
commitdiff
|
tree
2021-05-25
Peter Geoghegan
C
on
s
ider triggering
VACUUM failsafe durin
g
scan
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-05-14
Pe
t
e
r Geoghegan
Har
d
en
nbt
r
ee de
d
u
plication posting split co
d
e
.
commit
|
commitdiff
|
tree
2021-05-13
Peter Geo
g
h
e
gan
Fix a
u
tovacu
u
m log output heap truncation i
s
sue
.
commit
|
commitdiff
|
tree
2021-05-06
P
et
e
r
G
eoghegan
R
e
move overzealou
s
VA
C
UUM vi
s
ibility
map assertion
.
commit
|
commitdiff
|
tree
2021-04-23
Pete
r
Geoghegan
amcheck:
M
AXALIGN(
)
nbt
r
e
e
s
pecial area off
s
et
.
commit
|
commitdiff
|
tree
2021-04-20
Peter Ge
o
gh
e
g
an
D
ocument L
P
_DEAD accounting issues
in VACUU
M
.
commit
|
commitdiff
|
tree
2021-04-13
Peter Geoghega
n
Don'
t
truncate heap when
VACUUM's fa
i
ls
a
fe is in effe
c
t
.
commit
|
commitdiff
|
tree
2021-04-08
Peter Geogheg
a
n
Sil
e
nce another
_
b
t_
c
h
e
ck_unique compiler warn
i
ng
.
commit
|
commitdiff
|
tree
2021-04-07
Pet
e
r Ge
o
ghegan
Teac
h
VACUUM to bypass
u
nnecessa
r
y in
d
ex vacuuming
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-07
Peter Geoghega
n
Ad
d
w
r
aparound
f
ailsafe to VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-07
Peter Geog
h
egan
Truncate li
n
e pointer
a
r
ray dur
i
ng VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Geoghe
g
an
Remove tupgo
n
e spec
i
al case from vacuumlazy
.
c
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Geoghegan
Refactor
lazy_scan
_
h
e
ap() loop
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Geoghegan
Alloca
t
e access stra
t
egy in
parallel VACUUM workers
.
commit
|
commitdiff
|
tree
2021-04-05
Peter
G
eoghegan
P
ropagate parallel VA
C
UUM
'
s b
u
ffer access
str
a
te
g
y
.
commit
|
commitdiff
|
tree
2021-04-05
Peter Geoghegan
Simplify state managed by VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-29
Peter Geoghe
g
an
PageAddItemExtended(): A
d
d LP_UNU
S
ED ass
e
r
t
ion
.
commit
|
commitdiff
|
tree
2021-03-23
Pe
t
er Geoghegan
nbtree
VACUUM: Cope
with
buggy opclas
s
es
.
commit
|
commitdiff
|
tree
2021-03-21
Peter Geo
g
hegan
Rec
y
cle nbtree pag
e
s d
e
leted during sa
m
e V
A
CUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-16
Pet
e
r
G
eogheg
a
n
F
i
x co
m
m
ent
a
bout
p
romising tuples
.
commit
|
commitdiff
|
tree
2021-03-16
Peter Geoghegan
amche
c
k:
R
educe debug message verbosity
.
commit
|
commitdiff
|
tree
2021-03-15
Pe
t
er Ge
o
g
h
e
gan
No
t
ice th
a
t heap page ha
s
d
ead items during
V
ACUUM
.
commit
|
commitdiff
|
tree
2021-03-12
P
e
ter Geoghegan
Conso
l
idate nbtree VACUUM metapag
e
r
ou
t
ines
.
commit
|
commitdiff
|
tree
2021-03-11
Peter
Ge
o
ghegan
Save
a
few cyc
l
es
dur
i
ng nbtree VACUU
M
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geoghegan
A
d
d back
v
acuum_
c
le
a
nup_index_scal
e
_
fa
c
tor p
a
rameter
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geoghegan
D
o
c: B-Tree only ha
s
on
e
additi
o
nal parameter
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geoghegan
VACUUM AN
A
LYZE: Always update
pg_class
.
relt
u
p
l
es
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-11
Pet
e
r Geogheg
a
n
Don't consider
new
l
y inserted tuples in
n
btree VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-02
Pete
r
Geoghega
n
nbtree page deletion: Add
l
eaftopparent as
s
e
rtion
.
commit
|
commitdiff
|
tree
2021-03-02
Peter Geoghegan
Fix nbtree page deletion erro
r
messages
.
commit
|
commitdiff
|
tree
2021-02-25
Pe
t
er Geoghegan
VACUUM
VERBOS
E
: Count "newly dele
t
ed" ind
e
x pages
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
next