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: 4FF499F0.9030601@nrc-cnrc.gc.ca (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group