3) using PG 7.3 or less, you will also need to REINDEX these
tables+indexes often (daily?). This issue will go away
in 7.4, which should make you an early adopter of 7.4.
Is this true? Haven't heard of this before.
If so, how can this be managed in a cronjob?
For the hourly VACUUM there's vacuumdb, but is
there somehting similar like reindexdb ?
pgsql-performance by date
|Next:||From: Christopher Kings-Lynne||Date: 2003-09-18 08:24:32|
|Subject: Re: Is there a reason _not_ to vacuum continuously?|
|Previous:||From: Alexander Priem||Date: 2003-09-18 08:13:11|
|Subject: Many fields in one table or many tables?|