Search Postgresql Archives

Re: how to speed up query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: how to speed up query
From: "Andrus" <kobruleht2@xxxxxx>
Date: Wed, 13 Jun 2007 22:37:25 +0300
In-reply-to: <15000.1181758984@xxxxxxxxxxxxx>
Organization: Hub.Org Networking Services
References: <f4b451$1d8j$1@xxxxxxxxxxxx> <1181340908.477874.270080@xxxxxxxxxxxxxxxxxxxxxxxxxxx> <f4jevl$da1$1@xxxxxxxxxxxx> <20070613065316.GA10351@xxxxxxxxx> <f4oqhc$29ta$1@xxxxxxxxxxxx> <15000.1181758984@xxxxxxxxxxxxx>

from pgAdmin, it takes 1 second.
When I run this command from script it takes 11 minutes!

Any idea why running this command from script takes 11 minutes?


Different plans maybe?  Try EXPLAIN ANALYZE in both cases.


Thank you. I tried

explain analyze  SELECT r.dokumnr FROM rid r  LEFT JOIN dok d USING
(dokumnr)
WHERE d.dokumnr IS NULL

with small database.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- how to speed up query
  - From: Andrus
- Re: how to speed up query
  - From: Erwin Brandstetter
- Re: how to speed up query
  - From: Andrus
- Re: how to speed up query
  - From: Martijn van Oosterhout
- Re: how to speed up query
  - From: Andrus
- Re: how to speed up query
  - From: Tom Lane

Prev by Date: Re: changing the /tmp/ lock file?
Next by Date: Re: pg_xlog - files are guaranteed to be sequentialy named?
Previous by thread: Re: how to speed up query
Next by thread: Re: how to speed up query
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux