Re: setFetchSize

On 10/26/11 1:22 PM, fschmidt wrote:
> Dave Cramer-8 wrote:
>> >
>> >  My understanding is this: Postgresql is an MVCC database and can
>> >  easily provide you with a snapshot of a resultset inside a
>> >  transaction. Outside a transaction my bet is that the data has to be
>> >  copied to a temporary location somewhere, so if this is done over N
>> >  connections the resources required could be substantial.
>> >
> The solution is very simple.  Just keep the version associated with the
> current resultset around until the resultset is closed.  This is basically
> the same as having another connection, but in this case, each resultset on
> the connection should use the version that was associated with the
> connection when the resultset was opened.

so now vacuum needs to pay attention to the oldest pending result set as
well as the oldest transaction?

hmmm.


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast