Horton

Re: Patch: plan invalidation vs stored procedures

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Asko Oja" <ascoja@gmail.com>
Cc: "Pavel Stehule" <pavel.stehule@gmail.com>, "Dimitri Fontaine" <dfontaine@hi-media.com>, pgsql-hackers@postgresql.org, "Andrew Dunstan" <andrew@dunslane.net>, "David Fetter" <david@fetter.org>, "Martin Pihlak" <martin.pihlak@gmail.com>
Date: 2008-08-19T00:29:42Z
Lists: pgsql-hackers 
"Asko Oja" <ascoja@gmail.com> writes:
> For users of stored procedures it is protection from downtime. For Skype it
> has been around 20% of databse related downtime this year.

Perhaps Skype needs to rethink how they are modifying functions.

The reason that this case wasn't covered in 8.3 is that there didn't
seem to be a use-case that justified doing the extra work.  I still
haven't seen one.  Other than inline-able SQL functions there is no
reason to invalidate a stored plan based on the fact that some function
it called changed contents.

			regards, tom lane