| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Joshua Berkus <josh(at)agliodbs(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Subject: | Re: reducing the overhead of frequent table locks - now, with WIP patch |
| Date: | 2011-06-07 20:00:36 |
| Message-ID: | 19288.1307476836@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> Moving on from that, I have proposed other solutions. Koichi, Jignesh
> and and then Robert have shown measurements of the huge contention in
> this area of our software. Robert's patch addresses the problems, as
> do Koichi's and my latest patch. I would like to see us do
> *something* about these problems for 9.1. Not all of them are risky or
> time consuming.
In the first place, all of these issues predate 9.1 by years. They are
not regressions or new bugs, and they have not suddenly gotten more
urgent. In the second place, I haven't seen any proposals in the area
that appear low risk. I seriously doubt that I would consider *any*
meaningful change in the locking area to be low risk.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2011-06-07 20:03:26 | Re: reducing the overhead of frequent table locks - now, with WIP patch |
| Previous Message | Robert Creager | 2011-06-07 19:54:04 | Re: [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD |