Postgres Pro
Downloads
Home   >   mailing lists

Re: : Performance Improvement Strategy - Mailing list pgsql-performance

From Greg Smith
Subject Re: : Performance Improvement Strategy
Date
Msg-id 4E7A259F.9060401@2ndQuadrant.com
Whole thread Raw
In response to Re: : Performance Improvement Strategy  (Venkat Balaji <venkat.balaji@verse.in>)
Responses Re: : Performance Improvement Strategy  (Venkat Balaji <venkat.balaji@verse.in>)
Re: : Performance Improvement Strategy  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view 
On 09/21/2011 12:13 PM, Venkat Balaji wrote:
> I as a DBA, suggested to perform VACUUM FULL and RE-INDEXING + ANALYZE
> to ensure that IO performance and Indexing performance would be good


Read http://wiki.postgresql.org/wiki/VACUUM_FULL before you run VACUUM
FULL.  You probably don't want to do that.  A multi-gigabyte table can
easily be unavailable for several hours if you execute VACUUM FULL
against it.  CLUSTER is almost always faster.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions
Next
From: Venkat Balaji
Date:
Subject: Re: : Performance Improvement Strategy