Re: Optimizing Bitmap Heap Scan.

2009/12/8 Lennin Caro <lennin.caro@yahoo.com>
>
> From: niraj patel <npatel@gridsolv.com>
>
> Subject: Re: [PERFORM] Optimizing Bitmap Heap Scan.
> To: "Grzegorz Jaśkiewicz" <gryzman@gmail.com>
> Cc: pgsql-performance@postgresql.org
> Date: Tuesday, December 8, 2009, 1:50 PM
>
> Hi gryzman,
>
> I have run vacuum full analyze on the cmrules tables. The version of pstgres is 8.2.13. How should I change stats to
100? 
>
> Thanks
> ________________________________
> From: Grzegorz Jaśkiewicz <gryzman@gmail.com>
> To: niraj patel <npatel@gridsolv.com>
> Cc: pgsql-performance@postgresql.org
> Sent: Tue, 8 December, 2009 7:12:49 PM
> Subject: Re: [PERFORM] Optimizing Bitmap Heap Scan.
>
> it looks like it might choose wrong plan, cos it gets the stats wrong.
> Try increasing number of stats to 100.
> Btw, what version it is ?
>
>
> in psql
> mydb=# set default_statistics_target = 100;

That's only going to affect the current session.  To change it
permanently, edit postgresql.conf and do pg_ctl reload.

...Robert