Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

, Steven 2017-07-03 9:18 GMT+08:00 Michael Paquier <michael.paqu...@gmail.com>: > On Mon, Jul 3, 2017 at 10:08 AM, Steven Chang <stevenchang1...@gmail.com> > wrote: > > Hello : > > Please avoid top-posting. > > >PG VERSION : PPAS 9.3 , enterprisedb &g

Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

gt; On 06/30/2017 09:42 PM, Steven Chang wrote: > >> Uh...we also met duplicate rows with primary key column through >> restoring database by pg_basebackup. >> H. >> I don't think its an issue with primary key index corruption. >> >

Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

Uh...we also met duplicate rows with primary key column through restoring database by pg_basebackup. H. I don't think its an issue with primary key index corruption. 2017-07-01 7:30 GMT+08:00 Adrian Klaver : > On 06/30/2017 07:33 AM,

Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

Interesting!! We also met the same situation on PK running on PPAS 9.0 last night. When surfing Internet, got returned this URL : https://www.postgresql.org/message-id/20140811083748.2536.10437%40wrigleys. postgresql.org

Re: [GENERAL] dump to pg

hello, not possible in your case. To my understading, no tool can directly transform binary dump(Oralce & MSSQL) to csv file format. Steven 2017-06-02 5:37 GMT+08:00 Nicolas Paris : > > If they aren't too big, you might get away by installing the express > edition

Re: [GENERAL] index duplicates primary key, but is used more?

Hello, I suggest you log all execution plan in your db log through using auto_explain extension. And then analyze the stats about your concerned indexes . No hint syntax in Postgresql. Which indexes and join method would be adopt all depend on optimizer whose behaviour is

Re: [GENERAL] Current best practice for maximum shared_buffers settings on big hardware?

Hello, read it and test it , you will know why offical doc suggest no more than 40% total memory for shared_buffers http://raghavt.blogspot.tw/2012/04/caching-in-postgresql.html And this is also a very good book -- http://www.interdb.jp/pg/index.html IT job is just to keep repeating

[GENERAL] shard_manager extension on PGXN

Hello, Regarding this thread : https://www.postgresql.org/message-id/0683F5F5A5C7FE419A752A034B4A0B979778864A%40sswchi5pmbx2.peak6.net And after reading https://pgxn.org/dist/shard_manager/0.0.1/doc/shard_manager.html#shard_manager.Extension Column data for sharding not only series type

Re: [GENERAL] [ADMIN] calculating table and index size

Hello, try pgstattuple() and pgstatindex() , I think you will figure it out. Steven 2017-04-05 16:56 GMT+08:00 Guillaume Lelarge : > Hi, > > 2017-04-05 9:44 GMT+02:00 Günce Kaya : > >> Hi all, >> >> I have some questions about calculating