From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Böszörményi Zoltán <zboszor(at)dunaweb(dot)hu> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Performance testing of COPY (SELECT) TO |
Date: | 2006-08-25 12:53:07 |
Message-ID: | 22730.1156510387@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
=?iso-8859-2?Q?B=F6sz=F6rm=E9nyi_Zolt=E1n?= <zboszor(at)dunaweb(dot)hu> writes:
> With PostgreSQL 8.1.4, I used this:
> begin;
> select ... into temp myquery1;
> copy myquery1 to stdout csv delimiter '|';
> rollback;
The performance of this would doubtless vary a lot with the temp_buffers
setting. Did you try different values?
It'd also be interesting to time the same way (with a temp table) in
devel. I don't remember whether we did any performance work on the
COPY CSV data path in this cycle, or whether that was all present in
8.1. In any case it'd be worth proving that the COPY SELECT patch isn't
degrading performance of the copy-a-relation case.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2006-08-25 13:10:11 | Re: Tricky bugs in concurrent index build |
Previous Message | Tom Lane | 2006-08-25 12:42:05 | Re: Tricky bugs in concurrent index build |
From | Date | Subject | |
---|---|---|---|
Next Message | Böszörményi Zoltán | 2006-08-25 13:40:38 | Re: [HACKERS] Performance testing of COPY (SELECT) TO |
Previous Message | Greg Sabino Mullane | 2006-08-25 10:17:55 | Re: [PATCHES] Intervals within information_schema |