| From: | Scott Carey <scott(at)richrelevance(dot)com> |
|---|---|
| To: | Andy Colson <andy(at)squeakycode(dot)net> |
| Cc: | Gnanakumar <gnanam(at)zoniac(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Database size growing over time and leads to performance impact |
| Date: | 2010-03-31 20:37:15 |
| Message-ID: | CB770C9C-F676-4153-8CBF-C698C253DD11@richrelevance.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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 CLUSTER on some column set that doesn't necessarily have an index.
> -Andy
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2010-03-31 20:47:31 | Re: Database size growing over time and leads to performance impact |
| Previous Message | Igor Neyman | 2010-03-31 19:16:45 | Re: Live sort-of-'warehousing' database how-to? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2010-03-31 20:47:31 | Re: Database size growing over time and leads to performance impact |
| Previous Message | David Wilson | 2010-03-31 18:44:44 | Re: query has huge variance in execution times |