| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Pavan Deolasee <pavan(at)enterprisedb(dot)com>, Gavin Sherry <swm(at)alcove(dot)com(dot)au>, Luke Lonergan <llonergan(at)greenplum(dot)com>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Doug Rady <drady(at)greenplum(dot)com>, Sherry Moore <sherry(dot)moore(at)sun(dot)com> |
| Subject: | Re: Bug: Buffer cache is not scan resistant |
| Date: | 2007-03-05 22:07:51 |
| Message-ID: | 45EC94B7.3080303@paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
>
> Hm, not really a smoking gun there. But just for grins, would you try
> this patch and see if the numbers change?
>
Applied to 8.2.3 (don't have lineitem loaded in HEAD yet) - no change
that I can see:
procs -----------memory---------- ---swap-- -----io---- --system--
----cpu----
r b swpd free buff cache si so bi bo in cs us
sy id wa
1 0 764 55300 0 1988032 0 0 118797 32 1532 1775 15
39 44 2
1 0 764 54476 0 1989720 0 0 115507 9 1456 3970 15
39 45 1
1 0 788 54540 0 1989592 0 0 121651 0 1508 3221 16
37 47 0
1 0 788 52808 0 1991320 0 0 124109 0 1532 1236 15
38 46 0
1 0 788 52504 0 1991784 0 0 124518 0 1547 1005 16
39 45 0
2 0 788 54544 0 1989740 0 5 117965 5 1491 2012 15
36 47 2
1 0 788 53596 0 1991184 0 0 120424 0 1504 1910 16
37 46 1
Elapsed time is exactly the same (101 s). Is is expected that HEAD would
behave differently?
Cheers
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Rylander | 2007-03-05 22:18:51 | xml2 contrib patch supporting default XML namespaces |
| Previous Message | Pavel Stehule | 2007-03-05 22:02:56 | Re: proposal: custom variables management |