Re: : Performance Improvement Strategy
| От | Greg Smith |
|---|---|
| Тема | Re: : Performance Improvement Strategy |
| Дата | |
| Msg-id | 4E7A259F.9060401@2ndQuadrant.com обсуждение исходный текст |
| Ответ на | Re: : Performance Improvement Strategy (Venkat Balaji <venkat.balaji@verse.in>) |
| Ответы |
Re: : Performance Improvement Strategy
Re: : Performance Improvement Strategy |
| Список | 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@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
В списке pgsql-performance по дате отправления: