Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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 A. Ghiurea

Canadian Astronomy Data Centre |
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


pgsql-admin by date

Next:From: Tom LaneDate: 2012-07-05 04:18:03
Subject: Re: auto vacuum errors
Previous:From: Akash KodibailDate: 2012-07-04 18:30:00
Subject: Delay in completion of aggregation inserts when run in a single commit - PG 9.1.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group