Re: Autocommit, isolation level, and vacuum behavior - Mailing list pgsql-general

From Jack Orenstein
Subject Re: Autocommit, isolation level, and vacuum behavior
Date
Msg-id 48CA741D.7020307@hds.com
Whole thread Raw
In response to Re: Autocommit, isolation level, and vacuum behavior  (Tomasz Ostrowski <tometzky@batory.org.pl>)
Responses Re: Autocommit, isolation level, and vacuum behavior  (Tomasz Ostrowski <tometzky@batory.org.pl>)
List pgsql-general
Tomasz Ostrowski wrote:
> On 2008-09-11 17:21, Jack Orenstein wrote:
>
>> The id > last_id trick doesn't work for me -- I don't have an index that would
>> support it efficiently.
>
> You do not have a primary key? If you do then you have an index as it is
> automatically created.

Sorry, I misspoke. I have an index, but preferred doing a scan without the index
in this case.

Jack

pgsql-general by date:

Previous
From: Jack Orenstein
Date:
Subject: Re: Autocommit, isolation level, and vacuum behavior
Next
From: André Volpato
Date:
Subject: Re: Converting string to IN query