tag:blogger.com,1999:blog-36031440.post7924793015114033004..comments2023-12-16T09:27:09.488-08:00Comments on Merlin's stuff: PostgreSQL 8.3 Features: Plan InvalidationMerlin Moncurehttp://www.blogger.com/profile/07784270014334369640noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-36031440.post-43198643234936458882013-08-06T13:18:57.685-07:002013-08-06T13:18:57.685-07:00it works for me only when I create a phisical tabl...it works for me only when I create a phisical table or remove the bytea column from the temp table. <br /><br />Im using version 8.4 but will try with 9.1 too.andmazotihttps://www.blogger.com/profile/14450257401087071370noreply@blogger.comtag:blogger.com,1999:blog-36031440.post-68986910597128320272013-08-06T13:17:53.037-07:002013-08-06T13:17:53.037-07:00It works for me only when I create a phisical tabl...It works for me only when I create a phisical table in my database. I'm using version 8.4 and will test it in version 9.1andmazotihttps://www.blogger.com/profile/14450257401087071370noreply@blogger.comtag:blogger.com,1999:blog-36031440.post-53324645258015815042007-09-06T14:50:00.000-07:002007-09-06T14:50:00.000-07:00Can you expand on the "function references" and ot...Can you expand on the "function references" and other cases where plan invalidation doesn't catch everything?<BR/><BR/>I'm glad you elevated the importance of this feature. It got in 8.3 early, and is one of the features that I'm looking forward to -- more for peace of mind than anything else.<BR/><BR/>This is also a big deal for slony.Jeff Davishttps://www.blogger.com/profile/11911318247166641620noreply@blogger.comtag:blogger.com,1999:blog-36031440.post-9912109628258058512007-09-05T08:27:00.000-07:002007-09-05T08:27:00.000-07:00plan invalidation is working now in cvs. I am bet...plan invalidation is working now in cvs. I am betting for postgresql to go into beta some time into oct. which suggests release in jan-feb timeframe. These are guesstimates at best...everything depends on how HOT is handled which is still up in the air at this point.Merlin Moncurehttps://www.blogger.com/profile/07784270014334369640noreply@blogger.comtag:blogger.com,1999:blog-36031440.post-61417417287336662822007-09-05T00:03:00.000-07:002007-09-05T00:03:00.000-07:00Merlingreat post, actually I was thinking about pl...Merlin<BR/><BR/>great post, actually I was thinking about pl/pgsql and comparing it with pl/sql function result cache, featured in Oracle 11g - see http://www.oracle.com/technology/oramag/oracle/07-sep/o57plsql.html<BR/><BR/>Is it possible to get pl/pgsql function result cache functionality into PostgreSQL real soon? <BR/><BR/>PeterPeter Manchevhttps://www.blogger.com/profile/10515352384841746739noreply@blogger.com