Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

On 01/19/2017 06:21 AM, Merlin Moncure wrote: > ... yes. Either way, I would like to very much understand how server is preferring 3m cost plan to 2.6k cost plan or is otherwise unable to access the cheap plan. Perhaps it doesn't even see the 2.6k cost - it may not generate the plan for som

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

On Wed, Jan 18, 2017 at 11:10 PM, Adrian Klaver wrote: > On 01/18/2017 08:58 PM, Merlin Moncure wrote: >> >> On Wed, Jan 18, 2017 at 2:12 PM, Melvin Davidson > > wrote: >> >> >> >> On Wed, Jan 18, 2017 at 3:06 PM, Merlin Moncure > > w

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

On 01/18/2017 08:58 PM, Merlin Moncure wrote: On Wed, Jan 18, 2017 at 2:12 PM, Melvin Davidson mailto:melvin6...@gmail.com>> wrote: On Wed, Jan 18, 2017 at 3:06 PM, Merlin Moncure mailto:mmonc...@gmail.com>> wrote: On Wed, Jan 18, 2017 at 1:04 PM, Ravi Tammineni mailto:rta

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

On Wed, Jan 18, 2017 at 2:12 PM, Melvin Davidson wrote: > > > On Wed, Jan 18, 2017 at 3:06 PM, Merlin Moncure > wrote: > >> On Wed, Jan 18, 2017 at 1:04 PM, Ravi Tammineni >> wrote: >> > Hi Chris, >> > >> > Here is the query and execution plan in 9.5 and 9.6. >> >> Can you verify tblpuorderstat

Re: [GENERAL] migrate Sql Server database to PostgreSql

On Thu, Jan 19, 2017 at 6:17 AM, PAWAN SHARMA wrote: > Hello All, > > I am using postgres 9.5 enterprise edition. > > i want to to how to migrate Sql Server database to PostgreSql. what are > the things required for migration and what are the cron and prons of > migration. > Well, how challengi

Re: [GENERAL] migrate Sql Server database to PostgreSql

Hi, At the company we work for, we migrated from Oracle to PostgreSQL "community edition". We have no regrets. PostgreSQL allowed us to expand, we configured it so now we have a better performance compared to before, and we even have streaming replication to mirror our main database. By the way,

Re: [GENERAL] Read/Write operation counts

On Wed, Jan 18, 2017 at 4:10 PM, John R Pierce wrote: > On 1/18/2017 1:02 PM, Anirudh Jayakumar wrote: > >> Is there a way to retrieve the total read/write operations initiated by a >> PG server. I'm looking for measuring the IOPS of a server over a period of >> time. >> > > postgres itself doesn

Re: [GENERAL] Read/Write operation counts

On 1/18/2017 1:02 PM, Anirudh Jayakumar wrote: Is there a way to retrieve the total read/write operations initiated by a PG server. I'm looking for measuring the IOPS of a server over a period of time. postgres itself doesn't actually know how many physical disk operations are taking place a

[GENERAL] Read/Write operation counts

Hi, Is there a way to retrieve the total read/write operations initiated by a PG server. I'm looking for measuring the IOPS of a server over a period of time. Thanks, Anirudh

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

On Wed, Jan 18, 2017 at 3:06 PM, Merlin Moncure wrote: > On Wed, Jan 18, 2017 at 1:04 PM, Ravi Tammineni > wrote: > > Hi Chris, > > > > Here is the query and execution plan in 9.5 and 9.6. > > Can you verify tblpuorderstatus and tblpuorderstatushistory have all > indexes accounted for on both se

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

On Wed, Jan 18, 2017 at 1:04 PM, Ravi Tammineni wrote: > Hi Chris, > > Here is the query and execution plan in 9.5 and 9.6. Can you verify tblpuorderstatus and tblpuorderstatushistory have all indexes accounted for on both servers? It seems incredible server would prefer wading through 11M recor

[GENERAL] migrate Sql Server database to PostgreSql

Hello All, I am using postgres 9.5 enterprise edition. i want to to how to migrate Sql Server database to PostgreSql. what are the things required for migration and what are the cron and prons of migration. -Pawan

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

Hi Chris, Here is the query and execution plan in 9.5 and 9.6. explain analyze SELECT count(*) FROM tblCnPatientOrderMap po JOIN tblPuOrderStatus os ON po.vip_order_id = os.vip_order_id JOIN tblPuOrderStatusHistory osh ON os.order_status_history_id = osh.order_status_history_id WHER

[GENERAL] Re: [ADMIN] postgresql : could not serialize access due to read/write dependencies among transactions

On Tue, Jan 17, 2017 at 10:54 PM, Neslisah Demirci wrote: > could not serialize access due to read/write dependencies among > transactions > I also add an index to my query and my query's execution plan > don't use seq scan . These two issues are likely to be somewhat related -- if a sequential

Re: Ynt:[GENERAL] postgresql : could not serialize access due to read/write dependencies among transactions

Neslisah Demirci wrote: > First I started conversation between two person ; > > > sql: 'INSERT INTO "X" > ("id","customer","createdAt","updatedAt","CompanyId") VALUES > (DEFAULT,\'905322653555\',\'2017-01-17 19:13:37.751 +00:00\',\'2017-01-17 > 19:13:37.751 +00:00\',\'1\') RETURNING *;' }

Re: [GENERAL] Restore single databaseR

Hi, please don't top post. Il 18/01/2017 15:01, PAWAN SHARMA ha scritto: Thanks for reply, but I have 120 databases running on a one single instance. So it's not possible to take backup of instance instead of taking pg_dumb of all databases separately. Example: suppose we have two instanc

Re: [GENERAL] Restore single databaseR

Thanks for reply, but I have 120 databases running on a one single instance. So it's not possible to take backup of instance instead of taking pg_dumb of all databases separately. Example: suppose we have two instances running on single server, instance A having 120 databases and instance B having

Re: [GENERAL] Restore single databaseR

On Wed, Jan 18, 2017 at 7:32 AM, PAWAN SHARMA wrote: > Hello All, > > I am using postgres 9.5 enterprise edition and postgres 9.5 open source > where i want know solution of two problems. > > 1.How can we restore single database from base backup files only, I don't > have pg_dump backup. > Re

[GENERAL] Restore single databaseR

Hello All, I am using postgres 9.5 enterprise edition and postgres 9.5 open source where i want know solution of two problems. 1.How can we restore single database from base backup files only, I don't have pg_dump backup. 2.How can we restore single instance on different server where multiple