Re: Autocommit, isolation level, and vacuum behavior

From: Jack Orenstein <jack(dot)orenstein(at)hds(dot)com>
To: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Autocommit, isolation level, and vacuum behavior
Date: 2008-09-12 13:52:29
Message-ID: 48CA741D.7020307@hds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-09-12 13:54:49 Re: Converting string to IN query
Previous Message Jack Orenstein 2008-09-12 13:51:51 Re: Autocommit, isolation level, and vacuum behavior