From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | aditya desai <admad123(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Any way to speed up INSERT INTO |
Date: | 2022-03-08 14:53:49 |
Message-ID: | Yidt/abMPVcTOUnX@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
From | Date | Subject | |
---|---|---|---|
Next Message | aditya desai | 2022-03-09 06:09:55 | Re: Any way to speed up INSERT INTO |
Previous Message | aditya desai | 2022-03-08 13:06:17 | Re: Any way to speed up INSERT INTO |