pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAuto Vacuum Problem
3+ messages / 3 participants
[nested] [flat]
* Auto Vacuum Problem
@ 2007-01-24 08:49 Gauri Kanekar <meetgaurikanekar@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Gauri Kanekar @ 2007-01-24 08:49 UTC (permalink / raw)
To: pgsql-performance
Hi List,
When auto vacuum is over the dead tuple are seems to get reduced, but
physical size of database do not decreases.
We are using Postgres 8.1.3 and this are the auto vacuum settings.
autovacuum = on # enable autovacuum subprocess?
autovacuum_naptime = 900 # time between autovacuum runs, in
secs
autovacuum_vacuum_scale_factor = 0.1 # fraction of rel size before
autovacuum_analyze_scale_factor = 0.05 # fraction of rel size before
autovacuum_vacuum_cost_delay = 100 # default vacuum cost delay for
How do I make the physical size of the DB smaller without doing a full
vacuum.
Can anybody help me out in this.
--
Regards
Gauri
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Auto Vacuum Problem
@ 2007-01-24 08:54 Richard Huxton <dev@archonet.com>
parent: Gauri Kanekar <meetgaurikanekar@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Richard Huxton @ 2007-01-24 08:54 UTC (permalink / raw)
To: Gauri Kanekar <meetgaurikanekar@gmail.com>; +Cc: pgsql-performance
Gauri Kanekar wrote:
> Hi List,
>
> When auto vacuum is over the dead tuple are seems to get reduced, but
> physical size of database do not decreases.
It won't necessarily. An ordinary vacuum just keeps track of old rows
that can be cleared and re-used. A "vacuum full" is needed to compact
the table.
If you are running a normal vacuum often enough then the size of the
database should remain about the same (unless you insert more rows of
course).
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Auto Vacuum Problem
@ 2007-01-24 09:12 Heiko W.Rupp <heiko.rupp@redhat.com>
parent: Gauri Kanekar <meetgaurikanekar@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Heiko W.Rupp @ 2007-01-24 09:12 UTC (permalink / raw)
To: pgsql-performance
Hi,
> How do I make the physical size of the DB smaller without doing a
> full vacuum.
This might turn out to be counterproductive, as subsequent inserts
and updates will increase
the size of the physical database again, which might be expensive
depending on the underlying OS.
--
Heiko W.Rupp
heiko.rupp@redhat.com, http://www.dpunkt.de/buch/3-89864-429-4.html
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-01-24 09:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-24 08:49 Auto Vacuum Problem Gauri Kanekar <meetgaurikanekar@gmail.com>
2007-01-24 08:54 ` Richard Huxton <dev@archonet.com>
2007-01-24 09:12 ` Heiko W.Rupp <heiko.rupp@redhat.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox