Postgres Pro
Downloads
Home   >   mailing lists

Re: Database size growing over time and leads to performance impact - Mailing list pgsql-performance

From Scott Carey
Subject Re: Database size growing over time and leads to performance impact
Date
Msg-id CB770C9C-F676-4153-8CBF-C698C253DD11@richrelevance.com
Whole thread Raw
In response to Re: Database size growing over time and leads to performance impact  (Andy Colson <andy@squeakycode.net>)
Responses Re: Database size growing over time and leads to performance impact  (Robert Haas <robertmhaas@gmail.com>)
Re: Database size growing over time and leads to performance impact  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
Tree view 
On Mar 27, 2010, at 6:35 AM, Andy Colson wrote:
>
> Dont "VACUUM FULL", its not helping you, and is being removed in newer versions.
>

Off topic:  How is that going to work?  CLUSTER doesn't work on tables without an index.  I would love to be able to
CLUSTERon some column set that doesn't necessarily have an index. 

> -Andy
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: David Wilson
Date:
Subject: Re: query has huge variance in execution times
Next
From: Robert Haas
Date:
Subject: Re: Database size growing over time and leads to performance impact