Re: Slow Scripts - Create Script

From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
To: "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-04 13:56:52
Message-ID: 1689912397.771618.1659621412382@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin

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(at)yahoo(dot)com <endre_pekarik(at)yahoo(dot)com> wrote:

<!--#yiv2388635796 _filtered {} _filtered {}#yiv2388635796 #yiv2388635796 p.yiv2388635796MsoNormal, #yiv2388635796 li.yiv2388635796MsoNormal, #yiv2388635796 div.yiv2388635796MsoNormal {margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv2388635796 span.yiv2388635796EmailStyle17 {font-family:"Calibri", sans-serif;color:windowtext;}#yiv2388635796 .yiv2388635796MsoChpDefault {font-family:"Calibri", sans-serif;} _filtered {}#yiv2388635796 div.yiv2388635796WordSection1 {}-->
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

 

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2022-08-05 05:12:26 Re: Slow Scripts - Create Script
Previous Message Fredy Hurtado 2022-08-04 13:28:03 Export statistics in pgadmin 4

Browse pgsql-admin by date

  From Date Subject
Next Message Don Seiler 2022-08-04 14:29:20 Determining Indexes to Rebuild on new libc
Previous Message Matheus Alcantara 2022-08-04 12:58:07 Re: Slow Scripts - Create Script