Re: Any way to speed up INSERT INTO

> Correct rows are wider. One of the columns is text and one is bytea.

with the PG14 the LZ4 compression is worth checking.

via
https://www.postgresql.fastware.com/blog/what-is-the-new-lz4-toast-compression-in-postgresql-14

*"""INSERT statements with 16 clientsAnother common scenario that I tested
was accessing the database from multiple clients - 16 in this case.What I
found out, as can be seen below, is that compression performance of single
large files (HTML, English text, source code, executable binary, pictures)
using LZ4 was 60% to 70% faster compared to PGLZ, and that there was also a
small improvement while inserting multiple small files (PostgreSQL
document).*
*"""*

kind regards,
Imre

aditya desai <admad123(at)gmail(dot)com> ezt írta (időpont: 2022. márc. 4., P,
19:42):

> Hi Bruce,
> Correct rows are wider. One of the columns is text and one is bytea.
>
> Regards,
> Aditya.
>
> On Sat, Mar 5, 2022 at 12:08 AM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
>> On Sat, Mar 5, 2022 at 12:01:52AM +0530, aditya desai wrote:
>> > Hi,
>> > One of the service layer app is inserting Millions of records in a
>> table but
>> > one row at a time. Although COPY is the fastest way to import a file in
>> a
>> > table. Application has a requirement of processing a row and inserting
>> it into
>> > a table. Is there any way this INSERT can be tuned by increasing
>> parameters? It
>> > is taking almost 10 hours for just 2.2 million rows in a table. Table
>> does not
>> > have any indexes or triggers.
>>
>> Well, sections 14.4 and 14.5 might help:
>>
>> https://www.postgresql.org/docs/14/performance-tips.html
>>
>> Your time seems very slow --- are the rows very wide?
>>
>> --
>> 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.
>>
>>