Re: count(*) performance improvement ideas

PFC wrote
> <Stephen(dot)Denne(at)datamail(dot)co(dot)nz> wrote:
> > I don't know plpythonu (nor python), just read a few docs now:
>
> Learn Python, it is a really useful language ;)

My wife has a snake phobia, besides, I've just started learning Scala.

> There is no sharing between processes, so
> - both SD and GD are limited to the current session
> (connection, postgres
> process), no shared memory is involved
> - GD is global between all python functions (global)
> - SD is specific to each python function (static)

Thanks.

> The big gotcha is that these are all non-transactional
> : if you rollback,
> GD and SD stay the same, and when you issue a query, you can
> assume the
> state of SD and GD is random (due to previous queries) unless you
> initialize them to a known value.

Using txid_current() as a key should alleviate that.

Regards,
Stephen Denne.

Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer focus, and courage. This email with any attachments is confidential and may be subject to legal privilege. If it is not intended for you please advise by reply immediately, destroy it and do not copy, disclose or use it in any way.
__________________________________________________________________
This email has been scanned by the DMZGlobal Business Quality
Electronic Messaging Suite.
Please see http://www.dmzglobal.com/dmzmessaging.htm for details.
__________________________________________________________________