From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | Dustin Sallings <dustin(at)spy(dot)net> |
Cc: | Charles Tassell <ctassell(at)isn(dot)net>, Diego Schvartzman <dschvar(at)yahoo(dot)com>, Lista PGSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Performance |
Date: | 2000-05-16 16:14:08 |
Message-ID: | 20000516091407.I20000@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> # At 04:56 PM 5/15/00, Diego Schvartzman wrote:
> # >I have an application via PHP. For example, a SELECT query that must return
> # >one and only one row, with a where clause with and index (I droped it and
> # >created again) that took about 3 seconds (v6.5.3), now (v7.0.0) takes about
> # >15 seconds. Really I don't lnow what is happening. Same hardware, same php
> # >version, etc etc.
> # >
* Dustin Sallings <dustin(at)spy(dot)net> [000516 02:26] wrote:
> On Mon, 15 May 2000, Charles Tassell wrote:
>
> I ran into this exact problem, and it was *very* significant on a
> 15M row table I have. :) It didn't seem to want to use the index, even
> freshly created, without a vacuum analyze.
grrrr....
FOR THE LAST TIME, THESE BUG REPORTS ARE PRETTY MUCH **USELESS**
TO THE DEVELOPERS UNLESS YOU GIVE:
THE TABLE STRUCTURE,
THE QUERY, AND
THE OUTPUT OF 'EXPLAIN'
Just because someone is a database guru doesn't mean they are also
clairvoyant. :)
thanks,
-Alfred
From | Date | Subject | |
---|---|---|---|
Next Message | Diego Schvartzman | 2000-05-16 16:15:35 | Re: Performance |
Previous Message | Jeff Hoffmann | 2000-05-16 15:47:38 | Re: Question about databases in alternate locations... |