| From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
|---|---|
| To: | Philip Molter <philip(at)datafoundry(dot)net> |
| Cc: | Mark <mark(at)ldssingles(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: vacuum and 24/7 uptime |
| Date: | 2001-07-12 21:34:15 |
| Message-ID: | 3B4E17D7.1E94CAB5@selectacast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
Philip Molter wrote:
>
> table). We also recreate the indices on the most frequent table every
> 12 hours, since vacuum doesn't clean up after indices (again, it
> appears).
>
Are you sure about that? Since an index grows with each insert or
update they would soon take up the whole disk for any active databases.
I see in my postgres log:
DEBUG: Index ml_pkey: Pages 882; Tuples 174067: Deleted 18. CPU
0.07s/0.62u sec.
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-07-12 21:39:29 | Re: Visual Modeling programs |
| Previous Message | Somazx Interesting | 2001-07-12 21:32:12 | Re: compile error |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | E | 2001-07-12 23:33:39 | ResultSet.getString does percent substitutions |
| Previous Message | Dejan Vucinic | 2001-07-12 21:22:45 | Resolved: can't write a BLOB, 7.1.2 |