[HACKERS] Burst in WAL size when UUID is used as PK while full_page_writes are enabled

will be required to store the same number of rows and hence there can be increase in WAL size due to FPW . When compared the index size in local setup UUID index is ~2x greater in size. Thanks, Sanyam Jain

[HACKERS] Start logical decoding from any lsn present in the wal segment

, what are the steps i should perform to implement the same. Thanks, Sanyam Jain

Re: [HACKERS] pgjdbc logical replication client throwing exception

Hi, I suspect its happening because of delay in status update by client but even after trying forceUpdateStatus its quitting prematurely. Thanks, Sanyam Jain From: sanyam jain <sanyamjai...@live.in> Sent: Tuesday, June 27, 2017 6:47:55 AM To: Peter Eise

Re: [HACKERS] pgjdbc logical replication client throwing exception

Hi, >What does the server log say? If nothing interesting, turn up debugging. I receive the following Log on server LOG: could not send data to client: Broken pipe Thanks, Sanyam Jain

Re: [HACKERS] Logical decoding on standby

y. Please anyone with experience can explain whether the steps i have done are correct or not. Thanks, Sanyam Jain

[HACKERS] pgjdbc logical replication client throwing exception

(QueryExecutorImpl.java:1161) at org.postgresql.core.v3.QueryExecutorImpl.readFromCopy(QueryExecutorImpl.java:1026) ... 5 more PG Server reports a broken pipe. Can someone please tell what can be wrong?Its happening only when i add millions of rows. Thanks, Sanyam Jain

Re: [HACKERS] Logical decoding on standby

nction call to GetStandbyFlushRecPtr in StartLogicalReplication which updates ThisTimeLineID. After the above two changes timeline following is working.But i'm not sure whether this is correct or not.In any case please someone clarify. Thanks, Sanyam Jain

Re: [HACKERS] Logical decoding on standby

meline following patch alone pg_recvlogical quits in startup phase but when i made the above change pg_recvlogical works although timeline following doesn't work. Thanks, Sanyam Jain From: pgsql-hackers-ow...@postgresql.org <pgsql-hackers-ow...@postg

Re: [HACKERS] Why forcing Hot_standby_feedback to be enabled when creating a logical decoding slot on standby

Isn't XLogRecord carries full information to be decoded in itself?If so a VACCUM should not be a problem in decoding? Thanks Sanyam Jain From: Michael Paquier <michael.paqu...@gmail.com> Sent: Monday, June 12, 2017 6:52:06 AM To: sanyam jain Cc: Pg H

[HACKERS] Why forcing Hot_standby_feedback to be enabled when creating a logical decoding slot on standby

Hi, I have created a logical decoding slot on a standby but i haven't enabled Hot_standby_feedback.What are the test cases where this setup will fail? Thanks, Sanyam Jain

[HACKERS] Use of snapshot in logical replication

Hi, Can someone explain the usage of exporting snapshot when a logical replication slot is created? Thanks, Sanyam Jain