Re: Data grid: fetching/scrolling data on user demand

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Data grid: fetching/scrolling data on user demand
Дата
Msg-id CA+OCxox5jSeAg2mXnbuFfsybv6bJKFoiga-DX3Dx-o1y---OeQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Data grid: fetching/scrolling data on user demand  (legrand legrand <legrand_legrand@hotmail.com>)
Список pgadmin-support
Дерево обсуждения


On Tue, Oct 17, 2017 at 9:51 AM, legrand legrand <legrand_legrand@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

В списке pgadmin-support по дате отправления:

Предыдущее
От: legrand legrand
Дата:
Сообщение: Re: Data grid: fetching/scrolling data on user demand
Следующее
От: Murtuza Zabuawala
Дата:
Сообщение: Re: Data grid: fetching/scrolling data on user demand