Обсуждение: Re: [pgadmin-hackers] PGADMIN 4.1 Bug #2031

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

pgAdmin 4 is a very different architecture, one in which such large
amounts of data are likely to cause problems. I don't consider that an
issue though because a) it's simply not possible for humans to
mentally handle that amount of data, and b) other benefits of the
architecture outweigh supporting capabilities that no-one can use
practically.

On Wed, Dec 21, 2016 at 9:47 AM, Miriyala Teja <miriyala.teja@tcs.com> wrote:
> Hi Dave,
>
>       Pgadmin - III is used to handle the same amount of data . When I am
> trying to handle the same
> amount of data in pgadmin-4 it is taking a lot of physical memory and also
> cpu usage which is
> more than four fold compared to pgadmin-iii .
>       I would like to know whether i need to change any configuration on top
> of standard installation.
>
> Thanks & Regards
> Miriyala Teja
> Tata Consultancy Services Limited
> Cell:- 9550986333
> Mailto: miriyala.teja@tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty. IT Services
> Business Solutions
> Consulting
> ____________________________________________
>
>
> -----Dave Page <dpage@pgadmin.org> wrote: -----
> To: Miriyala Teja <miriyala.teja@tcs.com>
> From: Dave Page <dpage@pgadmin.org>
> Date: 12/21/2016 02:27PM
> Cc: pgadmin-hackers <pgadmin-hackers@postgresql.org>
> Subject: Re: [pgadmin-hackers] PGADMIN 4.1 Bug #2031
>
>
>
>
> On Wed, Dec 21, 2016 at 6:37 AM, Miriyala Teja <miriyala.teja@tcs.com>
> wrote:
>>
>> Hi
>>
>> Can you please guide on this ?
>>
>> When i am trying to retrieve 10 lakh records in pgadmin 4 . The cpu usage
>> and physical memory getting increased and finally not responding.
>>
>> if the same table when i am trying to retrieve in pgadmin 3 it is taking
>> very low cpu usage and physical memory.Is there any configuration which
>>
>>  i might missed ?
>>
>> i am looking forward to your reply.
>
>
> How can you deal with viewing a million records? I don't think anyone is
> capable of working with that much data.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company