pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedVacuum
4+ messages / 4 participants
[nested] [flat]
* Vacuum
@ 1999-03-18 14:41 Tim Stoddard <tims@dcs.state.ar.us>
1999-03-18 19:58 ` Re: [SQL] Vacuum Sascha Schumann <schumann@schell.de>
0 siblings, 1 reply; 4+ messages in thread
From: Tim Stoddard @ 1999-03-18 14:41 UTC (permalink / raw)
To: pgsql-general@postgresql.org.pgsql-sql
When I delete 2k-3k of records from a table the vacuum process seems
to take forever. I have let the vacuum run for 24 hours before with
not luck.
Can someone one explain to me what is going on?
--
Tim Stoddard
======================================================================
Open Systems UNIX
In a world without fences, who needs Gates? -- Unknown
======================================================================
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Vacuum
1999-03-18 14:41 Vacuum Tim Stoddard <tims@dcs.state.ar.us>
@ 1999-03-18 19:58 ` Sascha Schumann <schumann@schell.de>
1999-03-18 20:14 ` Re: [SQL] Vacuum Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Sascha Schumann @ 1999-03-18 19:58 UTC (permalink / raw)
To: Tim Stoddard <tims@dcs.state.ar.us>; +Cc: pgsql-sql
On Thu, Mar 18, 1999 at 08:41:21AM -0600, Tim Stoddard wrote:
> When I delete 2k-3k of records from a table the vacuum process seems
> to take forever. I have let the vacuum run for 24 hours before with
> not luck.
>
> Can someone one explain to me what is going on?
Funny, there is/was just a whole thread about that on hackers. There seem to
be some agreement that this will be reworked/faster in 6.6, but you cannot
avoid it currently. The main cause for this is the usage of indeces.
Did you pass -o -F to the postmaster? It can improve the speed of PostgreSQL
dramatically.
--
Regards,
Sascha Schumann |
Consultant | finger sas@schell.de
| for PGP public key
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Vacuum
1999-03-18 14:41 Vacuum Tim Stoddard <tims@dcs.state.ar.us>
1999-03-18 19:58 ` Re: [SQL] Vacuum Sascha Schumann <schumann@schell.de>
@ 1999-03-18 20:14 ` Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 1999-03-18 20:14 UTC (permalink / raw)
To: sas@schell.de; +Cc: tims@dcs.state.ar.us; pgsql-sql
-- Start of included mail.
> On Thu, Mar 18, 1999 at 08:41:21AM -0600, Tim Stoddard wrote:
> > When I delete 2k-3k of records from a table the vacuum process seems
> > to take forever. I have let the vacuum run for 24 hours before with
> > not luck.
> >
> > Can someone one explain to me what is going on?
>
> Funny, there is/was just a whole thread about that on hackers. There seem to
> be some agreement that this will be reworked/faster in 6.6, but you cannot
> avoid it currently. The main cause for this is the usage of indeces.
>
> Did you pass -o -F to the postmaster? It can improve the speed of PostgreSQL
> dramatically.
This vacuum speedup may be in 6.5, thanks to Vadim.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 4+ messages in thread
* Vacuum.
@ 2001-03-05 23:48 Grant <grant@conprojan.com.au>
0 siblings, 0 replies; 4+ messages in thread
From: Grant @ 2001-03-05 23:48 UTC (permalink / raw)
To: pgsql-sql
Does vacuuming and analyzing a database affect the users if they are
currently inserting/deleting rows from a table on the database? How does
it work exactly...
Thanks.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-03-05 23:48 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-18 14:41 Vacuum Tim Stoddard <tims@dcs.state.ar.us>
1999-03-18 19:58 ` Sascha Schumann <schumann@schell.de>
1999-03-18 20:14 ` Bruce Momjian <maillist@candle.pha.pa.us>
2001-03-05 23:48 Vacuum. Grant <grant@conprojan.com.au>
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