Re: Slow while inserting and retrieval (compared to SQL Server) - Mailing list pgsql-general

From luis.roberto@siscobra.com.br
Subject Re: Slow while inserting and retrieval (compared to SQL Server)
Date
Msg-id 194819330.5537540.1613567444523.JavaMail.zimbra@siscobra.com.br
Whole thread Raw
In response to Re: Slow while inserting and retrieval (compared to SQL Server)  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
List pgsql-general
----- Mensagem original -----
> De: "sivapostgres" <sivapostgres@yahoo.com>
> Para: "luis.roberto" <luis.roberto@siscobra.com.br>
> Cc: "pgsql-general" <pgsql-general@lists.postgresql.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.roberto@siscobra.com.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?



pgsql-general by date:

Previous
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Slow while inserting and retrieval (compared to SQL Server)
Next
From: Thomas Kellerer
Date:
Subject: Re: Slow while inserting and retrieval (compared to SQL Server)