ny sort of selective index would help me.
Thanks.
From: Matthew Wakeling
To: niraj patel
Cc: pgsql-performance@postgresql.org
Sent: Tue, 8 December, 2009 7:33:38 PM
Subject: Re: [PERFORM] Optimizing Bitmap Heap Scan.
On Tue, 8 Dec 2009, niraj patel wrote:
>
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
To: niraj patel
Cc: pgsql-performance@postgresql.org
Sent: Tue, 8 December, 2009 7:12:49
18512
Gives me 261 Rows
SELECT count(r.TopFamilyID) FROM CMRules r WHERE r.WorkspaceID =18512 ;
Gives me 272 211 Rows
select count(*) from cmrules;
Gives me 17 643 532 Rows
Please suggest me something to optimize this query
Thanks
Niraj Patel
Hi All,
I want to identify the bottleneck queries inside the procedure. I want to know
which of the queries are taking the time. How can I measure time taken to
execute the individual Query inside a Procedure ?
Thank You
Niraj Patel
From: "pgsql-perfor
