From: | luis(dot)roberto(at)siscobra(dot)com(dot)br |
---|---|
To: | sivapostgres(at)yahoo(dot)com |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Slow while inserting and retrieval (compared to SQL Server) |
Date: | 2021-02-17 12:05:15 |
Message-ID: | 871844152.5278987.1613563515397.JavaMail.zimbra@siscobra.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- Mensagem original -----
> De: sivapostgres(at)yahoo(dot)com
> Para: "pgsql-general" <pgsql-general(at)lists(dot)postgresql(dot)org>
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | sivapostgres@yahoo.com | 2021-02-17 12:54:18 | Re: Slow while inserting and retrieval (compared to SQL Server) |
Previous Message | sivapostgres@yahoo.com | 2021-02-17 12:01:15 | Re: Slow while inserting and retrieval (compared to SQL Server) |