| From: | Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com> |
|---|---|
| To: | legrand legrand <legrand_legrand(at)hotmail(dot)com> |
| Cc: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Data grid: fetching/scrolling data on user demand |
| Date: | 2017-10-17 09:05:08 |
| Message-ID: | CAKKotZQBN-tQHJTfPU-JJb0zN9Pbsr27cd6gLZYqrWS+Mk5xyg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
As I mentioned in my previous email that we do not use server side cursor,
so it won't add any limit on query.
The delay is from database driver itself, it has nothing to do with
pgAdmin4.
Try executing the same query in 'psql', 'pgAdmin3' and third party tool
which use libpq library as backend, you will observe the same behaviour.
On Tue, Oct 17, 2017 at 2:21 PM, legrand legrand <
legrand_legrand(at)hotmail(dot)com> wrote:
> 1000 first rows are available in less than zone second.
> See query with limit 1000.
>
> Monitoring memory usage or PG_stat_activity shows that all the data is
> fetched.
>
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support
> -f2191615.html
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomek | 2017-10-17 09:51:46 | Re: Data grid: fetching/scrolling data on user demand |
| Previous Message | Dave Page | 2017-10-17 09:00:46 | Re: Data grid: fetching/scrolling data on user demand |