Re: Autocommit, isolation level, and vacuum behavior

Поиск
Список
Период
Сортировка
От Jack Orenstein
Тема Re: Autocommit, isolation level, and vacuum behavior
Дата
Msg-id 48CA741D.7020307@hds.com
обсуждение исходный текст
Ответ на Re: Autocommit, isolation level, and vacuum behavior  (Tomasz Ostrowski <tometzky@batory.org.pl>)
Ответы Re: Autocommit, isolation level, and vacuum behavior  (Tomasz Ostrowski <tometzky@batory.org.pl>)
Список 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 по дате отправления:

Предыдущее
От: Jack Orenstein
Дата:
Сообщение: Re: Autocommit, isolation level, and vacuum behavior
Следующее
От: André Volpato
Дата:
Сообщение: Re: Converting string to IN query