Slow response in select

Поиск
Список
Период
Сортировка
От Gary Stainburn
Тема Slow response in select
Дата
Msg-id 201009211325.55493.gary.stainburn@ringways.co.uk
обсуждение исходный текст
Ответы Re: Slow response in select
Список pgsql-sql
Hi folks,I have a view that seems to be very slow compared to similar views on 
the same server.

I've had a look at running explain but I don't really understand it.

I've posted the view and the output from explain at

http://www1.ringways.co.uk/explain.txt

This is an old view on a database that has been live for some time but I've 
never managed to get to the bottom of why it's much slower than the other 
views.

Gary
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     


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

Предыдущее
От: "Oliveiros d'Azevedo Cristina"
Дата:
Сообщение: Re: all the table values equal
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Slow response in select