Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 157E8632F34
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 20 Apr 2010 15:20:06 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 68478-04
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 20 Apr 2010 18:19:44 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail63.csoft.net (mail63.csoft.net [205.205.214.4])
	by mail.postgresql.org (Postfix) with ESMTP id 489B0632DFD
	for <pgsql-performance@postgresql.org>;
	Tue, 20 Apr 2010 15:19:55 -0300 (ADT)
Received: from mail63.csoft.net (localhost [127.0.0.1])
	by mail63.csoft.net (Postfix) with ESMTP id E1B4E2842F;
	Tue, 20 Apr 2010 14:19:53 -0400 (EDT)
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=csoft.net; h=date:from:to
	:cc:subject:in-reply-to:message-id:references:mime-version
	:content-type; s=sel1; bh=sJU0O/g/YjlCgFJ31rQ28lJFIJ4=; b=H8JEjN
	uEwUjMHBOfP+TQbrk/Pc0z9XUHi0U9yoMVAndIqxZLvFYZ5n6KBF5StsjXdL+1ZL
	DrTzeVJnAcAOAKvJ8zRX2uQFsuYb7peCbXdWAoStnkbsJH9PxstvZ+W0wUFEgkRs
	2c2gsTnVFqc597XIDsnAz0N2aulD9SP1bUsqI=
Received: from leary.csoft.net (leary.csoft.net [205.205.214.5])
	by mail63.csoft.net (Postfix) with ESMTP id D743E2841F;
	Tue, 20 Apr 2010 14:19:53 -0400 (EDT)
Received: by leary.csoft.net (Postfix, from userid 1112)
	id 5F6B7A425; Tue, 20 Apr 2010 14:19:53 -0400 (EDT)
Date: Tue, 20 Apr 2010 14:19:52 -0400 (EDT)
From: Kris Jurka <books@ejurka.com>
X-X-Sender: books@leary.csoft.net
To: Nikolas Everett <nik9000@gmail.com>
cc: David Kerr <dmk@mr-paradox.net>, Robert Haas <robertmhaas@gmail.com>,
	pgsql-performance@postgresql.org
Subject: Re: Very high effective_cache_size == worse performance?
In-Reply-To: <w2ld4e11e981004201112v3571f350zaaa0112d1e035097@mail.gmail.com>
Message-ID: <alpine.BSO.2.00.1004201418530.30295@leary.csoft.net>
References: <20100420173936.GA50886@mr-paradox.net>
	<h2w603c8f071004201044tbc8ce8fenb846b7643a2b9376@mail.gmail.com>
	<20100420180351.GA51940@mr-paradox.net>
	<w2ld4e11e981004201112v3571f350zaaa0112d1e035097@mail.gmail.com>
User-Agent: Alpine 2.00 (BSO 1167 2008-08-23)
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.812 tagged_above=-10 required=5 tests=AWL=-1.602,
	BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: QUOTED-PRINTABLE
X-Archive-Number: 201004/249
X-Sequence-Number: 38499



On Tue, 20 Apr 2010, Nikolas Everett wrote:

> You can absolutely use copy if you like but you need to use a non-standard
> jdbc driver: =A0kato.iki.fi/sw/db/postgresql/jdbc/copy/. =A0I've used it =
in the
> past and it worked.

Copy support has been added to the 8.4 driver.

Kris Jurka