Re: FDW Foreign Table Access: strange LOG message

Michael Paquier writes: > On Thu, Mar 22, 2018 at 06:55:12PM -0400, Tom Lane wrote: >> Anyway, it's clearly not very nice that postgres_fdw makes no attempt >> to do a graceful shutdown of its remote connection. I don't know that >> this rises to the level of a bug, exactly,

Re: FDW Foreign Table Access: strange LOG message

On Thu, Mar 22, 2018 at 06:55:12PM -0400, Tom Lane wrote: > Anyway, it's clearly not very nice that postgres_fdw makes no attempt > to do a graceful shutdown of its remote connection. I don't know that > this rises to the level of a bug, exactly, but if somebody wanted to > send in a patch it'd

Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

On Thu, Mar 22, 2018 at 2:24 PM, Jeremy Finzel wrote: > I am running this on a san snapshot of our production system. I assume that > this will give me a valid check for file-system-level corruption. I am > going to kick it off and see if I find anything interesting. It

Re: postgresql-10.3 on unbuntu-17.10 - how??

On 03/21/2018 03:08 PM, Adrian Klaver wrote: On 03/21/2018 01:59 PM, Stuart McGraw wrote: On 03/21/2018 02:37 PM, Rob Sargent wrote: Thanks, I forgot that the older repos also received the pg-10 update. Unfortunately but no luck with Xenial either, slightly different but similar conflicts. My

Re: Postgresql 10.3 , query never completes if LIMIT clause is specified and paralle processing is on

Thanks Tomas. We're currently building postgres from source. In order to enable symbols, you want me to re-configure postres with --enable-debug then run perf? Regards, On Thu, Mar 22, 2018 at 5:00 PM, Tomas Vondra wrote: > > > On 03/22/2018 11:33 AM, Alessandro

Re: Postgresql 10.3 , query never completes if LIMIT clause is specified and paralle processing is on

On 03/22/2018 11:29 PM, Alessandro Aste wrote: > Thanks Tomas. We're currently building postgres from source. In order to > enable symbols, you want me to re-configure postres with  --enable-debug > then run perf? > Yes. regards -- Tomas Vondra http://www.2ndQuadrant.com

Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

On Thu, Mar 22, 2018 at 3:20 PM, Peter Geoghegan wrote: > On Thu, Mar 22, 2018 at 12:27 PM, Jeremy Finzel wrote: > > Thank you for the recommendation. I ran both amcheck functions on all 4 > > indexes of those 2 tables with heapallindexed = true, but no issues

Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

I admit I'm pretty surprised by this whole episode. I have no useful advice to offer here. -- Álvaro Herrerahttps://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

On Wed, Mar 21, 2018 at 4:29 PM, Peter Geoghegan wrote: > On Wed, Mar 21, 2018 at 1:38 PM, Jeremy Finzel wrote: > > A server restart and upgrade to 9.5.12 (at the same time), as expected, > made > > the issue go away. Still doesn't give us any answers as to

Re: FDW Foreign Table Access: strange LOG message

On 03/22/2018 11:08 AM, Albrecht Dreß wrote: Hi Adrian: Am 21.03.18 19:25 schrieb(en) Adrian Klaver: Does it also happen when you open a psql session and do?: psql>select * from ext_table limit 1; No messages are printed whilst the session is open.  However, when I quit the session by

Re: FDW Foreign Table Access: strange LOG message

Hi Adrian: Am 21.03.18 19:25 schrieb(en) Adrian Klaver: Does it also happen when you open a psql session and do?: psql>select * from ext_table limit 1; No messages are printed whilst the session is open. However, when I quit the session by typing “\q” /after/ entering the command above,

Re: Postgresql 10.3 , query never completes if LIMIT clause is specified and paralle processing is on

On 03/22/2018 11:33 AM, Alessandro Aste wrote: > Tomas, thank you. This machine  is abare metal server running only a > staging postgresql 10.3  instance. Nobody is using it beside me.  > > I'm attaching 4 files.   > > every_30_seconds_top_stats_during_query.txt    - this is a caputure of >

Re: Introducing brand-new dbForge Studio for PostgreSQL, a powerful IDE for working with PostgreSQL databases

The "Free" version doesn't do much. Just lets you connect to a DB, create/edit and execute SQL. oh hum. On Thu, Mar 22, 2018 at 9:55 AM, Tim Clarke wrote: > On 22/03/18 11:53, Steven Hirsch wrote: > > On Thu, 22 Mar 2018, Devart wrote: > > > >> /Devart announced the

Re: Introducing brand-new dbForge Studio for PostgreSQL, a powerful IDE for working with PostgreSQL databases

On 22/03/18 11:53, Steven Hirsch wrote: > On Thu, 22 Mar 2018, Devart wrote: > >> /Devart announced the first release of dbForge Studio for PostgreSQL >> that >> allows to manage and develop database objects in PostgreSQL. This new >> IDE >> offers many robust features like Code Completion, Object

Re: Postgresql 10.3 , query never completes if LIMIT clause is specified and paralle processing is on

Tomas, thank you. This machine is abare metal server running only a staging postgresql 10.3 instance. Nobody is using it beside me. I'm attaching 4 files. every_30_seconds_top_stats_during_query.txt- this is a caputure of the top command every 30 seconds(more or less) for 10+ minutes while

Re: Introducing brand-new dbForge Studio for PostgreSQL, a powerful IDE for working with PostgreSQL databases

On 22/03/18 11:53, Steven Hirsch wrote: On Thu, 22 Mar 2018, Devart wrote: /Devart announced the first release of dbForge Studio for PostgreSQL that allows to manage and develop database objects in PostgreSQL. This new IDE offers many robust features like Code Completion, Object Explorer and

Re: Introducing brand-new dbForge Studio for PostgreSQL, a powerful IDE for working with PostgreSQL databases

On Thu, 22 Mar 2018, Devart wrote: /Devart announced the first release of dbForge Studio for PostgreSQL that allows to manage and develop database objects in PostgreSQL. This new IDE offers many robust features like Code Completion, Object Explorer and Data Editor which help users create,

RE: Foreign Key locking / deadlock issue.... v2

Thanks Rob, The security policy in the example was reduced to the bare minimum, to demonstrate the issue was with the existence of the policy, not what it did. Obviously my real-application policy does much more, and uses other columns to do both read & write checks. Adding the write check as

Re: Foreign Key locking / deadlock issue.... v2

Hello Phil, On Wed, 2018-03-21 at 15:26 +, HORDER Phil wrote: > OK, > Let's try again, with a full script, and including the bit that makes > the difference… > > Hi, > I’m trying to understand why I’m getting a deadlock issue, and how to > work around it. > > At base, I think the problem

Re: Prepared statements

> You mean Oracle 11g. No 12c. Some of it may have started in 11g itself, but only in 12c they really mastered it. I saw it as a developer, not as a DBA. I was never an oracle DBA.

Introducing brand-new dbForge Studio for PostgreSQL, a powerful IDE for working with PostgreSQL databases

/Devart announced the first release of dbForge Studio for PostgreSQL that allows to manage and develop database objects in PostgreSQL. This new IDE offers many robust features like Code Completion, Object Explorer and Data Editor which help users create, develop and execute queries as well as edit

Re: JDBC connectivity issue

Chris, At this point I'd write small piece of code to test if the url and failover is working correctly. Sounds like you have a considerably sized stack making it difficult to debug. With a small piece of code it should become clear as to how things work or don't as the case may be Dave Cramer

Re: Prepared statements

Rakesh Kumar wrote: > Only in Oracle 12c there are > options to let the planner change existing plan by peeking into the parameter > values (supplied in ? of prepare) and checking it against the distribution. You mean Oracle 11g. Yours, Laurenz Albe -- Cybertec |