| From: | Sascha Schumann <schumann(at)schell(dot)de> |
|---|---|
| To: | Tim Stoddard <tims(at)dcs(dot)state(dot)ar(dot)us> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Vacuum |
| Date: | 1999-03-18 19:58:31 |
| Message-ID: | 19990318205831.B11537@schell.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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(at)schell(dot)de
| for PGP public key
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-03-18 20:14:16 | Re: [SQL] Vacuum |
| Previous Message | Ross J. Reedstrom | 1999-03-18 19:56:32 | Re: [GENERAL] editing file after pg_dump |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-03-18 20:14:16 | Re: [SQL] Vacuum |
| Previous Message | Tim Stoddard | 1999-03-18 14:41:21 | Vacuum |