Re: Any way to speed up INSERT INTO

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.

Re: Any way to speed up INSERT INTO

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; >

Re: Any way to speed up INSERT INTO

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 wrote: > On Tue, Mar 8, 2022 at 06:36:17PM +0530, aditya desai wrote: > > Hi Tom, > > I added BEGIN and COMMIT as sho