auto vacuum errors

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

Responses

Browse pgsql-admin by date

  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