Re: : Performance Improvement Strategy

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: : Performance Improvement Strategy
Date: 2011-09-21 17:57:51
Message-ID: 4E7A259F.9060401@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Venkat Balaji 2011-09-21 18:18:39 Re: : Performance Improvement Strategy
Previous Message Tom Lane 2011-09-21 17:11:00 Re: [PERFORM] Constraint exclusion on UNION ALL subqueries with WHERE conditions