[PERFORM] Hot standby 9.2.1 PANIC: WAL contains references to invalid pages

Hi Team, For last 2 days we are facing issue with replication. WARNING: page 21 of relation base/1193555/19384612 does not exist CONTEXT: xlog redo insert: rel 1663/1193555/19384612; tid 21/1 PANIC: WAL contains references to invalid pages CONTEXT: xlog redo insert: rel 1663/1193555/19384612;

Re: [PERFORM] Fast distinct not working as expected

I have found the problem, using this query |(found here http://stackoverflow.com/questions/3312929/postgresql-idle-in-transaction-diagnosis-and-reading-pg-locks)| select pg_class.relname, pg_locks.transactionid, pg_locks.mode, pg_locks.granted as "g", pg_stat_activity.current_query,

Re: [PERFORM] Fast distinct not working as expected

Hi, Le 17/04/2014 20:17, Jeff Janes a écrit : > > > If there are any open transactions (even ones that have never touched > this particular table) which started before the delete was committed, > then the vacuum was obliged to keep those deleted records around, in > case that open transaction happ