[Gllug] SQL performance tuning (was: RE: Restore RAID0 /var)

[Richard Jones]

On Wed, Aug 26, 2009 at 02:55:07PM +0100, Walter Stanish wrote:
> Things like:
[sensible advice snipped]

and for PostgreSQL I would add: Make sure the table statistics are
kept up to date.  Otherwise the query planner tends to pessimize
instead of optimize your queries.

Rich.

-- 
Richard Jones
Red Hat
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug