Re: Panic Index!!!! - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Panic Index!!!!
Date
Msg-id 20030905214805.GQ2126@dcc.uchile.cl
Whole thread Raw
In response to Re: Panic Index!!!!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Sep 05, 2003 at 01:38:23PM -0400, Tom Lane wrote:
> "Edwin Quijada" <listas_quijada@hotmail.com> writes:
> > This select get 20 seconds to doing. My 2 first table has 500000 reords each
> > one
>
> The row counts mentioned in your explain output seem suspiciously small.
> Have you ever ANALYZEd or VACUUMed these tables?

We got him up and running on the spanish list.  Appropiate
clue-installing tool will be applied as necessary.

(Maybe people should not be so fast to post on more than one list at the
same time...)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The eagle never lost so much time as
when he submitted to learn from the crow." (William Blake, citado por Nobody)

pgsql-general by date:

Previous
From: "Claudio Lapidus"
Date:
Subject: aggregate function
Next
From: "scott.marlowe"
Date:
Subject: Re: Pagination - 1 or 2 queries?