Postgres performance analysis resulted in a 10x improvement in CPU use

Re:Postgres performance analysis resulted in a 10x improveme... by stonelazy on Sunday May 21, 2017 @10:46PM (#14390643)

I wonder what the author means by batch inserts ? How would it have been achieved ? Is it a procedure or something ?

[ Parent | on HN ]

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 ]