Hi,
Hmm, ok, I'll pass that onto our DBA/operations guys, and see if that helps.
Do these settings still work if you only have a single Postgres instance? (I'll need to check out setup).
As a rough guide, the dumped CSV file is around 600 Mb.
Is there any other background you might be able to give on what you think might be happening, or how this might fix it?
And you'd recommend tweaking these values over trying to chunk up the COPY/SELECT, is that right?
I've just realised the LIMIT/ORDER thing may not work well to paginate, since there may be new records, or deleted records between each time I call it?
Cheers,
Victor