| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Proposal of tunable fix for scalability of 8.4 |
| Date: | 2009-03-17 22:59:38 |
| Message-ID: | 1237330778.3953.139.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 2009-03-17 at 17:41 -0400, Jignesh K. Shah wrote:
> I did a quick test with patch. Unfortunately it improves my number
> even with default setting 0 (not sure whether I should be pleased or
> sad - Definitely no overhead infact seems to help performance a bit.
> NOTE: Logic is same, implementation is slightly different for default
> set)
OK, I bite. 25% gain from doing nothing??? You're stretching my... err,
credulity.
I like the train of thought for setting 1 and it is worth investigating,
but something feels wrong somewhere.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jignesh K. Shah | 2009-03-17 23:54:54 | Re: Proposal of tunable fix for scalability of 8.4 |
| Previous Message | Greg Smith | 2009-03-17 22:38:44 | Re: parallelizing slow queries for multiple cores (PostgreSQL + Gearman) |