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 AlwaysBKR Sivaprakash
On Wednesday, 17 February, 2021, 05:35:43 pm IST,
<[email protected]> wrote:
----- Mensagem original -----
> De: [email protected]
> Para: "pgsql-general" <[email protected]>
> Enviadas: Quarta-feira, 17 de fevereiro de 2021 9:01:15
> Assunto: Re: Slow while inserting and retrieval (compared to SQL Server)
>
> Hello,
>
> Using Postgres 11 in Windows Server 2012 & Powerbuilder
> Working from the same machine where Postgres 11 is installed. So no chance
> for any network issue, I feel.
> No setup/config change done. Just working with all the default settings.
> With no data in any of the 179 tables in that database.
>
> To populate some basic data we try to insert few records (max 4 records) in
> few tables (around 6 tables) from one window. We feel that the insert time
> taken is longer than the time taken while using Sql Server. We tested almost
> a similar window that updated the similar table(s) in SQL server, which was >
> > faster. With Postgres database, we need to wait for a couple of seconds
> before the insert/update is over, which we didn't feel in Sql Server.
>
> I feel that some changes in settings might improve this speed, but with not
> much knowledge in Postgres I struggle to find out those setup values.
>
> Any help in improving the speed is really appreciated.
>
> Happiness Always
> BKR Sivaprakash
Can you run EXPLAIN (ANALYZE,BUFFERS) on the INSERT command and post the
results here? Usually inserting this many records should be instantaneous.
