On Tue, Mar 8, 2022 at 06:36:17PM +0530, aditya desai wrote: > Hi Tom, > I added BEGIN and COMMIT as shown below around insert and executed it from > pgadmin for 100,000 rows. It ran in just 1 min. > > BEGIN; > INSERT INTO TABLE VALUES(....); > INSERT INTO TABLE VALUES(....); > . > , > COMMIT; > > However when I run above from psql by passing it to psql(As shown below) as a > file. It still takes a lot of time. Am I doing anything wrong? How can I run > this from pgadmin within a minute? > > psql -h host -U user -p Port -d database < INSERT_FILE.sql > > PSQL is still printing as below. > INSERT 0 1 > INSERT 0 1 Uh, they should be the same. You can turn on log_statement=all on the server and look at what queries are being issued in each case. -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
