Re: Difference between Bulk Load (Multiple inserts or single inserts) and COPY

2019-12-21 Thread Bruce Momjian
This is not a documentation question. For assistance, please join the appropriate mailing list and post your question: http://www.postgresql.org/community You can also try the #postgresql IRC channel on irc.freenode.net. See the PostgreSQL FAQ for more information. --

Difference between Bulk Load (Multiple inserts or single inserts) and COPY

2019-12-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-copy.html Description: Hello, > I experimented with Bulk load and COPY. > Loading in COPY was very fast. > However, after COPYing data from a CSV file to PostgreSQL Table. The query >

Re: Difference between Bulk Load (Multiple inserts or single inserts) and COPY

2019-11-30 Thread Bruce Momjian
On Tue, Nov 19, 2019 at 11:55:44PM +0100, Laurenz Albe wrote: > On Tue, 2019-11-19 at 18:55 +, PG Doc comments form wrote: > > I experimented with Bulk load and COPY. > > Loading in COPY was very fast. > > However, after COPYing data from a CSV file to PostgreSQL Table. The query > > execution

Difference between Bulk Load (Multiple inserts or single inserts) and COPY

2019-11-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-copy.html Description: Hello, > I experimented with Bulk load and COPY. > Loading in COPY was very fast. > However, after COPYing data from a CSV file to PostgreSQL Table. The query >

Re: Difference between Bulk Load (Multiple inserts or single inserts) and COPY

2019-11-19 Thread Laurenz Albe
On Tue, 2019-11-19 at 18:55 +, PG Doc comments form wrote: > I experimented with Bulk load and COPY. > Loading in COPY was very fast. > However, after COPYing data from a CSV file to PostgreSQL Table. The query > execution took lot of time for 1 of the first 4 queries. > Only this slow query w

Difference between Bulk Load (Multiple inserts or single inserts) and COPY

2019-11-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-copy.html Description: Hello, Myself Mayank. I am a Ph.D. student. I experimented with Bulk load and COPY. Loading in COPY was very fast. However, after COPYing data from a CSV fil