Re: Slow Scripts - Create Script

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: Pepe TD Vo <pepevo(at)yahoo(dot)com>
Cc: "endre_pekarik(at)yahoo(dot)com" <endre_pekarik(at)yahoo(dot)com>, PgAdmin Support List <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Slow Scripts - Create Script
Date: 2022-08-05 05:12:26
Message-ID: CAM9w-_==_VtvtJ+0NWfsk6bR=iLDn-MZo3w+3o=UOYqq7MjKOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin

Hi Pepe,

pgAdmin does not use binary paths to generate the create scripts.

On Thu, Aug 4, 2022 at 7:27 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:

> You can changing the binary path. I had added the binary path of
> postgresql bin folder i.e. C:\Program Files\PostgreSQL\14\bin to
> PostgreSQL 14. I changed the that and it works. Open the preferences dialog
> box from 'File' in the menu bar. Then go to binary paths tab and correct it.
>
>
>
>
> *Bach-Nga*No one in this world is pure and perfect. If you avoid people
> for their mistakes you will be alone. So judge less, love, and forgive more.[image:
> Emoji][image: Emoji][image: Emoji]
> To call him a dog hardly seems to do him justice though in as much as he
> had four legs, a tail, and barked, I admit he was, to all outward
> appearances. But to those who knew him well, he was a perfect gentleman
> (Hermione Gingold)
>
> **Live simply **Love generously **Care deeply **Speak kindly.
> *** Genuinely rich *** Faithful talent *** Sharing success
>
>
>
>
> On Thursday, August 4, 2022, 08:40:12 AM EDT, endre_pekarik(at)yahoo(dot)com <
> endre_pekarik(at)yahoo(dot)com> wrote:
>
>
> Requesting Scripts-*Create Script* for Tables or Views is very slow in
> PGAdmin r4 version 6.12. I have version 4.24 also, using this version, it
> is almost instant.
>
>
>
> PGAdmin 4 version 6.12, it takes 30-40 seconds
>
> PGAdmin 4 version 4.24, it takes 2-3 seconds
>
>
>
> Is it expected behavior for later versions?
>
> Thank you
>
> Endre
>
>
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2022-08-05 05:23:09 Re: Export statistics in pgadmin 4
Previous Message Pepe TD Vo 2022-08-04 13:56:52 Re: Slow Scripts - Create Script

Browse pgsql-admin by date

  From Date Subject
Next Message manoj kathar 2022-08-06 16:56:11 error : missing chunk number 3 for toast value 14146136 in pg_toast_8895383
Previous Message Rui DeSousa 2022-08-05 04:06:29 XidGen - Panic