On Sat, Apr 27, 2024 at 12:47 AM Sushrut Shivaswamy <
sushrut.shivasw...@gmail.com> wrote:
>
> I"m trying to read the rows of a table in chunks to process them in a
> background worker.
>
This list really isn't the place for this kind of discussion. You are
doing application-level stuff, not
Hi
You can also use the following approaches.
1. Cursors
2. FETCH with OFFSET clause
Regards
Kashif Zeeshan
Bitnine Global
On Sat, Apr 27, 2024 at 12:47 PM Sushrut Shivaswamy <
sushrut.shivasw...@gmail.com> wrote:
> Hey,
>
> I"m trying to read the rows of a table in chunks to process them in
Hey,
I"m trying to read the rows of a table in chunks to process them in a
background worker.
I want to ensure that each row is processed only once.
I was thinking of using the `SELECT * ... OFFSET {offset_size} LIMIT
{limit_size}` functionality for this but I"m running into issues.
Some