> Would CLUSTER / REINDEX still have an effect if our queries were done
> via sequential scan?
SELECTS don't write to the database, so they have no effect at all on
vacuuming/analyzing. You only need to worry about that with writes.
> This is a old database (as in built by me when i
> was just starting to learn unix / postgres) so the database design is
> pretty horrible (little normalisation, no indexes).
No indexes? Bloody hell :D
Use EXPLAIN ANALYZE SELECT ... ; on all of your selects to see where
they are slow and where you can add indexes...
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2005-05-25 03:01:28|
|Subject: Re: Can anyone explain this: duplicate dbs. |
|Previous:||From: John A Meinel||Date: 2005-05-25 03:00:34|
|Subject: Re: Can anyone explain this: duplicate dbs.|