Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-08-27 Thread Bruce Momjian
Any status on this? --- On Mon, Feb 13, 2012 at 04:34:51PM +0100, Vik Reykja wrote: On Mon, Feb 13, 2012 at 15:25, Robert Haas robertmh...@gmail.com wrote: On Sat, Feb 11, 2012 at 9:06 PM, Vik Reykja

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-08-27 Thread Dean Rasheed
On 27 August 2012 19:09, Bruce Momjian br...@momjian.us wrote: Any status on this? Tom took care of it in the last commitfest - http://archives.postgresql.org/pgsql-hackers/2012-06/msg01075.php I think that todo item can now be marked as done. Regards, Dean -- Sent via pgsql-hackers

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-08-27 Thread Bruce Momjian
On Mon, Aug 27, 2012 at 08:35:00PM +0100, Dean Rasheed wrote: On 27 August 2012 19:09, Bruce Momjian br...@momjian.us wrote: Any status on this? Tom took care of it in the last commitfest - http://archives.postgresql.org/pgsql-hackers/2012-06/msg01075.php I think that todo item can

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-08-27 Thread Dean Rasheed
On 27 August 2012 20:42, Bruce Momjian br...@momjian.us wrote: On Mon, Aug 27, 2012 at 08:35:00PM +0100, Dean Rasheed wrote: On 27 August 2012 19:09, Bruce Momjian br...@momjian.us wrote: Any status on this? Tom took care of it in the last commitfest -

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-08-27 Thread Bruce Momjian
On Mon, Aug 27, 2012 at 09:10:35PM +0100, Dean Rasheed wrote: On 27 August 2012 20:42, Bruce Momjian br...@momjian.us wrote: On Mon, Aug 27, 2012 at 08:35:00PM +0100, Dean Rasheed wrote: On 27 August 2012 19:09, Bruce Momjian br...@momjian.us wrote: Any status on this? Tom took

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-08-27 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: On Mon, Aug 27, 2012 at 09:10:35PM +0100, Dean Rasheed wrote: It's listed under https://wiki.postgresql.org/wiki/Todo#Referential_Integrity I think the main points mentioned there have now all been taken care of. Ah, got it. Marked as done. IMO the

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-08-27 Thread Bruce Momjian
On Mon, Aug 27, 2012 at 04:37:25PM -0400, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: On Mon, Aug 27, 2012 at 09:10:35PM +0100, Dean Rasheed wrote: It's listed under https://wiki.postgresql.org/wiki/Todo#Referential_Integrity I think the main points mentioned there have now

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-08-27 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: On Mon, Aug 27, 2012 at 04:37:25PM -0400, Tom Lane wrote: IMO the second point is done but the first is not: there's still a question of whether we could remove the trigger-time checks for equality now that there's an upstream filter. Possibly break the

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-02-13 Thread Chetan Suttraway
On Sun, Feb 12, 2012 at 7:36 AM, Vik Reykja vikrey...@gmail.com wrote: I decided to take a crack at the todo item created from the following post: http://archives.postgresql.org/pgsql-performance/2005-10/msg00458.php The attached patch makes the desired changes in both code and function

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-02-13 Thread Robert Haas
On Sat, Feb 11, 2012 at 9:06 PM, Vik Reykja vikrey...@gmail.com wrote: I decided to take a crack at the todo item created from the following post: http://archives.postgresql.org/pgsql-performance/2005-10/msg00458.php The attached patch makes the desired changes in both code and function

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-02-13 Thread Vik Reykja
On Mon, Feb 13, 2012 at 15:25, Robert Haas robertmh...@gmail.com wrote: On Sat, Feb 11, 2012 at 9:06 PM, Vik Reykja vikrey...@gmail.com wrote: I decided to take a crack at the todo item created from the following post: http://archives.postgresql.org/pgsql-performance/2005-10/msg00458.php

Re: [HACKERS] Optimize referential integrity checks (todo item)

2012-02-13 Thread Vik Reykja
On Mon, Feb 13, 2012 at 11:02, Chetan Suttraway chetan.suttra...@enterprisedb.com wrote: The patch was not getting applied. Was seeing below message: postgresql$ git apply /Downloads/unchanged.patch error: src/backend/utils/adt/ri_triggers.c: already exists in working directory Have come

[HACKERS] Optimize referential integrity checks (todo item)

2012-02-11 Thread Vik Reykja
I decided to take a crack at the todo item created from the following post: http://archives.postgresql.org/pgsql-performance/2005-10/msg00458.php The attached patch makes the desired changes in both code and function naming. It seemed quite easy to do but wasn't marked as easy on the todo, so