Thread: Slow Scripts - Create Script

Slow Scripts - Create Script

From

Date:

04 August 2022, 13:09:48

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

Re: Slow Scripts - Create Script

From

Ray O'Donnell

Date:

04 August 2022, 13:22:40

On 04/08/2022 14:09, endre_pekarik@yahoo.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?

I takes only 2-3 seconds for me, and I'd guess that a lot of that is 
just rendering the window. I'm on version 6.12.

Ray.


-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

Re: Slow Scripts - Create Script

From

Pepe TD Vo

Date:

04 August 2022, 13:56:52

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.

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@yahoo.com <endre_pekarik@yahoo.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

Re: Slow Scripts - Create Script

From

Aditya Toshniwal

Date:

05 August 2022, 05:12:26

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@yahoo.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.
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@yahoo.com <endre_pekarik@yahoo.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

"Don't Complain about Heat, Plant a TREE"