Re: Can anyone explain this: duplicate dbs.

> 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...

Chris