Re: [ADMIN] Postgres 9.1 statistics in pg_stat_database

2013-09-04 Thread boraldomaster
Let me show you my statistics, that confuses me even in terms of this discussion. What am I doing. 1. Create a database *highload*. 2. Execute *select xact_commit from pg_stat_database where datname = 'highload'* from neighbouring database (so that xact_commit is counted to that neighbour) and rec

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-

[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.