Skip site navigation (1) Skip section navigation (2)

Performance testing of COPY (SELECT) TO

From: Böszörményi Zoltán <zboszor(at)dunaweb(dot)hu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Performance testing of COPY (SELECT) TO
Date: 2006-08-25 07:31:42
Message-ID: 3015.213.163.11.81.1156491102.squirrel@www.dunaweb.hu (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Hi,

we have a large export here, I made an in-house benchmark
between Informix, plain PostgreSQL-8.1.4 and
8.2devel+COPY(SELECT) using the same data and query.
Find the results below for the two PostgreSQL versions.
With PostgreSQL 8.1.4, I used this:

begin;
select ... into temp myquery1;
copy myquery1 to stdout csv delimiter '|';
rollback;

With 8.2devel, I simple used
copy (select ...) to stdout csv delimiter '|';

# of clients:			1*		3**		10**
PostgreSQL		1:33		10:58		55:46
PostgreSQL 8.2		1:19		4:55		18:28

*  - average of 4 runs, the first was with cold caches after reboot
** - 1 run, average of cliens' runtimes

Performance between 8.1.4 and 8.2devel is interesting:
1 client: 15%
3 clients: 55.2%
10 clients: 66.9%

The same machine was used for testing.

Best regards,
Zoltán Böszörményi


Responses

pgsql-hackers by date

Next:From: ITAGAKI TakahiroDate: 2006-08-25 08:51:10
Subject: Re: autovacuum cannot start when connection is full
Previous:From: Albe LaurenzDate: 2006-08-25 07:04:18
Subject: 8.2 new features

pgsql-patches by date

Next:From: Greg Sabino MullaneDate: 2006-08-25 10:17:55
Subject: Re: [PATCHES] Intervals within information_schema
Previous:From: Peter EisentrautDate: 2006-08-25 06:34:53
Subject: Re: [PATCHES] Intervals within information_schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group