From: <postgresql@foo.me.uk>
To: "'postgres performance list'" <pgsql-performance@postgresql.org>
References: <092a01cdd230$ff6143c0$fe23cb40$@foo.me.uk>
	<CAGTBQpaKOfZs+qy+S7CCPcTg7PYOrwgcQAXgWV88cQTn-BFstg@mail.gmail.com>
	<CAMkU=1wEc1cCeUdR1oZ3Q2fe2pGj6tvrwRcY2obbfEk8LcNypQ@mail.gmail.com>
	<CAGTBQpbqzBf5545-qxdLQHbLyBBOvxn3hEtjQmqEp+UJPKsSrA@mail.gmail.com>
	<096f01cdd247$722264a0$56672de0$@foo.me.uk>
	<CAL_0b1vkyXYYpCxbFvu-4Piem10Y-tPz50MRO-mp3QMbkF1mEQ@mail.gmail.com>
In-Reply-To: 
 <CAL_0b1vkyXYYpCxbFvu-4Piem10Y-tPz50MRO-mp3QMbkF1mEQ@mail.gmail.com>
Date: Thu, 6 Dec 2012 12:56:26 -0000
Message-ID: <0b8b01cdd3b1$1a55b8b0$4f012a10$@foo.me.uk>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: 
 AQE7bKfasxp9xMk0I5yxURpgMQ+bBAG7NE8VAUNOjpICTD/jZgIPmBGyAk5PCg2Y40LE0A==
Content-Language: en-gb
Subject: Re: Slow query: bitmap scan troubles
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

> I also wonder if increasing (say x10) of default_statistics_target or just
doing ALTER TABLE SET STATISTICS for particular tables will help.
> It will make planned to produce more precise estimations. Do not forget
ANALYZE afer changing it.

Thanks Sergey, I will try this too.

I think the bother here is that this statistics are pretty good (we do
analyse regularly and default_statistics_target is already 1000), but once I
start filtering the two tables the correlations alter quite a bit. I don't
think there is that much that can be done about that :)

- Phil


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance