Re: Panic Index!!!!

From: Adam Kavan <akavan(at)cox(dot)net>
To: Richard Huxton <dev(at)archonet(dot)com>, "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Panic Index!!!!
Date: 2003-09-05 20:33:35
Message-ID: 5.2.1.1.0.20030905153240.009f78d0@pop.central.cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>
>Couple of things to try: run "analyse" to redo the statistics and see if that
>helps.
>
>If not, have you changed the configuration settings - the default ones are
>very low. You can find more at
>http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
>
>--
> Richard Huxton
> Archonet Ltd
Also try running an 'explain analyze' instead of just an explain it will
give us more information.

--- Adam Kavan
--- akavan(at)cox(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-09-05 20:43:39 Re: C functions
Previous Message Bruce Momjian 2003-09-05 20:20:55 Re: Pagination - 1 or 2 queries?