Re: Optimizing Bitmap Heap Scan. - Mailing list pgsql-performance

From Robert Haas
Subject Re: Optimizing Bitmap Heap Scan.
Date
Msg-id 603c8f070912081030s3e7ba2fay6164de15529cb4e4@mail.gmail.com
Whole thread Raw
In response to Re: Optimizing Bitmap Heap Scan.  (Lennin Caro <lennin.caro@yahoo.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: performance penalty between Postgresql 8.3.8 and 8.4.1
Next
From: Greg Smith
Date:
Subject: Re: Checkpoint spikes