From: Josué Maldonado <josue@lamundial.hn>
To: josh@agliodbs.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Join slow on "large" tables
Date: Mon, 07 Jun 2004 17:30:13 -0600
Message-ID: <40C4FA85.8070205@lamundial.hn> (raw)
In-Reply-To: <200406071621.10732.josh@agliodbs.com>
References: <40C4E9EA.7000708@lamundial.hn>
<200406071531.49207.josh@agliodbs.com>
<40C4F66C.8030609@lamundial.hn>
<200406071621.10732.josh@agliodbs.com>
Josh,
El 07/06/2004 5:21 PM, Josh Berkus en su mensaje escribio:
>
> Huh? It is not at all the same. Your index scan is down to 87ms from
> 27,000! And the total query is down to 16seconds from 47 seconds. Don't
> you consider that an improvement?
Yes there was an improvement with respect the previus query, but still
16 seconds is too slow for that query. And usually the query takes more
than 10 seconds even with small data sets returned.
Thanks,
--
Sinceramente,
Josué Maldonado.
"La cultura es capaz de descifrar los enigmas en que nos envuelve la vida."
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josue@lamundial.hn, josh@agliodbs.com
Subject: Re: Join slow on "large" tables
In-Reply-To: <40C4FA85.8070205@lamundial.hn>
* 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