| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Edwin Quijada <listas_quijada(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Panic Index!!!! |
| Date: | 2003-09-05 21:48:05 |
| Message-ID: | 20030905214805.GQ2126@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Sep 05, 2003 at 01:38:23PM -0400, Tom Lane wrote:
> "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?
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-05 21:52:55 | Re: [PERFORM] Seq scan of table? |
| Previous Message | scott.marlowe | 2003-09-05 21:46:13 | Re: Pagination - 1 or 2 queries? |