pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSlow Scripts - Create Script
4+ messages / 4 participants
[nested] [flat]
* Slow Scripts - Create Script
@ 2022-08-04 12:39 endre_pekarik@yahoo.com
2022-08-04 12:58 ` Re: Slow Scripts - Create Script Matheus Alcantara <mths.dev@pm.me>
2022-08-04 13:56 ` Re: Slow Scripts - Create Script Pepe TD Vo <pepevo@yahoo.com>
0 siblings, 2 replies; 4+ messages in thread
From: endre_pekarik@yahoo.com @ 2022-08-04 12:39 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Slow Scripts - Create Script
2022-08-04 12:39 Slow Scripts - Create Script endre_pekarik@yahoo.com
@ 2022-08-04 12:58 ` Matheus Alcantara <mths.dev@pm.me>
1 sibling, 0 replies; 4+ messages in thread
From: Matheus Alcantara @ 2022-08-04 12:58 UTC (permalink / raw)
To: endre_pekarik@yahoo.com; +Cc: pgsql-admin
------- Original Message -------
On Thursday, August 4th, 2022 at 09:39, <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
I think that you should send an e-mail for PGAdmin support mailing list that is pgadmin-support@lists.postgresql.org
This mailing list is focused on PostgreSQL support, but maybe someone can help you too.
https://www.postgresql.org/list/pgadmin-support/
--
Matheus Alcantara
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Slow Scripts - Create Script
2022-08-04 12:39 Slow Scripts - Create Script endre_pekarik@yahoo.com
@ 2022-08-04 13:56 ` Pepe TD Vo <pepevo@yahoo.com>
2022-08-05 05:12 ` Re: Slow Scripts - Create Script Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
1 sibling, 1 reply; 4+ messages in thread
From: Pepe TD Vo @ 2022-08-04 13:56 UTC (permalink / raw)
To: endre_pekarik@yahoo.com <endre_pekarik@yahoo.com>; PgAdmin Support List <pgadmin-support@lists.postgresql.org>
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:
<!--#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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Slow Scripts - Create Script
2022-08-04 12:39 Slow Scripts - Create Script endre_pekarik@yahoo.com
2022-08-04 13:56 ` Re: Slow Scripts - Create Script Pepe TD Vo <pepevo@yahoo.com>
@ 2022-08-05 05:12 ` Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
0 siblings, 0 replies; 4+ messages in thread
From: Aditya Toshniwal @ 2022-08-05 05:12 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: endre_pekarik@yahoo.com <endre_pekarik@yahoo.com>; PgAdmin Support List <pgadmin-support@lists.postgresql.org>
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.[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@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*
<http://edbpostgres.com;
"Don't Complain about Heat, Plant a TREE"
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-08-05 05:12 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-08-04 12:39 Slow Scripts - Create Script endre_pekarik@yahoo.com
2022-08-04 12:58 ` Matheus Alcantara <mths.dev@pm.me>
2022-08-04 13:56 ` Pepe TD Vo <pepevo@yahoo.com>
2022-08-05 05:12 ` Re: Slow Scripts - Create Script Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox