From: secret <secret@kearneydev.com>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Very disappointing performance -- All Indexes Ignored.
Date: Thu, 11 Mar 1999 14:30:54 -0500
Message-ID: <36E819EE.ED2911E6@kearneydev.com> (raw)
References: <199903111736.MAA18715@candle.pha.pa.us>
Bruce Momjian wrote:
> OK, some questions. First, how long does EXPLAIN take to run. It is a
> significant percentage of the query time? If so, please download the
> current snapshot, and try that. Should be much faster.
>
Not very long, maybe 10 seconds at maximum... I checked this because I
was
paranoid it might be that... No problem there.
>
> Second, indexes are not of a huge value in this query, because there are
> no restrictions, i.e. x=3. In most cases, walking the index and then
> going to the heap table takes longer than just reading the entire table
> into a hash and doing the join there.
I see, and after doing a more specific query(from_job_id=xxx) the speed
is much increased... The main thing that disturbed me is the rather large
time between the query with joins(300 seconds) and with the functions(30s)...
Shouldn't the functions be far slower?(Seems like they would be less
efficient)
PostgreSQL is also crashing 1-2 times a day on me, although I have a
handy perl script to keep it alive now <grin>... If PostgreSQL does work for
my project I'll of course buy CDs/books/whatever to support the project.
Despite the 2 problems I'm having I am very impressed with the project.
--David
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: secret@kearneydev.com, maillist@candle.pha.pa.us
Subject: Re: [SQL] Very disappointing performance -- All Indexes Ignored.
In-Reply-To: <36E819EE.ED2911E6@kearneydev.com>
References: <199903111736.MAA18715@candle.pha.pa.us> <36E819EE.ED2911E6@kearneydev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox