| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Autovaccum |
| Date: | 2006-12-19 14:23:00 |
| Message-ID: | 20061219152300.6d155f87@kingfisher.sec.intern.logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi, Ezequias,
"Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> wrote:
> What is the interval of time the vacuum will run on my database ?
That depends on your settings and load.
Autovacuum looks at every table, and checks the number of
modifications, as well as the total number of transactions since the
last vacuum, and decides whether to VACUUM and/or ANALYZE.
The thresholds for those settings can be configured per table, with the
defaults in the postgresql.conf.
Regards,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2006-12-19 14:57:03 | Re: null values in non-nullable column |
| Previous Message | Carlos Santos | 2006-12-19 14:01:05 | Query a select that returns all the fields of an specific value of primary key without knownig the name of the single column's primary key? |