Ok Will check. But from pgadmin it takes 1min and by psql it is taking 20 mins for 100,000 rows with BEGIN; COMMIT;
Thanks, Aditya. On Tue, Mar 8, 2022 at 8:23 PM Bruce Momjian <br...@momjian.us> wrote: > 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 <br...@momjian.us> https://momjian.us > EDB https://enterprisedb.com > > If only the physical world exists, free will is an illusion. > >
