Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. - Mailing list pgsql-performance

From Michael Lewis
Subject Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Date
Msg-id CAHOFxGpDwsbfYFbn7n-d+A7Nho3KAiFXFbDBCj8ZGou=ag7eJg@mail.gmail.com
Whole thread Raw
In response to SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.  (aditya desai <admad123@gmail.com>)
Responses Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
List pgsql-performance
Tree view
It seems like something is missing. Is this table partitioned? How long ago was migration done? Has vacuum freeze and analyze of tables been done? Was index created after populating data or reindexed after perhaps? What version are you using?

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Next
From: aditya desai
Date:
Subject: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.