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

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Дата
Msg-id CAHOFxGpDwsbfYFbn7n-d+A7Nho3KAiFXFbDBCj8ZGou=ag7eJg@mail.gmail.com
обсуждение исходный текст
Ответ на SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.  (aditya desai <admad123@gmail.com>)
Ответы Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: 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.