From: | Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> |
---|---|
To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
Cc: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCHES] Bitmapscan changes |
Date: | 2007-03-21 15:16:52 |
Message-ID: | 3BFE0985-5245-4268-8BFF-9A013C2E65FF@pointblue.com.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Mar 19, 2007, at 11:16 AM, Heikki Linnakangas wrote:
> Grzegorz Jaskiewicz wrote:
>> On Mar 16, 2007, at 10:12 PM, Heikki Linnakangas wrote:
>>> You'll obviously need to run it with the patch applied. I'd
>>> suggest to enable stats_block_level to see the effect on buffer
>>> cache hit/miss ratio.
>> groupeditems-42-pghead.patch.gz is enough, or it needs
>> maintain_cluster_order_v5.patch ??
>
> No, it won't make a difference unless you're inserting to the
> table, and the inserts are not in cluster order.
well, that's okay than. I see really good improvement in terms of
speed and db size (which reflects obviously in i/o performance).
Let me know if further testing can be done. I would happily see it in
mainline.
--
Grzegorz Jaskiewicz
C/C++ freelance for hire
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-03-21 15:23:30 | Re: [PATCHES] Bitmapscan changes |
Previous Message | Tom Lane | 2007-03-21 15:15:46 | Re: [COMMITTERS] pgsql: Native shared memory implementation for win32. |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-03-21 15:23:30 | Re: [PATCHES] Bitmapscan changes |
Previous Message | Tom Lane | 2007-03-21 13:45:48 | Re: patch adding new regexp functions |