News for hackers. Stuff that matters.

A comment on Postgres performance analysis resulted in a 10x improvement in CPU use. Parent comment

Re:Postgres performance analysis resulted in a 10x improveme... by cpburns2009 on Monday May 22, 2017 @02:12PM (#14395732)
The simplest way to perform a batch insert is by using an INSERT statement with many rows in the VALUES clause. E.g.,

    INSERT INTO table (columns...)
    VALUES
        (row 1...),
        (row 2...),
        ...
An alternative and potentially faster method is using the COPY FROM statement.
[ Parent | on HN ]

There are no comments on this comment yet.