----- Mensagem original ----- > De: sivapostg...@yahoo.com > Para: "pgsql-general" <pgsql-general@lists.postgresql.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.
