Search Postgresql Archives

Re: Autocommit, isolation level, and vacuum behavior

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux