> Correct rows are wider. One of the columns is text and one is bytea.
with the PG14 the LZ4 compression is worth checking.
kind regards,
Imre
with the PG14 the LZ4 compression is worth checking.
"""
INSERT statements with 16 clients
Another 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).
INSERT statements with 16 clients
Another 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@xxxxxxxxx> 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@xxxxxxxxxx> 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@xxxxxxxxxx> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
