Обсуждение: Slow Scripts - Create Script

Поиск
Список
Период
Сортировка

Slow Scripts - Create Script

От
Дата:

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

От
Ray O'Donnell
Дата:
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

От
Pepe TD Vo
Дата:
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.EmojiEmojiEmoji
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

От
Aditya Toshniwal
Дата:
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.EmojiEmojiEmoji
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"