On Tue, Oct 17, 2017 at 9:51 AM, legrand legrand < legrand_legr...@hotmail.com> wrote:
> 1000 first rows are available in less than zone second. > See query with limit 1000. > We cannot add arbitrary limit/offsets to users queries. They will affect timing for those who are trying to tune queries, and may well affect other behaviours. Not to mention the fact that the user might be running a complex script that we would have to parse client-side to try to figure out where to add the limit/offset (and likely get it wrong). > Monitoring memory usage or PG_stat_activity shows that all the data is > fetched. Sure - pg_stat_activity (it's all lower case) will show the connection state as idle. But the point is - until it does, the query is still being processed and we don't get the data. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company