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 table and index size. >> >> I have a dummy table whi

[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] 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 study

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 a

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 of the respective DBMS

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] 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, Timokhin Maxim wrote: > >> Sure,

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

1. I found this document : https://www.postgresql.org/message-id/20140811083748.2536.10437%40wrigleys.postgresql.org 2. Return only on row if query data using where equal condition, but got 2 rows by like condition Steven 2017-07-01 22:05 GMT+08:00 Adrian Klaver : > On 06/30/2017 09:42 PM

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

codes. Regards, Steven 2017-07-03 9:18 GMT+08:00 Michael Paquier : > On Mon, Jul 3, 2017 at 10:08 AM, Steven Chang > wrote: > > Hello : > > Please avoid top-posting. > > >PG VERSION : PPAS 9.3 , enterprisedb > >os version : 2.6.32-358.el6.x86_64 &g