From: | Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | auto vacuum errors |
Date: | 2012-07-04 19:30:56 |
Message-ID: | 4FF499F0.9030601@nrc-cnrc.gc.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
HI Gurus
I'm seeing a issue with some temp tables in contrib_regression db , the
auto vacuum job will not run for this tables due some files/QID's
missing how can I fix this ?
The temp tables are growing too fast and they don't get
empty/clean-up...any tips ? I 'm running PGSQL 8.3.6 on RHES.
Isabella
--
-----------------------------------------------------------
Isabella A. Ghiurea
Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca
Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html
National Research Council of Canada, Herzberg Institute of Astrophysics
5071 West Saanich Road, Victoria BC V9E 2E7, Canada
Phone: 250 363-3446 fax: 250 363-0045
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-07-05 04:18:03 | Re: auto vacuum errors |
Previous Message | Akash Kodibail | 2012-07-04 18:30:00 | Delay in completion of aggregation inserts when run in a single commit - PG 9.1.2 |