| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Pavel Rotek <pavel(dot)rotek(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Toast space grows |
| Date: | 2008-03-07 13:19:25 |
| Message-ID: | 20080307131925.GC11041@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Pavel Rotek escribió:
> 2008/3/7, Bill Moran <wmoran(at)collaborativefusion(dot)com>:
> > Don't do vacuum full on this table. Do frequent vacuums. The table will
> > bloat some, but not 10x the required size, once you find a reasonable
> > frequency for vacuums. You might find it practical to manually vacuum
> > this table from your application after insert and update operations.
>
> I perform autovacuum daily.
Sorry, this sentence makes no sense. Do you mean that you set
autovacuum_naptime=1 day? If so, that's a bad idea -- you should let
autovacuum run far more frequently.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-03-07 13:33:19 | Re: Toast space grows |
| Previous Message | Pavel Rotek | 2008-03-07 12:59:46 | Re: Toast space grows |