| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Mario Weilguni" <mweilguni(at)sime(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org>, "Josh Berkus" <josh(at)agliodbs(dot)com>, "Jim Nasby" <decibel(at)decibel(dot)org> |
| Subject: | Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers |
| Date: | 2007-07-25 14:09:09 |
| Message-ID: | 1185372549.4146.33.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-performance |
On Wed, 2007-07-25 at 15:07 +0200, Mario Weilguni wrote:
> Am Mittwoch 25 Juli 2007 schrieb Simon Riggs:
> > I have reasonable evidence that Referential Integrity is the major
> > performance bottleneck and would like some objective evidence that this
> > is the case.
>
> Just curious, will 8.3 still check FK constraints (and use locks) even if the
> referencing column value does not change?
That is optimised away in 8.0+
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2007-07-25 14:09:50 | Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers |
| Previous Message | Dave Page | 2007-07-25 14:02:00 | Re: PostgreSQL vs. MySQL: fight |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2007-07-25 14:09:50 | Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers |
| Previous Message | Ansgar -59cobalt- Wiechers | 2007-07-25 13:35:12 | Re: index over timestamp not being used |