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

Re: downloading booleans to CSV slow

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: downloading booleans to CSV slow
Date: 2009-10-12 08:57:14
Message-ID: 937d27e10910120157i186fa5c2q66f5eb80e5820193@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On Mon, Oct 5, 2009 at 12:12 PM, Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:
> Hi,
>
> Whenever i export a query to CSV that contains booleans, writing the
> data is exceptionally slow.
> I'm using pgAdmin 1.8.4 on ubuntu, it also occurs in several (all?)
> versions on windows.

Slow compared to what? Booleans (like numerics) should be quicker than
everything else because they are written as they come from the server.
Everything else will be slowed marginally because it must be quoted
and have any quotes in the data escaped.


-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

In response to

pgadmin-support by date

Next:From: mohamed.baqer.altamimiDate: 2009-10-12 12:27:17
Subject: PgAdmin iii
Previous:From: Rhonalf Martinez VillaDate: 2009-10-10 00:16:31
Subject: The server list is not saved

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