Re: PGAdmin - saving result sets from queries where one or more columns are of the type boolean

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:
>
> SELECT
> col_a,
> col_b,
> is_a_boolean,
> col_c
> FROM
> baz;
>
> If I do this:
>
> SELECT
> col_a,
> col_b,
> CASE WHEN is_a_boolean = TRUE THEN 't' ELSE 'f' END
> col_c
> FROM
> baz;
>
> 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.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com