[GENERAL] Contrib build fault for pgdg postgres 9.2 at debian 6 (squeeze)

rg/pub/repos/apt/ squeeze-pgdg/main amd64 Packages 100 /var/lib/dpkg/status 8.4.21-0squeeze1 0 500 http://mirror.yandex.ru/debian/ squeeze/main amd64 Packages 8.4.20-0squeeze1 0 500 http://security.debian.org/ squeeze/updates/main amd64 Packages -- Sergey Burladyan

[GENERAL] xlog min recovery request is past current point -- is it real problem?

led by gcc (Debian 4.7.2-5) 4.7.2, 64-bit I promote standby to master, get backup from it and start new standby from this backup. After all I get 43 messages like this in new standby log. -- Sergey Burladyan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

[GENERAL] How to detect txid visibility on standby server?

=> 0 So, txid_visible_in_snapshot say what 9098493097 is visible, but realy it is not, it still not commited on master and count on standby return 0 rows. PS: And what does it exactly mean to get txid_current_snapshot() from standby? -- Sergey Burladyan

Re: [GENERAL] freeze cannot be finished

nxid never updated. [1] src/backend/commands/vacuumlazy.c -- Sergey Burladyan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] database is bigger after dump/restore - why? (60 GB to 109 GB)

Aleksey Tsalolikhin writes: > Now just past weekend we upgraded our production server by pg_dump > and pg_restore, and again the database is 109 GB in size! Which character encoding of the source and target database? -- Sergey Burladyan -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] Libpq memory leak

309644 7.6 ./pg-test-bytea-free *** inBuffer 0x7f2a946cf010 inBufSize 536870912 inStart 62914589 inCursor 62914589 inEnd 62914589 You are with 309644 RSS at the end. As i can understand Vladimir, he have many clients reading bytea in one server like this and he is trying to reduce memory consumption. -- Sergey Burladyan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Defer a functional index calculation?

nto get_root_id(example), after this you can start searching for root not from current id but from it parent_id. Parent is already exist in table. If parent_id is null - it is root and get_root_id(example) do not need scan table and will return example.id from it input argument. -- Ser