Re: ERROR: no known snapshots

2021-05-12 Thread reg_pg_stefanz
On 12.05.2021 05:42, Tom Lane wrote: If you're in a position to apply the patch and see if it resolves your real non-simplified case, that would be very helpful. Also, this fix in principle will create a small performance penalty for FOR-loops in non-atomic contexts such as DO loops. It'd be int

Re: ERROR: no known snapshots

2021-05-12 Thread Tom Lane
reg_pg_stef...@perfexpert.ch writes: > However, I poked around a little bit, and this does not seem to solve > all potential use cases, when I modify the simplified test by deferring > the lookup to be done inside the loop as an extra lookup instead of > doing it directly in the loop (whether th

Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1

2021-05-12 Thread Dhanisha
Hi, I also see a similar error while performing "yum install postgresql10-devel" yum-dump Repository Error: failure: repodata/repomd.xml from pgdg-common: [Errno 256] No more mirrors to try. https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-7-x86_64/repodata/repomd.xml: [Errno -1

Postgresql fdw tracing

2021-05-12 Thread Vijaykumar Jain
Hello Gentlemen, I am trying to setup a shard array of pg clusters behind fdw which is fronted by haproxy/envoyproxy to load balance. Something like this, but including pgbouncer. https://image.slidesharecdn.com/fdw-basedsharding-170321103514/95/fdwbased-sharding-update-and-future-12-638.jpg?cb=1