Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.

Поиск
Список
Период
Сортировка
От aditya desai
Тема Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Дата
Msg-id CAN0SRDHd5+vVGUT=5XHnag4mPkyZtMFpVFDzzi8+tA4F6Fwd0g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.  (Michael Lewis <mlewis@entrata.com>)
Ответы Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Список pgsql-performance
Дерево обсуждения
Hi Michael,
Thanks for your response.
Is this table partitioned? - No
How long ago was migration done? - 27th March 2021
Has vacuum freeze and analyze of tables been done? - We ran vacuum analyze.
 Was index created after populating data or reindexed after perhaps? - Index was created after data load and reindex was executed on all tables yesterday.
 Version is PostgreSQL-11

Regards,
Aditya.


On Sat, Apr 3, 2021 at 7:40 PM Michael Lewis <mlewis@entrata.com> wrote:
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 по дате отправления:

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.