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

From Adam Kavan
Subject Re: Panic Index!!!!
Date
Msg-id 5.2.1.1.0.20030905153240.009f78d0@pop.central.cox.net
Whole thread Raw
In response to Re: Panic Index!!!!  (Richard Huxton <dev@archonet.com>)
List 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@cox.net


pgsql-general by date:

Previous
From: CSN
Date:
Subject: Re: Pagination - 1 or 2 queries?
Next
From: Bruce Momjian
Date:
Subject: Re: Pagination - 1 or 2 queries?