Re: [GENERAL] a JOIN to a VIEW seems slow

Поиск
Список
Период
Сортировка
От Frank Millman
Тема Re: [GENERAL] a JOIN to a VIEW seems slow
Дата
Msg-id 10F03730D0E54EC08F10553310F12B9C@FrankLaptop
обсуждение исходный текст
Ответ на [GENERAL] a JOIN to a VIEW seems slow  ("Frank Millman" <frank@chagford.com>)
Список pgsql-general
Дерево обсуждения

On 5 Oct 2017, at 8:20 AM, Frank Millman wrote:
> If anyone wants to take this further, maybe this is a good place to start.
 
I should have re-stated the reason for my original post.
 
Exactly the same query, on exactly the same data, takes 1.8 seconds on Sql Server, 1.0 seconds on SQLite3, and 1607 seconds, or 26 minutes, on PostgreSQL 9.4.4.
 
Frank
 

В списке pgsql-general по дате отправления:

Предыдущее
От: "Frank Millman"
Дата:
Сообщение: Re: [GENERAL] a JOIN to a VIEW seems slow
Следующее
От: athinivas
Дата:
Сообщение: [GENERAL] delete a file everytime pg server starts/crashes