Re: READ UNCOMMITTED in postgres

2019-12-19 Thread Olivier Gautherot
On Thu, Dec 19, 2019 at 9:20 AM Simon Riggs wrote: > On Wed, 18 Dec 2019 at 23:13, Matthew Phillips > wrote: > > >> With the current READ UNCOMMITTED discussion happening on pgsql-hackers >> [1], It did raise a question/use-case I recently encountered and could not >> find a satisfactory solutio

Re: READ UNCOMMITTED in postgres

2019-12-19 Thread Simon Riggs
On Wed, 18 Dec 2019 at 23:13, Matthew Phillips wrote: > With the current READ UNCOMMITTED discussion happening on pgsql-hackers > [1], It did raise a question/use-case I recently encountered and could not > find a satisfactory solution for. If someone is attempting to poll for new > records on a

Re: READ UNCOMMITTED in postgres

2019-12-18 Thread Thomas Kellerer
Matthew Phillips schrieb am 19.12.2019 um 00:12: > Hi, With the current READ UNCOMMITTED discussion happening on > pgsql-hackers [1], It did raise a question/use-case I recently > encountered and could not find a satisfactory solution for. If > someone is attempting to poll for new records on a hig

Re: READ UNCOMMITTED in postgres

2019-12-18 Thread Stephen Frost
Greetings, * Matthew Phillips (mphillip...@gmail.com) wrote: > With the current READ UNCOMMITTED discussion happening on pgsql-hackers > [1], It did raise a question/use-case I recently encountered and could not > find a satisfactory solution for. If someone is attempting to poll for new > records

READ UNCOMMITTED in postgres

2019-12-18 Thread Matthew Phillips
Hi, With the current READ UNCOMMITTED discussion happening on pgsql-hackers [1], It did raise a question/use-case I recently encountered and could not find a satisfactory solution for. If someone is attempting to poll for new records on a high insert volume table that has a monotonically increasing