Re: [HACKERS] Major Feature Interactions

[Merlin Moncure]

On 2/28/07, Simon Riggs [EMAIL PROTECTED] wrote:

There's a number of major features all coming together over the next
weeks, so I wanted to raise some awareness of possible areas of
interaction. My concern is more than just will multiple patches apply
together?, but extends into whether the features interact with each
other with synergy, ignore each other or have negative impact.

The projects that concern me are the following internals projects

Plan Invalidation
Autovacuum changes
Bitmap indexes
GIT indexes
Dead Space Map (DSM)
HOT Updating
Updateable cursors
Restartable VACUUM


What about the interaction of plan invalidation and the security
problems with 'security definer'?  I am especially curious if pl
functions will no longer regenerate their plans with each session for
8.3.  Is that going to be the case?  It wasn't completely clear from
the related discussions AFAICT.

merlin

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate

Re: [HACKERS] Major Feature Interactions

[Tom Lane]

Merlin Moncure [EMAIL PROTECTED] writes:
 What about the interaction of plan invalidation and the security
 problems with 'security definer'?  I am especially curious if pl
 functions will no longer regenerate their plans with each session for
 8.3.  Is that going to be the case?  It wasn't completely clear from
 the related discussions AFAICT.

No, there's no intention of caching plans across sessions.

I'm intending to build some infrastructure in namespace.c to support
a stack of override search_path values, and then tweak plancache.c
to override search_path during a replan.  (It has to be a stack because
nested replan events are entirely possible.)  I think this
infrastructure will also work for attaching search paths to functions;
but we still lack an agreed design spec for how that should look to the
user.

regards, tom lane

---(end of broadcast)---
TIP 6: explain analyze is your friend