On Thu, 16 Apr 2009, dforum wrote:
there is other performance problem on this request.
If you analyse query plan, you see that most of the time are lost during
sequencial scan, and you have 2 seq scan.
Nonsense. Sequential scans account for all of one or two seconds of
processing in these queries, which are 14 seconds and 38 minutes
respectively.
Matthew
--
Doctor: Are you okay? You appear to be injured.
Neelix: Aaaaaaah!
Doctor: It's okay, it looks superficial.
Neelix: Am I going to die?
Doctor: Not unless you are allergic to tomatoes. This appears to be a sauce
some kind.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
