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
VACUUM VERBOSE: tweak scanned_pages logic.
2022-03-13
Peter
G
e
o
ghegan
VACUUM VERBOSE:
twe
a
k
s
can
n
ed_pages lo
g
ic
.
commit
|
commitdiff
|
tree
2022-03-12
Pete
r
Geoghega
n
vacuumlazy
.
c: Standardiz
e
rel_pages
t
erminolo
g
y
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-03-12
P
e
ter Geoghegan
v
a
cuu
m
la
z
y
.
c: document viste
s
t a
n
d OldestXmin
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-03-12
Peter
G
eog
h
e
gan
N
ormali
z
e
h
e
ap_
p
r
e
pare_freeze_tuple argument name
.
commit
|
commitdiff
|
tree
2022-02-25
Peter Geoghegan
v
a
c
uumlazy
.
c: Remove obs
o
le
t
e nu
m
_tuples fie
l
d
.
commit
|
commitdiff
|
tree
2022-02-25
Peter
Geoghegan
Re
m
ove
u
n
n
ecessary heap_tuple_
n
eeds_freeze argum
e
nt
.
commit
|
commitdiff
|
tree
2022-02-17
P
et
e
r Geoghe
g
an
Incre
a
se
hash_mem_multiplier
default to 2
.
0
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-17
P
e
te
r
Geoghega
n
A
vo
i
d
V
ACUUM
r
eltuples distorti
o
n
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-15
P
eter Geog
h
e
gan
Update "don't t
r
uncate with failsafe
"
rati
o
nale
.
commit
|
commitdiff
|
tree
2022-02-12
Peter Geogh
e
ga
n
Consoli
d
at
e
VACUUM xid cutoff lo
g
ic
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-12
Peter G
e
oghegan
Add VACUUM instrum
e
ntation
f
or scanned page
s
,
relfrozenxid
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-11
P
e
t
e
r
Geoghe
g
an
S
implify lazy
_
sca
n
_hea
p
'
s handlin
g
o
f
scanned
p
ages
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-29
P
eter
Geoghegan
vacuu
m
lazy
.
c
:
R
e
name s
t
a
t
e field
f
o
r consistenc
y
.
commit
|
commitdiff
|
tree
2022-01-15
P
e
ter Geoghegan
Unif
y
VAC
U
UM
V
ER
B
OSE
and autov
a
cuum logging
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-12
Peter
Geoghe
g
an
Fix
m
emo
r
y leak in indexUn
c
hanged h
i
n
t
m
e
chanism
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-12
Pete
r
Geo
g
h
e
g
a
n
v
a
cuumlazy
.
c: fix "garbage tu
p
les"
re
f
erence
.
commit
|
commitdiff
|
tree
2021-12-09
Peter Geoghegan
St
a
ndardize cleanup lock terminology
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-30
P
et
e
r
Geoghegan
vacuumlazy
.
c
:
fix
r
emaining "dead tuple"
r
e
f
erences
.
commit
|
commitdiff
|
tree
2021-11-29
Peter Ge
o
g
h
e
gan
vacuumlazy
.
c: Ren
a
me dead_tuples t
o
d
e
ad_item
s
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-28
Peter Geog
h
e
gan
vacuu
m
lazy
.
c
:
prefer the term
"
cleanup lock"
.
commit
|
commitdiff
|
tree
2021-11-27
Peter Ge
o
ghe
g
a
n
Update
h
igh level vacuumlazy
.
c c
o
mme
n
ts
.
commit
|
commitdiff
|
tree
2021-11-26
Peter Geoghegan
Go
back
to
consid
e
r
i
ng HOT on pages marked full
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-22
P
e
ter Geoghegan
Remove lazy_scan_he
a
p
parallel VACU
U
M co
m
ment block
.
commit
|
commitdiff
|
tree
2021-11-13
Peter G
e
oghegan
Explain pruning pgstats acc
o
unting subtleties
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-11
P
e
t
er Ge
o
g
hegan
Update
h
eap_page_prune() free
space map
c
o
m
m
ents
.
commit
|
commitdiff
|
tree
2021-11-11
P
eter Geoghegan
Update anothe
r
o
b
s
o
lete re
f
erence in vacuu
m
lazy
.
c
.
commit
|
commitdiff
|
tree
2021-11-06
Pete
r
Ge
o
ghegan
Upd
a
te
o
bsolete reference in vacuumlazy
.
c
.
commit
|
commitdiff
|
tree
2021-11-05
Peter Geogh
e
gan
Update
o
bsolete heap pr
u
ning co
m
ment
s
.
commit
|
commitdiff
|
tree
2021-11-05
Pete
r
G
e
oghegan
Add hardening to catch in
v
alid TI
D
s in indexes
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-05
Pe
t
er Ge
o
ghegan
Add various asserti
o
ns to heap pr
u
ning code
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-04
Pe
t
e
r Geog
h
egan
Add ano
t
h
er old commit to git
-
b
lame-ignor
e
-revs
.
commit
|
commitdiff
|
tree
2021-11-03
Peter
G
eoghegan
Fix
parallel amvacuumcleanup safety bug
.
commit
|
commitdiff
|
tree
2021-11-02
Peter Geogh
e
gan
Don't overl
o
ok indexes during parallel VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-29
Peter Geoghe
g
an
De
m
ote
pg_unreachable() in hea
p
a
m
to an assertion
.
commit
|
commitdiff
|
tree
2021-10-27
Pet
e
r Geoghega
n
Remov
e
obsole
t
e n
b
tree LP_DEAD item comments
.
commit
|
commitdiff
|
tree
2021-10-27
Peter Geoghegan
F
ix ordering o
f
items in nbtree err
o
r message
.
commit
|
commitdiff
|
tree
2021-10-27
P
eter Geoghegan
F
u
r
th
e
r h
a
rden nbtree posting s
p
lit code
.
commit
|
commitdiff
|
tree
2021-10-15
Peter Geogh
e
g
a
n
Remove obsolete nbtree
deduplication comments
.
commit
|
commitdiff
|
tree
2021-10-14
Pete
r
G
eoghegan
Remo
v
e uns
t
able pg_amch
e
ck
t
es
t
s
.
commit
|
commitdiff
|
tree
2021-10-13
Peter Geo
g
hegan
pg_amcheck: avoid
unhelpful verificati
o
n at
t
empts
.
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-12
Peter Geog
h
egan
Doc
:
normalize vacuu
m
_mul
t
ixact_failsafe_age ID
.
commit
|
commitdiff
|
tree
2021-10-12
Peter G
e
og
h
eg
a
n
amc
h
eck: Skip
u
nlogg
e
d
relations
i
n Hot
S
tandb
y
.
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-03
Peter Geoghegan
E
n
able deduplication in s
y
stem
ca
t
alog indexes
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-27
Peter G
e
o
g
hegan
Remove u
n
needed nbtree latestRemovedX
i
d com
m
ents
.
commit
|
commitdiff
|
tree
2021-09-25
Pete
r
Geoghegan
U
p
d
ate
o
bsolete nbt
r
ee deletion co
m
ments
.
commit
|
commitdiff
|
tree
2021-09-25
Peter Geog
h
egan
vacuumlaz
y
.
c: Remove
o
bsolete
'onecall' comme
n
t
.
commit
|
commitdiff
|
tree
2021-09-24
Peter
G
e
oghegan
nbtree
R
E
A
D
M
E: Add note about latestRe
m
ovedXid
.
commit
|
commitdiff
|
tree
2021-09-23
Peter Geoghegan
Docume
n
t
i
ssue
w
ith
h
eapam
li
n
e poin
t
e
r
trunca
t
io
n
.
commit
|
commitdiff
|
tree
2021-09-22
Peter G
e
ogh
e
ga
n
Fix "si
n
g
l
e
valu
e
s
t
rategy" index del
e
ti
o
n issue
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-20
Peter Geo
g
hega
n
Remove overzealous inde
x
deletion assert
i
on
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-17
Peter Geog
h
e
g
an
pageinspect: Make p
a
ge
d
eletion elog le
s
s
chatty
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-01
Pe
t
e
r
G
eoghegan
VACUUM
VERB
O
SE:
Don't rep
o
rt "pages removed"
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-31
P
eter Geoghegan
Remove o
b
solete n
b
t
ree relation extensi
o
n com
m
ent
.
commit
|
commitdiff
|
tree
2021-08-31
Peter Geoghegan
vac
u
umlazy
.
c: Correct pru
n
e
state co
m
ment
.
commit
|
commitdiff
|
tree
2021-08-31
Peter Geoghegan
Rem
o
ve unneeded o
l
d_rel_pages
VACU
U
M s
t
ate field
.
commit
|
commitdiff
|
tree
2021-08-31
Peter
G
eoghegan
Add historic commit
to
g
it-b
l
ame-ignore-revs file
.
commit
|
commitdiff
|
tree
2021-08-27
P
e
ter
Geoghe
g
a
n
tra
c
k_io_ti
m
ing logging: Don't
s
pecial cas
e
0 ms
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-27
Pete
r
Geog
h
egan
Re
o
r
der
l
og_au
t
ovacuum
_
min_dura
t
i
o
n log output
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-27
P
eter Geoghegan
vacuum
l
azy
.
c: Remove
u
n
n
ecessary parentheses
.
commit
|
commitdiff
|
tree
2021-08-27
Pe
t
er Geoghegan
c
o
n
t
rib/amcheck: Add
h
eapa
m
C
H
E
CK_FO
R
_INTERRUPTS()
.
commit
|
commitdiff
|
tree
2021-08-04
Peter
Geog
h
egan
Make vac
u
um_
i
n
d
e
x
_cleanup rel
o
ption RELOPT_T
Y
PE_ENUM
.
commit
|
commitdiff
|
tree
2021-07-20
P
eter Geoghegan
Doc: v
a
cuum_multixac
t
_failsafe
_
age
is multixact-
b
ased
.
commit
|
commitdiff
|
tree
2021-07-20
Peter Geoghegan
va
c
uumdb:
C
orrect c
o
mment abou
t
-
-
f
orce-in
d
ex-
c
lean
u
p
.
commit
|
commitdiff
|
tree
2021-06-28
Peter Geoghega
n
Impr
o
ve pgindent release workflow
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-28
Pe
t
er Geoghegan
Add pg
i
ndent
c
o
mmi
t
to git-blame-ignore-r
e
vs file
.
commit
|
commitdiff
|
tree
2021-06-22
Peter Geogheg
a
n
A
dd list of
i
gno
r
able pgind
e
n
t
commit
s
f
o
r g
i
t
-
blame
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-21
Peter Geoghegan
Rem
o
ve ov
e
rzeal
o
us VACUUM fails
a
fe a
s
sertions
.
commit
|
commitdiff
|
tree
2021-06-19
Pe
t
e
r Geogheg
a
n
Sup
p
ort disabling index bypassing by
V
ACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-15
Peter Geoghegan
R
emove unneeded fie
l
d
f
r
om VACUUM
st
a
te
.
commit
|
commitdiff
|
tree
2021-05-28
Peter Geoghegan
Fix V
A
CUUM VERBOSE'
s
L
P
_DEAD item p
a
ges
o
utput
.
commit
|
commitdiff
|
tree
2021-05-25
Peter
Geog
h
ega
n
Consider
tr
i
ggering
V
ACUU
M
fa
i
l
safe during scan
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-05-14
Peter Geogheg
a
n
Harden nbtree dedupl
i
ca
t
ion posti
n
g split c
o
de
.
commit
|
commitdiff
|
tree
2021-05-13
Peter Geogh
e
gan
F
i
x
auto
v
ac
u
um log output heap trunc
a
tion issue
.
commit
|
commitdiff
|
tree
2021-05-06
Peter Ge
o
g
hegan
Remove overzealou
s
VA
C
UUM
vi
s
ibility map ass
e
rtion
.
commit
|
commitdiff
|
tree
2021-04-23
P
eter G
e
ogheg
a
n
am
c
heck: MAXAL
I
GN() nbt
r
e
e special area of
f
s
e
t
.
commit
|
commitdiff
|
tree
2021-04-20
Peter Geog
h
egan
Doc
u
ment LP_DEAD acco
u
nting
i
s
sues in
V
A
C
UUM
.
commit
|
commitdiff
|
tree
2021-04-13
P
e
ter Ge
o
ghegan
Don't tru
n
cate heap when VA
C
UUM's fail
s
a
f
e is in
e
ffe
c
t
.
commit
|
commitdiff
|
tree
2021-04-08
Peter
Geoghegan
Silence another _bt
_
che
c
k_unique c
o
mpiler warn
i
n
g
.
commit
|
commitdiff
|
tree
2021-04-07
P
e
ter Ge
o
ghegan
Teach
V
ACUUM to b
y
pass unnecessary index
v
acuuming
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-07
P
e
t
e
r
G
eoghega
n
Add wraparound f
a
ilsa
f
e
t
o
VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-07
P
e
t
er G
e
o
g
he
g
an
Truncate line pointer ar
r
ay during VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Ge
o
gh
e
ga
n
Re
m
ove
tupg
o
n
e
special case from vacu
u
ml
a
zy
.
c
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Geogh
e
g
an
Refactor lazy_scan_heap() loop
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Geoghegan
Allo
c
ate a
c
cess strategy in parallel
VAC
U
U
M
w
orkers
.
commit
|
commitdiff
|
tree
2021-04-05
Peter Ge
o
ghegan
Pro
p
agate parallel VACUU
M
's
buffer access strat
e
g
y
.
commit
|
commitdiff
|
tree
2021-04-05
Pete
r
Geog
h
e
gan
Simplify
s
tate
managed
b
y
V
A
CUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-29
Peter G
e
oghegan
PageAddItemExtende
d
():
A
dd LP_
U
NUSED assertion
.
commit
|
commitdiff
|
tree
2021-03-23
Pe
t
er
Geoghegan
nbtr
e
e VACUUM: Cop
e
w
i
th buggy opclasses
.
commit
|
commitdiff
|
tree
2021-03-21
Pe
t
er Geoghegan
Recycle nbtree pages deleted durin
g
s
ame VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-16
Peter
G
eogheg
a
n
Fi
x
comme
n
t
abou
t
p
romising tuples
.
commit
|
commitdiff
|
tree
2021-03-16
P
eter Geoghegan
amcheck:
Reduce debug mess
a
ge
verbos
i
ty
.
commit
|
commitdiff
|
tree
2021-03-15
Peter Geo
g
h
egan
Notice that
h
eap pa
g
e
ha
s
dea
d
it
e
ms during
V
ACUUM
.
commit
|
commitdiff
|
tree
2021-03-12
P
e
ter G
e
oghegan
Consolidate nbtree
V
ACUUM metapage
rout
i
nes
.
commit
|
commitdiff
|
tree
2021-03-11
P
eter Geo
g
h
e
g
a
n
Save a
few cycles duri
n
g nbtree VACUUM
.
commit
|
commitdiff
|
tree
2021-03-11
Peter
G
e
oghega
n
Add back vacuum_cleanup_i
n
dex_scale_factor
p
a
rameter
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geogheg
a
n
Doc
:
B-Tree only has one ad
d
itional parameter
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geoghegan
VACUUM ANALYZE: Always upda
t
e
p
g_class
.
reltup
l
es
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-11
Peter Geogh
e
g
a
n
Don't consider newly inser
t
e
d
tuples in nbtree VACU
U
M
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-02
P
e
ter Geoghegan
nb
t
ree page deletion: Add leaf
t
oppa
r
ent assertion
.
commit
|
commitdiff
|
tree
2021-03-02
Peter Geoghegan
F
ix nbtree pag
e
deletion error message
s
.
commit
|
commitdiff
|
tree
next