| 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-19 10:16:56 |
| Message-ID: | 45FE6318.8080204@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Deolasee | 2007-03-19 10:27:32 | Re: CREATE INDEX and HOT (was Question: pg_class attributes and race conditions ?) |
| Previous Message | Heikki Linnakangas | 2007-03-19 10:09:03 | Re: CREATE INDEX and HOT (was Question: pg_class attributes and race conditions ?) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-03-19 17:43:28 | Re: suggestion for improving TMPDIR and "--format" docs for pg_dump |
| Previous Message | Magnus Hagander | 2007-03-19 08:48:19 | Re: ecpg threading vs win32 |