Re: Slow while inserting and retrieval (compared to SQL Server)

----- Mensagem original -----
> De: "sivapostgres" <sivapostgres(at)yahoo(dot)com>
> Para: "luis.roberto" <luis(dot)roberto(at)siscobra(dot)com(dot)br>
> Cc: "pgsql-general" <pgsql-general(at)lists(dot)postgresql(dot)org>
> Enviadas: Quarta-feira, 17 de fevereiro de 2021 9:54:18
> Assunto: Re: Slow while inserting and retrieval (compared to SQL Server)

> Hello,
> Yes, that's what I feel. With no records in any tables, working from the same
> machine where PG has been installed, with only one user working, inserting few
> records (10 records in total, in all 6 tables) should not take this much time.

> I'll be inserting records from PowerBuilder applications, and how to catch the
> result of Explain. OR should I run all insert commands in PG Admin or so and
> catch those results?

> As I'm new to PG, any documentation/help in this direction will be useful.

> Happiness Always
> BKR Sivaprakash

> On Wednesday, 17 February, 2021, 05:35:43 pm IST, <luis(dot)roberto(at)siscobra(dot)com(dot)br>
> wrote:

You can run it wherever you prefer. I'm not familiar with PowerBuilder, so I'd say PGAdmin.
BTW, if you run the INSERTs on PGAdmin, do you still seeing slow timings?