title: PostgreSQL LIMIT with OFFSET is not working beyond 100000
body: <p>I am using postgres (9.6) docker for my project. After loading large volume of data, for example 234453, I need to cut data in  chunks using limit and offset. But I have observed that my query is getting hanged beyond the limit of 100000.
  Like I can cut when I am giving limit 100000. But when I am using 120000, it is hanging.</p>
  <p>Data loaded: 234453 rows
  Query:
  This is working:
  docker exec -it pg_1 psql -P pager postgres postgres -t -c &quot;delete from schema1.table1 where col_id not in (select col_id from schema1.table1 limit 100000 offset 1)&quot;</p>
  <p>This is hanged:
  docker exec -it pg_1 psql -P pager postgres postgres -t -c &quot;delete from schema1.table1 where col_id not in (select col_id from schema1.table1 limit 120000 offset 1)&quot;</p>
  <p>The next cut should be from 100001 to 230000, something like that.</p>
  <p>Can you please let me know, how can I do that? Or whether I am doing anything wrong?</p>
  <p>Thanks,
  Suvendu</p>