On Thu, Feb 7, 2019 at 1:11 PM 길P.day93 wrote:
> hello, i'm pgadmin4 users and developer.
> In my customer environment uses korean, some directories name is korean.
> but in this case, i can't run Make.bat.
> please help me to solve it.
> error message is UnicodeDecodeError. so, i want change enc
hello, i'm pgadmin4 users and developer.
In my customer environment uses korean, some directories name is korean.
but in this case, i can't run Make.bat.
please help me to solve it.
error message is UnicodeDecodeError. so, i want change encoding unicode ->
utf-8 but, i don't know what to change.
If
Hi Nikita,
Your message helped me to discover HeidiSql which is (for my needs), even
though its implementation for Postgres is experimental, much more convenient
as pgAdmin v4.x
It is not as friendly as pgAdmin III but is intuitive enough to accomplish
basic tasks.
Lets hope that HeidiSql
The following is for EXPLAIN SELECT * FROM quotations
HeidiSQL:
QUERY PLAN
Seq Scan on quotations (cost=0.00..5177.66 rows=80566 width=629)
PostgreSQL:
QUERY PLAN
Seq Scan on quotations (cost=0.00..5177.66 rows=80566 width=629)
If I do EXPLAIN ANALYZE SELECT * FROM quotation
Can you run an explain query in both? And copy the results...
__
Saludos
Ing. Ricardo Martín Gomez
DBA - SysAdmin
De: Nikita Kiryanov
Enviado: miércoles, 6 de febrero de 2019 07:54
Para: 'Ricardo Martin Gomez'; pgadmin-support@lists.postgresql.
Hi Ricardo,
I tried to reverse the order (first HeidiSQL then pgAdmin), but the result was
the same.
From: Ricardo Martin Gomez [mailto:rimartingo...@hotmail.com]
Sent: Wednesday, February 6, 2019 12:43 PM
To: Nikita Kiryanov ;
pgadmin-support@lists.postgresql.org
Subject: RE: pgadmin3 i
Hi Nikita,
Are you run both querys in the same order always?
(First pgAdmin, second HeidiSQL or psql)?
Can you try run querys in different order?
(maybe the results are in memory, so it's faster the second run.)
__
Saludos
Ing. Ricardo Martín Gomez
DBA - SysAdmin
If I use pgAdmin3 to query a remote database with SELECT * FROM big_table, the
whole thing takes 1.5 minutes until I get my results.
If I run the same query, from the same computer, to the same remote database,
using a different client (HeidiSQL, or even pgsql), it
takes 5 seconds.
I run pgA
