[ADMIN] Problems with vacuum

2013-09-04 Thread JotaComm
Hello, everbody I have the following problem: My vacuum is running since 2013-08-27 18:58: 41.527238-03. billing=# SELECT localtimestamp(0); -[ RECORD 1 ]-- timestamp | 2013-09-04 11:23:06 billing=# SELECT pg_stat_activity.procpid,pg_ stat_activity.current_query,pg_stat_activity.

Re: [ADMIN] Problems with vacuum

2013-09-04 Thread Igor Neyman
From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of JotaComm Sent: Wednesday, September 04, 2013 10:57 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Problems with vacuum Hello, everbody I have the following problem: My vacuum is running since 2013

Re: [ADMIN] Problems with VACUUM and "dead row versions cannot be removed yet"

2006-10-18 Thread Tom Lane
Nolan Cafferky <[EMAIL PROTECTED]> writes: > I've got an admin_sessions table on a postgres 8.0.8 server that gets > updated frequently, with about 30 live rows at any given time. We > VACUUM the table nightly, which has served us with no problems for quite > some time. Well, this morning we n

[ADMIN] Problems with VACUUM and "dead row versions cannot be removed yet"

2006-10-18 Thread Nolan Cafferky
I've got an admin_sessions table on a postgres 8.0.8 server that gets updated frequently, with about 30 live rows at any given time. We VACUUM the table nightly, which has served us with no problems for quite some time. Well, this morning we noticed some seriously slow queries against the tab