Re: weird long time query

2019-12-17 Thread Kaijiang Chen
I think I should also report it as a bug since logically, it couldn't exist. On Wed, Dec 18, 2019 at 1:04 AM Tom Lane wrote: > Kaijiang Chen writes: > > I'm using postgres 9.4.17 on centos 7. > > I check the running queries with the following SQL: > > SELECT > > procpid, > > start, > >

Re: shared memory size during upgrade pgsql with partitions (max_locks_per_transaction)

2019-12-17 Thread Justin Pryzby
On Tue, Dec 17, 2019 at 08:03:41PM +, Piotr Włodarczyk wrote: > Currently we're working on PSQL 11.5 and we're trying upgrade to 12.1. > > During that we have a problem: > > command: "/usr/pgsql-12/bin/pg_dump" --host /cluster/postgresql --port 50432 > --username postgres --schema-only --quot

shared memory size during upgrade pgsql with partitions

2019-12-17 Thread Piotr Włodarczyk
Hello, Currently we're working on PSQL 11.5 and we're trying upgrade to 12.1. During that we have a problem: command: "/usr/pgsql-12/bin/pg_dump" --host /cluster/postgresql --port 50432 --username postgres --schema-only --quote-all-identifiers --binary-upgrade --format=custom --file="pg_upgrade

Re: weird long time query

2019-12-17 Thread Tom Lane
Kaijiang Chen writes: > I'm using postgres 9.4.17 on centos 7. > I check the running queries with the following SQL: > SELECT > procpid, > start, > now() - start AS lap, > current_query > FROM > (SELECT > backendid, > pg_stat_get_backend_pid(S.backendid) AS proc

Re: Consecutive Query Executions with Increasing Execution Time

2019-12-17 Thread Jeff Janes
On Tue, Dec 17, 2019 at 8:08 AM Laurenz Albe wrote: > On Mon, 2019-12-16 at 15:50 -0500, Tom Lane wrote: > > Peter Geoghegan writes: > > > Why do the first and the twentieth executions of the query have almost > > > identical "buffers shared/read" numbers? That seems odd. > > > > It's repeat exe

Re: Consecutive Query Executions with Increasing Execution Time

2019-12-17 Thread Laurenz Albe
On Mon, 2019-12-16 at 15:50 -0500, Tom Lane wrote: > Peter Geoghegan writes: > > Why do the first and the twentieth executions of the query have almost > > identical "buffers shared/read" numbers? That seems odd. > > It's repeat execution of the same query, so that doesn't seem odd to me. Really

Re: weird long time query

2019-12-17 Thread Pavel Stehule
út 17. 12. 2019 v 11:45 odesílatel Kaijiang Chen napsal: > I'm using postgres 9.4.17 on centos 7. > I check the running queries with the following SQL: > SELECT > procpid, > start, > now() - start AS lap, > current_query > FROM > (SELECT > backendid, > pg_stat_

weird long time query

2019-12-17 Thread Kaijiang Chen
I'm using postgres 9.4.17 on centos 7. I check the running queries with the following SQL: SELECT procpid, start, now() - start AS lap, current_query FROM (SELECT backendid, pg_stat_get_backend_pid(S.backendid) AS procpid, pg_stat_get_backend_activity_sta