Postgres Pro
Downloads
Home   >   mailing lists

Re: Flushing large data immediately in pqcomm - Mailing list pgsql-hackers

From Melih Mutlu
Subject Re: Flushing large data immediately in pqcomm
Date
Msg-id CAGPVpCT_nSLGkrSYYhrPH_0-4wDR1W57PeTMLoY7=bGCYTuPyg@mail.gmail.com
Whole thread Raw
In response to Re: Flushing large data immediately in pqcomm  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
Tree view
David Rowley <dgrowleyml@gmail.com>, 6 Nis 2024 Cmt, 04:34 tarihinde şunu yazdı:
Does anyone else want to try the attached script on the v5 patch to
see if their numbers are better?

I'm seeing the below results with your script on my machine (). I ran it several times, results were almost similar each time.

master:
Run 100 100 5000000: 1.627905512
Run 1024 10240 200000: 1.603231684
Run 1024 1048576 2000: 2.962812352
Run 1048576 1048576 1000: 2.940766748

v5:
Run 100 100 5000000: 1.611508155
Run 1024 10240 200000: 1.603505596
Run 1024 1048576 2000: 2.727241937
Run 1048576 1048576 1000: 2.721268988

 

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Table AM Interface Enhancements
Next
From: Andres Freund
Date:
Subject: Re: Use streaming read API in ANALYZE