Known Bugs on Postgres 9.5

On Friday, May 4, 2018, Anudeep Gudipelli wrote: > I would like to know the known bugs for v9.5 and also v9.6, is there any > place where I can check? > I think as a whole the project does a good job of fixing known bugs shortly after they are reported. There is no official bug tracker (i.e.,

Re: Known Bugs on Postgres 9.5

On 05/05/2018 03:10 PM, Anudeep Gudipelli wrote: Hi vick, Is there any documentation on bugs, I can’t find them on release notes. Based on the release notes I can see that 9.6 will perform better than 9.5, but I would like to know if there are any known bugs in both 9.5 and 9.6 . The reason i

Re: Known Bugs on Postgres 9.5

On 05/05/2018 03:10 PM, Anudeep Gudipelli wrote: Hi vick, Is there any documentation on bugs, I can’t find them on release notes. Based on the release notes I can see that 9.6 will perform better than 9.5, but I would like to know if there are any known bugs in both 9.5 and 9.6 . The reason i

Re: Known Bugs on Postgres 9.5

Hi vick, Is there any documentation on bugs, I can't find them on release notes. Based on the release notes I can see that 9.6 will perform better than 9.5, but I would like to know if there are any known bugs in both 9.5 and 9.6 . The reason is I need to present a business model to which versi

Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

Thanks, now I see the difference

Re: pg_dump with compressible and non-compressible tables

On 05/05/2018 12:41 PM, Ron wrote: On 05/05/2018 12:13 PM, Adrian Klaver wrote: On 05/05/2018 07:14 AM, Ron wrote: Hi, v9.6 We've got big databases where some of the tables are highly compressible, but some have many bytea fields containing PDF files. Can you see a demonstrable difference?

Re: pg_dump with compressible and non-compressible tables

On 05/05/2018 12:13 PM, Adrian Klaver wrote: On 05/05/2018 07:14 AM, Ron wrote: Hi, v9.6 We've got big databases where some of the tables are highly compressible, but some have many bytea fields containing PDF files. Can you see a demonstrable difference? Very much so.  The ASCII hex repr

Re: comparison between 2 execution plans

On 05/05/2018 10:51 AM, Neto pr wrote: Dear, 2018-05-05 9:57 GMT-07:00 Adrian Klaver >: On 05/05/2018 06:26 AM, Neto pr wrote: It might help if you explained what 'version with source code changed by me' means? Postgresql with modified sourc

Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

On 05/05/2018 10:41 AM, Alexander Farber wrote: Hi Adrian, There is a two-player word game: CREATE TABLE players (      uid SERIAL PRIMARY KEY,      name text NOT NULL ); CREATE TABLE games (      gid SERIAL PRIMARY KEY,   

Re: comparison between 2 execution plans

Dear, 2018-05-05 9:57 GMT-07:00 Adrian Klaver : > On 05/05/2018 06:26 AM, Neto pr wrote: > >> Dear all >> >> Could you help me understand these two execution plans for the same query >> (query 3 benchmark TPCH www.tpc.org/tpch ), >> executed in two different environments

Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

Hi Adrian, On Sat, May 5, 2018 at 7:03 PM, Adrian Klaver wrote: > On 05/05/2018 07:49 AM, Alexander Farber wrote: > >> http://sqlfiddle.com/#!17/7e929/13 >> >> There is a two-player word game: >> >> CREATE TABLE players ( >> uid SERIAL PRIMARY KEY, >> name text NOT NULL >> ); >> >> CR

Re: Known Bugs on Postgres 9.5

If you're using Postgres for Jira and Confluence, you should upgrade to 9.6. It is the newest version that is known to work. Version 9.5 will also work but you will get better performance and longer life out of the 9.6 version.

Re: pg_dump with compressible and non-compressible tables

On 05/05/2018 07:14 AM, Ron wrote: Hi, v9.6 We've got big databases where some of the tables are highly compressible, but some have many bytea fields containing PDF files. Can you see a demonstrable difference? When the data format is custom, directory or tar, how feasible would a "--no-

Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

On 05/05/2018 07:49 AM, Alexander Farber wrote: Hello, I am struggling with an UPSERT in PostgreSQL 10.3 and have prepared a simple test case showing my 2 problems (at http://sqlfiddle.com/#!17/7e929/13 and also below) - There is a two-player word game: CREATE TABLE players (     uid SERIA

Re: comparison between 2 execution plans

On 05/05/2018 06:26 AM, Neto pr wrote: Dear all Could you help me understand these two execution plans for the same query (query 3 benchmark TPCH www.tpc.org/tpch ), executed in two different environments of Postgresql, as described below: Execution Plan 1: - https:/

Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

Even the simpler INSERT statement INSERT INTO stats(uid, single_q_left) SELECT player1, COUNT(*) FROM games WHERE hand1 = '{Q}' GROUP BY player1 ON CONFLICT(uid) DO NOTHING; produces the same error. On Sat, May 5, 2018 at 4:49 PM, Alexander Farber wrote: > http://sqlfiddle.com/#!17/7e929/13 >

Re: statement_timeout issue

On Fri, May 4, 2018 at 10:22 AM, Andres Freund wrote: > Hi, > > On 2018-05-04 09:52:35 -0700, Ian Harding wrote: > > I know there are a lot of moving parts to this issue but I think I've > > eliminated most of them and the problem comes down to the postgresql > server > > generating a statement_t

Re: comparison between 2 execution plans

Further information is These plans were generated by the EXPLAIN ANALYZE command, and the time of plan 1 (Postgresql 10.1 ) was 4.7 minutes and plan 2 (postgresql 9.5 changed) was 2.95 minutes. 2018-05-05 6:26 GMT-07:00 Neto pr : > Dear all > > Could you help me understand these two execution p

ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

Hello, I am struggling with an UPSERT in PostgreSQL 10.3 and have prepared a simple test case showing my 2 problems (at http://sqlfiddle.com/#!17/7e929/13 and also below) - There is a two-player word game: CREATE TABLE players ( uid SERIAL PRIMARY KEY, name text NOT NULL ); CREATE TABLE

Re: How to find the hits on the databases and tables in Postgres

>How to monitor the Hits on database and how many hits on each user tables > Through query. *Do these help? You can run them through a cron job.* *-- For all databases* *SELECT pg_stat_database.datname,pg_stat_database.blks_read, pg_stat_database.blks_hit,round((pg

pg_dump with compressible and non-compressible tables

Hi, v9.6 We've got big databases where some of the tables are highly compressible, but some have many bytea fields containing PDF files. When the data format is custom, directory or tar, how feasible would a "--no-blob-compression" option be (where pg_dump just tells the zlib library to jus

comparison between 2 execution plans

Dear all Could you help me understand these two execution plans for the same query (query 3 benchmark TPCH www.tpc.org/tpch), executed in two different environments of Postgresql, as described below: Execution Plan 1: - https://explain.depesz.com/s/Ughh - Postgresql version 10.1 (default) with ind

Re: How to find the hits on the databases and tables in Postgres

2018-05-05 13:03 GMT+02:00 PT : > On Fri, 4 May 2018 17:14:39 +0530 > nikhil raj wrote: > > > Hi, > > Any one can please help me out > > > > How to monitor the Hits on database and how many hits on each user tables > > Through query. > > Is there any other tools for that so it can full fill my r

Re: How to find the hits on the databases and tables in Postgres

On Fri, 4 May 2018 17:14:39 +0530 nikhil raj wrote: > Hi, > Any one can please help me out > > How to monitor the Hits on database and how many hits on each user tables > Through query. > Is there any other tools for that so it can full fill my requirement for it pgBadger has always been my go