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

From: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
To: Postgresql General Group <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Slow while inserting and retrieval (compared to SQL Server)
Date: 2021-02-17 12:01:15
Message-ID: 1671732859.1031650.1613563275311@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
Using Postgres 11 in Windows Server 2012 & PowerbuilderWorking 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 AlwaysBKR Sivaprakash

Responses

Browse pgsql-general by date

  From Date Subject
Next Message luis.roberto 2021-02-17 12:05:15 Re: Slow while inserting and retrieval (compared to SQL Server)
Previous Message Pavel Stehule 2021-02-17 10:47:44 Re: How to return a jsonb list of lists (with integers)