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.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com