----- Mensagem original ----- > De: "sivapostgres" <sivapostgres@xxxxxxxxx> > Para: "luis.roberto" <luis.roberto@xxxxxxxxxxxxxxx> > Cc: "pgsql-general" <pgsql-general@xxxxxxxxxxxxxxxxxxxx> > 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@xxxxxxxxxxxxxxx> > 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?
