Horton

Re: Slow query: bitmap scan troubles

Claudio Freire <klaussfreire@gmail.com>

View thread View on postgr.es
From: Claudio Freire <klaussfreire@gmail.com>
To: Philip Scott <pscott@foo.me.uk>
Cc: postgresql@foo.me.uk, postgres performance list <pgsql-performance@postgresql.org>
Date: 2012-12-04T18:32:57Z
Lists: pgsql-hackers, pgsql-performance 
On Tue, Dec 4, 2012 at 3:31 PM, Philip Scott <pscott@foo.me.uk> wrote:
> r_p_c 2-> 1 (s_p_c 1->0.5):

Is this really necessary?

(looks like a no-op, unless your CPU is slow)

Commits

  1. Tweak genericcostestimate's fudge factor for index size.

  2. Tweak index costing for problems with partial indexes.