Re: Database performance (was Re: )

[A.L.M.Buxey@lboro.ac.uk]

Hi,

> >  Any suggestion for improving the throughput and accelerating the queries?
> 
>   Index the tables.
> 
>   Increasing database performance is usually documented on the database
> web site.

depending on version of PostGreSQL you may also need to 'vacuum' the database
to clean up nodes etc - once again, check the database documentation site.

alan