Re: Problem with planner - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Problem with planner
Date
Msg-id 20110809095728.GB24450@depesz.com
Whole thread Raw
In response to Re: Problem with planner  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
On Mon, Aug 08, 2011 at 10:01:58PM +0200, pasman pasmański wrote:
> Try to change index: objects_endings_tsz_active(state,endings_tsz)
> where state='active'.

adding new indexes on this machine is quite complicated, as it's heavily
used production system.
And the current index should be chosen by planner anyway - it is after
analyze, but then it breaks again.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-general by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: postgres table have a large number of relpages and occupied a big memory size
Next
From: Vivekkumar Pandey
Date:
Subject: Re: postgres table have a large number of relpages and occupied a big memory size