| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | pasman pasmański <pasman(dot)p(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem with planner |
| Date: | 2011-08-09 09:57:28 |
| Message-ID: | 20110809095728.GB24450@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivekkumar Pandey | 2011-08-09 10:24:45 | Re: postgres table have a large number of relpages and occupied a big memory size |
| Previous Message | Tomas Vondra | 2011-08-09 09:29:59 | Re: postgres table have a large number of relpages and occupied a big memory size |