Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.4 open item: copy performance regression? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: 8.4 open item: copy performance regression?
Date
Msg-id 4A3BF767.6060207@agliodbs.com
Whole thread Raw
In response to Re: 8.4 open item: copy performance regression?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-hackers
Tree view 
> so 4096 * 1024 / BLCKSZ seems to be the sweet spot and also results in
> more or less the same performance that 8.3 had.

Can some folks test this with different size COPYs?  That's both 
larger/smaller tables, and larger/smaller rows.  We should also test 
copy with large blob data.


-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Suppressing occasional failures in copy2 regression test
Next
From: Gurjeet Singh
Date:
Subject: Re: Suppressing occasional failures in copy2 regression test