Slow response in select - Mailing list pgsql-sql

From Gary Stainburn
Subject Slow response in select
Date
Msg-id 201009211325.55493.gary.stainburn@ringways.co.uk
Whole thread Raw
Responses Re: Slow response in select
List 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 by date:

Previous
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: all the table values equal
Next
From: Craig Ringer
Date:
Subject: Re: Slow response in select