Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Vacuum - Mailing list pgsql-sql

From Sascha Schumann
Subject Re: [SQL] Vacuum
Date
Msg-id 19990318205831.B11537@schell.de
Whole thread Raw
In response to Vacuum  (Tim Stoddard <tims@dcs.state.ar.us>)
Responses Re: [SQL] Vacuum  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Sascha Schumann
Date:
Subject: Re: [SQL] Vacuum
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] Vacuum