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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | ITAGAKI Takahiro | 2006-08-25 08:51:10 | Re: autovacuum cannot start when connection is full |
Previous Message | Albe Laurenz | 2006-08-25 07:04:18 | 8.2 new features |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2006-08-25 10:17:55 | Re: [PATCHES] Intervals within information_schema |
Previous Message | Peter Eisentraut | 2006-08-25 06:34:53 | Re: [PATCHES] Intervals within information_schema |