Le 16/04/2011 21:19, John Pagakis a écrit :
> I've noticed this problem for a while, but haven't reported it. Sorry.
> If you run a query in PGAdmin saving the results to disk and that query
> selects one or more booleans it takes orders of magnitude longer for the
> result set to save to disk that it does if you do not select those columns
> in the query.
Well, if you have less data, it's not surprising it's quicker to export.
> I've resorted to this work-around (when I remember it, and when I don't I
> curse and go get a snack <grin>):
> Instead of:
> If I do this:
> CASE WHEN is_a_boolean = TRUE THEN 't' ELSE 'f' END
> I avoid the problem.
This is more surprising. I don't reproduce this on 1.12. Could you tell
us more about your working set? how many lines for example? can you send
me a self-contained examples with your time measurements? Thanks.
In response to
pgadmin-support by date
|Next:||From: Guillaume Lelarge||Date: 2011-04-17 13:18:42|
|Subject: Re: Feature request: Allow Grant Wizard at lower
|Previous:||From: Guillaume Lelarge||Date: 2011-04-17 12:55:56|
|Subject: Re: pgAdmin: blank header in the "Edit Data" window
if table OID changes|