Re: Panic Index!!!!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Panic Index!!!!
Date: 2003-09-05 17:38:23
Message-ID: 3117.1062783503@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Edwin Quijada" <listas_quijada(at)hotmail(dot)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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2003-09-05 17:51:34 Re: Pagination - 1 or 2 queries?
Previous Message Jeffrey Melloy 2003-09-05 17:32:54 Re: [GENERAL] How can I set postmaster as a service