| From: | "Marinos J(dot) Yannikos" <mjy(at)geizhals(dot)at> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: GiST indexes and concurrency (tsearch2) |
| Date: | 2005-02-09 19:25:36 |
| Message-ID: | 420A63B0.5020802@geizhals.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Tom Lane wrote:
> You might try the attached patch (which I just applied to HEAD).
> It cuts down the number of acquisitions of the BufMgrLock by merging
> adjacent bufmgr calls during a GIST index search. [...]
Thanks - I applied it successfully against 8.0.0, but it didn't seem to
have a noticeable effect. I'm still seeing more or less exactly 25% CPU
usage by postgres processes and identical query times (measured with the
Perl script I posted earlier).
Regards,
Marinos
--
Dipl.-Ing. Marinos Yannikos, CEO
Preisvergleich Internet Services AG
Obere Donaustrasse 63, A-1020 Wien
Tel./Fax: (+431) 5811609-52/-55
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Arthurs | 2005-02-09 19:31:56 | Re: Solaris 9 tuning |
| Previous Message | Tom Arthurs | 2005-02-09 19:23:30 | Re: Solaris 9 tuning |