The past three years has been using PGSQL, feel very good ah,
Recently have a database from SQLServer2008 moved on Ubuntu 15.04 own PGSQL 9.3

As a simple select to retrieve a single table, select from the 50 w records out of 4000 records,
Used to display time consuming: 00:00:00, estimate for just a few hundred milliseconds
PostgreSQL, every time is more than 1200 ms, most 3 ms XXX,

Postgresql performance is so poor? Or need to choose paid version, just may have higher performance???????

CodePudding user response:

Not estimated the index, to an execution plan first and see what is going on, and then make a decision, how to optimize

CodePudding user response:

Postgresql performance close to the oracle

CodePudding user response:

Postgresql performance close to oracle? Who said that, the performance of oracle that was after a hard practice, pg query efficiency is low, it is better to mysql

CodePudding user response:

Let's look at the execution plan, I have a lot of 9.3 version of the application in production, in the tens of millions of queries in the table is just a matter of moments.