Re: [ADMIN] Postgres 9.1 statistics in pg_stat_database

2013-02-07 Thread Tom Lane
Steve Crawford writes: > Additionally (correct me if I'm wrong, Tom), background activity like > autovacuum will generate countable transactions. Yes, absolutely. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to yo

Re: [ADMIN] Postgres 9.1 statistics in pg_stat_database

2013-02-07 Thread Steve Crawford
On 02/07/2013 11:05 AM, Tom Lane wrote: =?utf-8?q?Milos_Gajdos?= writes: What this shows is that xact_commit increases by 3 after just one row insert. tup_inserted does seem to report correct value. After simple SELECT, xact_commit increases by 2 - kind of strange as SELECT shouldn't really b

Re: [ADMIN] Postgres 9.1 statistics in pg_stat_database

2013-02-07 Thread Tom Lane
=?utf-8?q?Milos_Gajdos?= writes: > What this shows is that xact_commit increases by 3 after just one row insert. > tup_inserted does seem to report correct value. After simple SELECT, > xact_commit increases by 2 - kind of strange as SELECT shouldn't really be > increasing xact_commit ? Yes, a

[ADMIN] Postgres 9.1 statistics in pg_stat_database

2013-02-07 Thread Milos Gajdos
I've been searching for some information about Postgres 9.1 stats which are stored in pg_stat_database - on the web and on IRC. I found SOME information for 9.2 but even that doesn't seem to be accurate. What I'm after is to get proper transaction stats ie commits and rollbacks. Also I've no clu

Re: [ADMIN] Unexpected chunk size when doing dump

2013-02-07 Thread Tom Lane
Vasiliy I Ozerov writes: > I have an error, when doing database dump: > pg_dump: [archiver (db)] query failed: ERROR: unexpected chunk size 384 > (expected 389) in final chunk 1 for toast value 11589 in pg_toast_2619 That looks like a data corruption problem :-(. You might want to check into

Re: [ADMIN] Postgres en Cluster

2013-02-07 Thread Jaime Casanova
On Thu, Feb 7, 2013 at 8:50 AM, ALEXANDER JOSE wrote: > What may be the best strategy for working postgres in cluster, i would recommend http://repmgr.org/ which will help you to configure and administrate a postgres cluster. > now I have > two postgres servers SuSE Linux Enterprise 11, and post

[ADMIN] Postgres en Cluster

2013-02-07 Thread ALEXANDER JOSE
What may be the best strategy for working postgres in cluster, now I have two postgres servers SuSE Linux Enterprise 11, and postgres database is at version 9.0.4. Atentamente Alexander DBA venezuela

Re: [ADMIN] PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax

2013-02-07 Thread Scott Ribe
On Feb 6, 2013, at 5:58 PM, Mel Llaguno wrote: > Any pointers which would explain these differences would be greatly > appreciate. Postgres is likely not the only thing on your system that allocates shared memory. -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 72

[ADMIN] Unexpected chunk size when doing dump

2013-02-07 Thread Vasiliy I Ozerov
Good day! I have an error, when doing database dump: psql -U postgres -p 56432 postgres > postgres.sql pg_dump: [archiver (db)] query failed: ERROR: unexpected chunk size 384 (expected 389) in final chunk 1 for toast value 11589 in pg_toast_2619 pg_dump: [archiver (db)] query was: SELECT desc

Re: [ADMIN] PostgreSQL's share_buffer calculation using shmget() versus kernel.shmmax

2013-02-07 Thread K P Manoj
Hi , You are mentioned SHMMAX larger value is no harm for the database , can i keep this value as 100% of RAM ? Right now we have two cluster in this server , one is having 8 GB and other 2 GB shared buffer . But i am facing some issue , OS cache is filled frequently once i run some query o