From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
---|---|
To: | Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> |
Cc: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCHES] Bitmapscan changes |
Date: | 2007-03-21 16:22:58 |
Message-ID: | 46015BE2.7010001@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Grzegorz Jaskiewicz wrote:
>
> 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.
If you have a real-world database you could try it with, that would be
nice. The test I sent you is pretty much a best-case scenario, it'd be
interesting to get anecdotal evidence of improvements in real applications.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Saqib Awan | 2007-03-21 16:23:05 | Limiting user connnections on 7.4 |
Previous Message | Pavan Deolasee | 2007-03-21 16:10:20 | Re: HOT WIP Patch - Version 5.0 |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-03-21 17:27:50 | Re: [PATCHES] Bitmapscan changes |
Previous Message | Joshua D. Drake | 2007-03-21 15:23:30 | Re: [PATCHES] Bitmapscan changes |