[Bizgres-general] Another use case

Luke Lonergan LLonergan at greenplum.com
Wed Aug 9 06:22:03 UTC 2006


Mark,
   
> Sorry if I'm being thick here

Please be thick!

> So we want to take resource 
> locks at planning time?

No, we don't! It's a lot better if this isn't the case.

Our supposition as a group was that that's how it's done - which puzzled
me given the topic of prepared statements, etc.

> The current implementation does not 
> do this. The resource lock is taken in PortalRun, so a plan 
> has been generated and returned
> *before* a statement is queued. There is some subtlety with 
> cursors, but the previous statement still holds!

OK - does that mean that locks are not taken before a statement is
queued?

If that's the case, it makes many things simpler.

- Luke



More information about the Bizgres-general mailing list