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

Re: Performance testing of COPY (SELECT) TO

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Gregory StarkDate: 2006-08-25 13:10:11
Subject: Re: Tricky bugs in concurrent index build
Previous:From: Tom LaneDate: 2006-08-25 12:42:05
Subject: Re: Tricky bugs in concurrent index build

pgsql-patches by date

Next:From: Böszörményi ZoltánDate: 2006-08-25 13:40:38
Subject: Re: [HACKERS] Performance testing of COPY (SELECT) TO
Previous:From: Greg Sabino MullaneDate: 2006-08-25 10:17:55
Subject: Re: [PATCHES] Intervals within information_schema

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