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
Add VACUUM instrumentation for scanned pages, relfrozenxid.
2022-02-12
Pet
e
r Geoghegan
Add VAC
U
UM instrumentation for scanned pages, rel
f
rozenx
i
d
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-11
Peter Geoghegan
Simplif
y
la
z
y_scan_heap's
handling of scanned pages
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-29
Peter
Geoghegan
vac
u
u
mlazy
.
c: Renam
e
state
field for consistency
.
commit
|
commitdiff
|
tree
2022-01-15
P
e
ter Ge
o
ghegan
Unify VACUUM VE
R
BO
S
E a
n
d
a
utovacuum
l
ogging
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-12
P
eter Geo
g
hegan
F
ix memory leak
in indexUnchanged hint mechanism
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-12
Peter Geoghegan
vac
u
umlaz
y
.
c: fi
x
"garbag
e
t
uples" reference
.
commit
|
commitdiff
|
tree
2021-12-09
Peter Geoghegan
Standar
d
ize cleanup lock terminology
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-30
Pet
e
r G
e
oghegan
vacuumlazy
.
c:
f
i
x remaining "dead tuple" references
.
commit
|
commitdiff
|
tree
2021-11-29
Pet
e
r
G
eoghe
g
a
n
vacu
u
mlazy
.
c: Rename
dead_tuples
to dead_i
t
ems
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-28
P
e
ter Geoghegan
v
a
cuumlazy
.
c
:
prefer th
e
t
e
rm "clean
u
p lock"
.
commit
|
commitdiff
|
tree
2021-11-27
Peter Geogh
e
g
a
n
Update hig
h
level
v
acuumlazy
.
c comments
.
commit
|
commitdiff
|
tree
2021-11-26
Peter Geoghegan
Go back
to conside
r
ing HO
T
on pages marked full
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-22
Peter Ge
o
g
hegan
Remove lazy_scan_heap p
a
rallel
VACUUM commen
t
block
.
commit
|
commitdiff
|
tree
2021-11-13
Peter Geogh
e
gan
Explain pruni
n
g
pgstats accounting subtleties
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-11
Peter Geoghegan
Upd
a
t
e
heap_page_prune() free space map comments
.
commit
|
commitdiff
|
tree
2021-11-11
Pe
t
e
r
G
eog
h
egan
Update another obsolete
r
ef
e
re
n
ce in
v
acuumlazy
.
c
.
commit
|
commitdiff
|
tree
2021-11-06
Peter Geoghegan
Upda
t
e obsolete
reference in
vacuumlazy
.
c
.
commit
|
commitdiff
|
tree
2021-11-05
Pete
r
Geoghegan
Update obsolete heap pruning comments
.
commit
|
commitdiff
|
tree
2021-11-05
Peter
G
e
oghegan
Add harden
i
ng to catch invalid TIDs
i
n indexes
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-05
Peter
G
eoghe
g
an
Add various
a
s
sertions to heap pruning code
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-04
Peter Geoghegan
Add another
old commit to git-blame-igno
r
e-revs
.
commit
|
commitdiff
|
tree
2021-11-03
P
eter Geoghegan
F
ix
parallel amvacuumcleanup safety b
u
g
.
commit
|
commitdiff
|
tree
2021-11-02
P
e
ter Ge
o
ghegan
Don't overlook
indexes dur
i
ng parallel VACU
U
M
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-29
Pet
e
r G
e
o
g
hegan
D
e
mote
p
g_unreacha
b
le() in heapam
t
o a
n
asse
r
ti
o
n
.
commit
|
commitdiff
|
tree
2021-10-27
Peter Geoghegan
Rem
o
ve obso
l
ete nbt
r
e
e
L
P_DEAD it
e
m comm
e
nts
.
commit
|
commitdiff
|
tree
2021-10-27
Peter
Geoghegan
Fix
o
rde
r
in
g
of items in n
b
tree
error
messa
g
e
.
commit
|
commitdiff
|
tree
2021-10-27
Peter
G
e
oghegan
F
u
rt
h
e
r
h
a
rden n
b
tree
posting split code
.
commit
|
commitdiff
|
tree
2021-10-15
Peter Geoghegan
R
e
move
o
bsolete nbt
r
e
e
dedup
l
ic
a
tion comment
s
.
commit
|
commitdiff
|
tree
2021-10-14
Peter Geoghegan
Remove u
n
stable pg_amche
c
k
t
est
s
.
commit
|
commitdiff
|
tree
2021-10-13
Peter
G
eoghegan
pg_amcheck: avoid unhelpful verification attem
p
ts
.
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-12
Peter Geogheg
a
n
Do
c
: normalize vacuum_multixact
_
failsafe_age ID
.
commit
|
commitdiff
|
tree
2021-10-12
Pe
t
er
G
eoghegan
amc
h
eck: Ski
p
unlogged relations
in Hot Standby
.
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-03
P
e
ter Geog
h
egan
Enable d
e
d
uplication i
n
system catal
o
g
i
n
d
e
xes
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-27
Peter Geoghegan
Remove
u
nneeded nbtree latestRemo
v
edXid
comments
.
commit
|
commitdiff
|
tree
2021-09-25
P
e
t
e
r Geoghegan
Upd
a
t
e obsolete nbtree
deletion comments
.
commit
|
commitdiff
|
tree
2021-09-25
Peter Geoghegan
vacuumlazy
.
c: R
e
move
o
bsolete 'onecall' comment
.
commit
|
commitdiff
|
tree
2021-09-24
Peter Geoghe
g
an
nbtree README: Add note ab
o
ut
l
atestRemo
v
ed
X
id
.
commit
|
commitdiff
|
tree
2021-09-23
Peter G
e
oghega
n
Document iss
u
e with heapam
l
ine pointer truncation
.
commit
|
commitdiff
|
tree
2021-09-22
Pete
r
Ge
o
ghegan
Fix "
s
ingle value strategy
"
index deletio
n
issue
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-20
Peter Geoghe
g
an
Remove ov
e
rze
a
lous
index deletio
n
assertion
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-17
Peter
G
e
oghegan
pageinspect: Make p
a
ge
d
eletion elo
g
les
s
chatty
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-01
Peter Geog
h
eg
a
n
VA
C
UU
M
VERBOSE
:
Don'
t
report "
p
ages
r
e
m
o
v
ed"
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-31
Peter Geoghegan
R
emove obs
o
lete nbtree relation
extensi
o
n comment
.
commit
|
commitdiff
|
tree
2021-08-31
Pete
r
Geoghegan
va
c
uumla
z
y
.
c: Corr
e
ct prune st
a
te com
m
ent
.
commit
|
commitdiff
|
tree
2021-08-31
Peter Geoghegan
Remov
e
unneeded old_rel_pages
V
AC
U
UM state field
.
commit
|
commitdiff
|
tree
2021-08-31
Peter G
e
oghegan
Add
h
ist
o
ric commit to git-
b
lame-
i
gnore-revs file
.
commit
|
commitdiff
|
tree
2021-08-27
Peter
Geoghe
g
an
track_io_timing logging:
D
on
'
t spec
i
al case 0 ms
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-27
Peter Geoghegan
Reo
r
der l
o
g_autov
a
cuum_mi
n
_d
u
ration
log ou
t
put
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-27
Peter G
e
oghegan
vac
u
umlazy
.
c:
R
emove unn
e
cessary parenth
e
ses
.
commit
|
commitdiff
|
tree
2021-08-27
P
e
te
r
Geoghegan
contrib/amcheck: Add heapam
C
H
ECK_FOR_INTERRUPTS(
)
.
commit
|
commitdiff
|
tree
2021-08-04
Peter Geog
h
e
g
a
n
Make vacuum_
i
nde
x
_cleanup
r
eloption R
E
LOPT_TYPE_EN
U
M
.
commit
|
commitdiff
|
tree
2021-07-20
Peter Ge
o
ghegan
Doc:
v
acuum
_
m
ultixact_failsafe_age i
s
multixact
-
b
a
sed
.
commit
|
commitdiff
|
tree
2021-07-20
Pete
r
Geogh
e
ga
n
vacuumdb: Correct comment about --f
o
rce-index-clean
u
p
.
commit
|
commitdiff
|
tree
2021-06-28
P
et
e
r Geoghegan
Improve pgindent r
e
lease workflo
w
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-28
P
e
ter Geoghegan
A
d
d pginden
t
c
ommit to git-blame
-
ignore-revs fi
l
e
.
commit
|
commitdiff
|
tree
2021-06-22
Peter Geog
h
egan
Add list of ignorable pg
i
ndent
commits fo
r
g
it
-
blame
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-21
Peter Geo
g
hegan
R
emove overz
e
alo
u
s VA
C
UUM fails
a
fe asse
r
tions
.
commit
|
commitdiff
|
tree
2021-06-19
Peter
G
e
o
g
he
g
an
Support disabling inde
x
by
p
assing by VA
C
UUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-15
Peter Geoghe
g
a
n
Re
m
ov
e
unneed
e
d f
i
eld
from VAC
U
UM s
t
ate
.
commit
|
commitdiff
|
tree
2021-05-28
P
e
t
er Geoghegan
F
i
x VACUU
M
V
ERBOSE's LP
_
DEAD item
p
ages output
.
commit
|
commitdiff
|
tree
2021-05-25
Peter
Geoghegan
Consider triggering VA
C
UU
M
failsafe during s
c
an
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-05-14
P
ete
r
Ge
o
ghegan
Harden nbtree deduplication postin
g
split code
.
commit
|
commitdiff
|
tree
2021-05-13
Peter Geoghegan
Fix
autovac
u
u
m
log output heap truncation iss
u
e
.
commit
|
commitdiff
|
tree
2021-05-06
Peter Geo
g
hegan
R
emove
o
verzealous VACUUM visibility m
a
p ass
e
rtion
.
commit
|
commitdiff
|
tree
2021-04-23
Peter Geo
g
hegan
a
m
check: MAXALIGN() nbt
r
ee special area of
f
s
et
.
commit
|
commitdiff
|
tree
2021-04-20
Pete
r
Geoghegan
D
ocumen
t
LP_DEAD
accoun
t
ing
issues in VACUUM
.
commit
|
commitdiff
|
tree
2021-04-13
Pet
e
r Geoghegan
Don't trunc
a
te
heap wh
e
n VACUUM's failsafe
i
s in
e
f
f
ec
t
.
commit
|
commitdiff
|
tree
2021-04-08
Peter
G
eoghega
n
Silence anot
h
er
_bt_check_un
i
q
ue
com
p
iler warning
.
commit
|
commitdiff
|
tree
2021-04-07
Peter Geoghegan
T
e
a
ch VACUUM to bypass unnecess
a
ry index v
a
cuum
i
ng
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-07
Peter
Geoghega
n
Add
w
r
aparo
u
nd failsafe to
VAC
U
UM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-07
P
e
ter Geogh
e
gan
Tru
n
cat
e
line pointer array durin
g
VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Geogheg
a
n
Rem
o
ve tupgo
n
e special case fr
o
m vacuu
m
lazy
.
c
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Pe
t
er Geogheg
a
n
Refactor
l
a
zy_scan_h
e
ap(
)
loop
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Geoghegan
Allo
c
a
t
e
access strategy in parall
e
l V
A
CUUM work
e
rs
.
commit
|
commitdiff
|
tree
2021-04-05
P
e
ter Geoghegan
Propagate pa
r
allel VACUUM
'
s buf
f
er
acce
s
s s
t
rategy
.
commit
|
commitdiff
|
tree
2021-04-05
Peter Geogheg
a
n
Sim
p
lif
y
state managed
by VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-29
Peter
G
eoghegan
PageAddItemExtended(): Add LP_UNUSED ass
e
rtion
.
commit
|
commitdiff
|
tree
2021-03-23
Peter Geoghegan
nbt
r
ee VACUUM:
C
ope
w
i
th buggy
opclasses
.
commit
|
commitdiff
|
tree
2021-03-21
Pet
e
r G
e
oghegan
Recyc
l
e nbtre
e
page
s
deleted d
u
ring
s
ame VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-16
Pet
e
r
Geo
g
h
egan
Fix
c
omment
a
bout pr
o
m
i
sing tuples
.
commit
|
commitdiff
|
tree
2021-03-16
Peter Geoghegan
a
m
check: Reduce debug me
s
s
a
ge verbosity
.
commit
|
commitdiff
|
tree
2021-03-15
P
eter Geogh
e
g
an
Notice
that heap page has de
a
d
it
e
m
s
d
u
r
ing VACUUM
.
commit
|
commitdiff
|
tree
2021-03-12
Pet
e
r Geoghegan
Consol
i
date nbtree VA
C
UUM metapa
g
e
routines
.
commit
|
commitdiff
|
tree
2021-03-11
Pete
r
Geogheg
a
n
Save a
few c
y
cles during n
b
tree
V
AC
U
UM
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geoghegan
Add
ba
c
k vacuum_cleanup_index_scale_f
a
ctor parameter
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geoghegan
Doc:
B-
T
ree only
has one addi
t
i
o
nal p
a
r
ameter
.
commit
|
commitdiff
|
tree
2021-03-11
Pete
r
G
e
oghegan
VAC
U
UM A
N
A
L
Y
Z
E: A
l
ways
u
pd
a
te pg_class
.
relt
u
p
l
e
s
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-11
P
eter Geoghegan
Don't conside
r
newl
y
i
n
serted tuples in nb
t
ree VAC
U
UM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-02
P
e
t
e
r
Geo
g
hegan
n
b
tree page deleti
o
n: Add leaftopparent asser
t
ion
.
commit
|
commitdiff
|
tree
2021-03-02
P
e
t
er G
e
ogheg
a
n
Fix n
b
tre
e
page de
l
etion error
m
e
ssage
s
.
commit
|
commitdiff
|
tree
2021-02-25
Pete
r
Geog
h
e
gan
VAC
U
UM VERBOSE: Co
u
nt "n
e
wly d
e
leted" in
d
ex pages
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-02-25
Peter Ge
o
gh
e
gan
Use full 6
4
-b
i
t XIDs in del
e
t
e
d
nbtree
pages
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-02-19
Pe
t
er Geoghe
g
an
Add nbtree
README secti
o
n
on page re
c
ycli
n
g
.
commit
|
commitdiff
|
tree
2021-02-18
Pe
t
e
r
Ge
o
ghe
g
an
n
btree README: move VACU
U
M
l
i
near
scan section
.
commit
|
commitdiff
|
tree
2021-02-15
Peter Geo
g
hegan
Add "LP_DEAD item?" colu
m
n to GiST page
i
ns
p
ect fun
c
tions
commit
|
commitdiff
|
tree
2021-02-15
Peter G
e
oghegan
Avoid
m
i
s
interp
r
eting GiST page
s
in p
a
ge
i
nspect
.
commit
|
commitdiff
|
tree
2021-02-15
P
et
e
r
G
eoghe
g
an
Adjust lazy_sc
a
n_heap
(
) accounting comments
.
commit
|
commitdiff
|
tree
2021-02-12
Peter
G
eoghe
g
an
Re
m
ove obsolete
In
d
exBulkDele
t
eResult
s
tats field
.
commit
|
commitdiff
|
tree
2021-02-09
Peter Geoghegan
Fix
obso
l
ete FSM remar
k
s in nbtree
R
EADM
E
.
commit
|
commitdiff
|
tree
2021-02-08
Pet
e
r Geog
h
e
gan
Correct
p
gstat
t
uple
B
-Tree page
c
o
m
ments
.
commit
|
commitdiff
|
tree
next