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
Doc: Remove MultiXact wraparound section link.
2022-04-02
Peter Geoghegan
Doc: Remove
MultiXact wrapa
r
o
und section link
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-03-13
P
eter
G
e
oghegan
VACU
U
M V
E
RBOSE: tweak sc
a
n
ned_pag
e
s log
i
c
.
commit
|
commitdiff
|
tree
2022-03-12
Peter Geog
h
egan
vacuumlazy
.
c: Standardize rel_
p
ag
e
s terminology
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-03-12
Peter G
e
oghegan
v
a
cuumlazy
.
c: document vistes
t
and Old
e
stXmin
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-03-12
Pet
e
r Geoghegan
N
o
rmal
i
ze he
a
p
_prepare_fr
e
e
z
e_tuple a
r
g
ument name
.
commit
|
commitdiff
|
tree
2022-02-25
Peter Geo
g
h
egan
vacuumlaz
y
.
c
:
Remove ob
s
olete nu
m
_tuples field
.
commit
|
commitdiff
|
tree
2022-02-25
Peter
G
eoghegan
Remove unnecessary heap_tuple_needs_freeze argument
.
commit
|
commitdiff
|
tree
2022-02-17
Pete
r
Geo
g
hegan
I
ncr
e
as
e
hash_me
m
_multip
l
ier default
t
o 2
.
0
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-17
Peter Geoghe
g
a
n
Avoid VACUUM reltuples distortion
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-15
Pet
e
r
G
eoghegan
Update
"don't tru
n
cate with failsafe" rationale
.
commit
|
commitdiff
|
tree
2022-02-12
P
e
ter Geoghegan
C
o
nsolidate
VACUUM xid cutoff
logi
c
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-12
Peter
G
eog
h
egan
A
d
d VA
C
UU
M
i
n
s
trumentation fo
r
s
c
anned
p
a
ge
s
, relfrozenx
i
d
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-02-11
Peter Geo
g
hegan
Simplify l
a
z
y_s
c
an_heap'
s
handl
i
ng of scanned pages
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-29
Pe
t
er Geo
g
hegan
v
a
c
uuml
a
zy
.
c: Rename state fie
l
d fo
r
consis
t
ency
.
commit
|
commitdiff
|
tree
2022-01-15
Peter
G
eog
h
egan
Un
i
fy VAC
U
UM V
E
RBOSE an
d
auto
v
a
c
uum lo
g
gin
g
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-12
P
e
ter Ge
o
ghegan
Fix memory leak i
n
in
d
exUnchanged hint mechanism
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2022-01-12
Pete
r
Geogheg
a
n
va
c
uu
m
laz
y
.
c: f
i
x
"
garbage tuple
s
"
r
ef
e
re
n
ce
.
commit
|
commitdiff
|
tree
2021-12-09
Peter Geoghegan
St
a
ndardize
cleanup lock te
r
m
i
nol
o
gy
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-30
Peter Geoghegan
v
a
cuumlazy
.
c
: f
i
x re
m
ai
n
ing "dead tuple" reference
s
.
commit
|
commitdiff
|
tree
2021-11-29
Peter Geo
g
heg
a
n
vacuumlazy
.
c
:
Rename dead
_
tuples to dead_items
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-28
Peter Geoghega
n
vacuumlazy
.
c: prefer t
h
e
term "cleanup lock"
.
commit
|
commitdiff
|
tree
2021-11-27
Peter Geogh
e
gan
Update high level vacuumlazy
.
c comm
e
nts
.
commit
|
commitdiff
|
tree
2021-11-26
P
eter Geoghe
g
an
Go
back to consid
e
ring H
O
T on
p
ages marked fu
l
l
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-22
Pe
t
er
G
eo
g
hega
n
Remove lazy_
s
can_heap p
a
rallel V
A
CUUM comment block
.
commit
|
commitdiff
|
tree
2021-11-13
Pet
e
r
G
eo
g
he
g
a
n
Explain pruning pg
s
tats accounting
subtle
t
i
es
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-11
Peter Geogh
e
gan
U
p
date heap_page_p
r
u
ne() f
r
ee space map comments
.
commit
|
commitdiff
|
tree
2021-11-11
P
e
ter Geogh
e
gan
Update an
o
ther
o
bsol
e
t
e reference in vacuumla
z
y
.
c
.
commit
|
commitdiff
|
tree
2021-11-06
Pet
e
r Geog
h
egan
U
p
date obsolete refer
e
n
ce in vacuumlazy
.
c
.
commit
|
commitdiff
|
tree
2021-11-05
Peter Ge
o
ghegan
Upd
a
te obsolete h
e
ap
p
runing comm
e
n
t
s
.
commit
|
commitdiff
|
tree
2021-11-05
Peter Geoghegan
Add
hardening to cat
c
h in
v
alid TIDs in
in
d
exes
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-05
Peter
Geoghegan
Add
v
arious assert
i
ons
t
o h
e
ap pruning
code
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-11-04
Peter Geoghegan
Add another old commi
t
to
g
it-bla
m
e-igno
r
e-revs
.
commit
|
commitdiff
|
tree
2021-11-03
Peter Ge
o
ghegan
Fix par
a
llel amvacuu
m
cleanup saf
e
ty bug
.
commit
|
commitdiff
|
tree
2021-11-02
P
e
ter Geoghegan
Don't overlook indexes dur
i
ng parallel VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-29
P
e
ter Geoghegan
D
emote pg_unreac
h
able(
)
in h
e
apam to an assertion
.
commit
|
commitdiff
|
tree
2021-10-27
P
e
ter Geoghegan
Remove obsolete nb
t
ree LP_DEAD item comme
n
ts
.
commit
|
commitdiff
|
tree
2021-10-27
Peter
G
eo
g
hegan
Fix orderi
n
g
of items in nbt
r
e
e error messag
e
.
commit
|
commitdiff
|
tree
2021-10-27
P
e
ter Geoghegan
F
urthe
r
harden
n
btr
e
e p
o
sting split
code
.
commit
|
commitdiff
|
tree
2021-10-15
Peter
G
eogh
e
gan
Remove obsolete
n
b
tree
d
eduplicati
o
n com
m
ents
.
commit
|
commitdiff
|
tree
2021-10-14
P
eter Geoghegan
Remov
e
unstable pg_amch
e
ck
t
ests
.
commit
|
commitdiff
|
tree
2021-10-13
Pet
e
r Geoghegan
p
g
_am
c
heck: avoid unhelpful
v
erif
i
ca
t
i
on att
e
mp
t
s
.
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-12
Peter Geoghega
n
Doc: normalize v
a
cuum_multi
x
act_failsafe
_
age I
D
.
commit
|
commitdiff
|
tree
2021-10-12
P
eter Geoghegan
amchec
k
: Skip unl
o
gg
e
d rel
a
tio
n
s
in Ho
t
Stan
d
by
.
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-10-03
Peter Geoghegan
Enable
dedupl
i
cation in sys
t
em catal
o
g index
e
s
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-27
Peter Ge
o
ghegan
Rem
o
ve
un
n
eeded nbtree latestRemo
v
edXid com
m
e
n
ts
.
commit
|
commitdiff
|
tree
2021-09-25
Peter Ge
o
ghegan
U
p
date o
b
solete nb
t
re
e
d
eletion comments
.
commit
|
commitdiff
|
tree
2021-09-25
Peter
G
eoghe
g
an
vacuumlazy
.
c
: Remove o
b
s
o
lete 'onec
a
l
l
' c
o
mment
.
commit
|
commitdiff
|
tree
2021-09-24
Pe
t
e
r
G
eoghegan
nbtree REA
D
M
E
:
A
dd note a
b
out la
t
estR
e
movedXid
.
commit
|
commitdiff
|
tree
2021-09-23
Peter Ge
o
ghegan
Docume
n
t
issu
e
w
i
t
h heapam
l
i
ne
p
o
inter tru
n
cation
.
commit
|
commitdiff
|
tree
2021-09-22
Peter Geoghegan
Fix "single value strategy" inde
x
deletion iss
u
e
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-20
Peter Geog
h
egan
Remove ove
r
zealous i
n
dex del
e
tion asse
r
ti
o
n
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-17
Peter Geogh
e
gan
pageinspect:
M
a
ke p
a
ge deletio
n
e
l
og less ch
a
tty
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-09-01
P
e
t
e
r Geoghegan
VACUUM
VERBOS
E
:
Don't report "pages removed"
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-31
P
et
e
r Geoghe
g
an
Remove obs
o
lete nbtree
relation
e
xtension comment
.
commit
|
commitdiff
|
tree
2021-08-31
Peter
G
e
o
ghegan
vacuum
l
azy
.
c: Correc
t
pru
n
e state com
m
ent
.
commit
|
commitdiff
|
tree
2021-08-31
Peter Geoghegan
R
emov
e
u
n
need
e
d
old_rel_p
a
ges VAC
U
UM
state field
.
commit
|
commitdiff
|
tree
2021-08-31
Pete
r
Geoghegan
Add historic
c
ommit to g
i
t
-
blame-ign
o
re-r
e
vs file
.
commit
|
commitdiff
|
tree
2021-08-27
Pe
t
er
G
eogh
e
ga
n
t
r
ack_
i
o_t
i
ming logging: Don't special case 0
m
s
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-27
Peter Geog
h
egan
R
eor
d
er log_autovacuum_
m
in_duration log out
p
ut
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-08-27
Pe
t
er
Geoghegan
vacu
u
mlazy
.
c: Remov
e
u
n
neces
s
ary parenthese
s
.
commit
|
commitdiff
|
tree
2021-08-27
P
e
te
r
Geoghegan
contrib/amcheck: Add h
e
apam CHECK
_
FOR_I
N
TERRUP
T
S()
.
commit
|
commitdiff
|
tree
2021-08-04
Peter
G
eoghegan
Make vacuum_index_
c
lea
n
up rel
o
pt
i
on
RELOPT_TYPE_ENU
M
.
commit
|
commitdiff
|
tree
2021-07-20
P
e
t
er Geoghegan
Do
c
: vacuum_multix
a
ct_
f
ailsafe_age
is multix
a
ct-based
.
commit
|
commitdiff
|
tree
2021-07-20
Peter Geog
h
egan
vacuum
d
b: C
o
rrect comment
about --for
c
e-index-cl
e
anup
.
commit
|
commitdiff
|
tree
2021-06-28
Pete
r
Geoghegan
Imp
r
ove pgin
d
ent r
e
lease wo
r
kfl
o
w
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-28
Peter Geoghega
n
Add pgindent comm
i
t to git-blame-ignore-revs f
i
le
.
commit
|
commitdiff
|
tree
2021-06-22
Peter G
e
oghega
n
Add l
i
st
o
f ig
n
orab
l
e
pgindent commits for git
-
blame
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-21
Pe
t
er Geoghegan
Remove o
v
erzealous VAC
U
UM failsafe assertions
.
commit
|
commitdiff
|
tree
2021-06-19
Pe
t
er Geoghegan
Supp
o
r
t
dis
a
bling in
d
ex bypassin
g
by
VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-06-15
Pe
t
er
Geoghegan
Remove unne
e
ded
f
ield from VAC
U
UM state
.
commit
|
commitdiff
|
tree
2021-05-28
Peter Geoghegan
Fix VACUU
M
VERBOSE's LP_DEAD ite
m
pages out
p
ut
.
commit
|
commitdiff
|
tree
2021-05-25
Peter Geoghegan
C
o
nsi
d
e
r
triggering VAC
U
UM failsafe during
s
can
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-05-14
P
eter Geoghegan
Har
d
en nb
t
ree deduplicatio
n
post
i
ng split code
.
commit
|
commitdiff
|
tree
2021-05-13
Peter
G
eoghegan
F
i
x au
t
ovacuu
m
l
og output heap tr
u
ncat
i
on issue
.
commit
|
commitdiff
|
tree
2021-05-06
P
e
ter Geogheg
a
n
R
e
move overzealous VACUUM vi
s
ibility m
a
p asse
r
tio
n
.
commit
|
commitdiff
|
tree
2021-04-23
P
eter
G
e
oghegan
amc
h
eck: MAXAL
I
G
N() nbtree sp
e
cial area offset
.
commit
|
commitdiff
|
tree
2021-04-20
Peter Geoghega
n
Document LP_DEAD a
c
count
i
ng issues in VACUUM
.
commit
|
commitdiff
|
tree
2021-04-13
Pet
e
r Geoghegan
Do
n
't t
r
uncate
heap when VA
C
UUM's failsafe
is in effect
.
commit
|
commitdiff
|
tree
2021-04-08
Pet
e
r Geoghega
n
Si
l
ence another _bt_chec
k
_unique compiler warn
i
ng
.
commit
|
commitdiff
|
tree
2021-04-07
Peter Geoghe
g
an
Teach VACUUM t
o
bypass u
n
necessary i
n
dex v
a
cuuming
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-07
Peter Geoghegan
Ad
d
wrap
a
round f
a
ilsafe t
o
VA
C
UUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-07
Peter Geog
h
egan
Truncate line pointe
r
arr
a
y
d
uri
n
g
VACUUM
.
Author:
Peter Geoghegan
<pg@bowt.ie>
Reviewed-By:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Geog
h
egan
Remov
e
t
u
p
gone spec
i
al c
a
se from vacuu
m
lazy
.
c
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Pe
t
e
r
G
e
oghe
g
an
R
e
f
act
o
r laz
y
_scan_heap() loop
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-04-06
Peter Geoghegan
Alloc
a
te ac
c
es
s
strateg
y
in parallel
V
ACUUM
w
orkers
.
commit
|
commitdiff
|
tree
2021-04-05
P
eter Ge
o
g
h
egan
Propagate
parallel VACUU
M
'
s
buffer ac
c
ess
strategy
.
commit
|
commitdiff
|
tree
2021-04-05
Peter G
e
o
g
h
eg
a
n
Si
m
pl
i
fy state ma
n
a
g
e
d by VA
C
UU
M
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-29
Peter Geoghegan
PageAddItemExtended(): Ad
d
LP_UNUSED assertion
.
commit
|
commitdiff
|
tree
2021-03-23
Pete
r
Geoghegan
nb
t
r
e
e
V
ACUUM: Cope with buggy opcla
s
ses
.
commit
|
commitdiff
|
tree
2021-03-21
Pete
r
Geoghe
g
an
R
e
c
y
cle nbtree pa
g
es deleted during same VACU
U
M
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-16
Peter Geog
h
egan
Fix
c
omme
n
t about pro
m
isin
g
tuples
.
commit
|
commitdiff
|
tree
2021-03-16
P
e
ter
G
e
oghegan
amcheck: Reduce debug mess
a
ge
v
erb
o
sity
.
commit
|
commitdiff
|
tree
2021-03-15
P
e
ter
G
eogheg
a
n
N
ot
i
c
e
that heap page has d
e
ad
items during
V
ACUUM
.
commit
|
commitdiff
|
tree
2021-03-12
Pete
r
Geog
h
egan
C
onsolidate nbtree VACUUM metapage routines
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geogh
e
gan
Sa
v
e a few cycles during nbtree VACUUM
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geoghegan
Ad
d
bac
k
v
acuum_cleanup_ind
e
x_scale_facto
r
parameter
.
commit
|
commitdiff
|
tree
2021-03-11
Pe
t
er Geoghegan
D
o
c: B-
T
re
e
o
nly h
a
s one addi
t
ional
p
aram
e
ter
.
commit
|
commitdiff
|
tree
2021-03-11
Peter Geoghegan
VA
C
UUM ANAL
Y
ZE: Always
u
pdate
p
g
_class
.
reltuples
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-11
Peter Geoghegan
Don't co
n
sider
n
ewly inserte
d
tu
p
les
i
n
n
b
t
r
ee VAC
U
U
M
.
Author:
Peter Geoghegan
<pg@bowt.ie>
commit
|
commitdiff
|
tree
2021-03-02
Peter Geoghegan
nbt
r
ee page deletion:
Add lea
f
toppa
r
ent assertio
n
.
commit
|
commitdiff
|
tree
next