From: Kaloyan Iliev Iliev <news1@faith.digsys.bg>
To: Miroslav Љulc <miroslav.sulc@startnet.cz>
To: pgsql-performance@postgresql.org
Subject: Re: How to read query plan
Date: Mon, 14 Mar 2005 19:03:37 +0200
Message-ID: <4235C3E9.2080505@faith.digsys.bg> (raw)
In-Reply-To: <4235BCE8.1090705@startnet.cz>
References: <42345D24.8070104@startnet.cz>
<4234692E.3050802@arbash-meinel.com>
<42347407.2000202@startnet.cz>
<42347D5E.9000900@arbash-meinel.com>
<42348F54.1000408@startnet.cz>
<423493E5.6040203@arbash-meinel.com>
<42355249.8090101@startnet.cz>
<opsnmecyijth1vuj@localhost>
<423556B8.4020500@startnet.cz>
<14079.1110817416@sss.pgh.pa.us>
<4235BCE8.1090705@startnet.cz>
Hi,
I have an idea about your problem. Will it be difficult not to change
the entire code but only the queries? You can change type in the
Postgres to bool. Then, when select data you can use a CASE..WHEN to
return 'Y' or 'N' or even write a little function which accepts bool and
returns 'Y' or 'N'. In this case in all your queries you will have to
replace the select of bool field with select form the function.
Kaloyan
Miroslav Љulc wrote:
> Tom Lane wrote:
>
>> Just FYI, I did a quick search-and-replace on your dump to replace
>> varchar(1) by "char", which makes the column fixed-width without any
>> change in the visible data. This made hardly any difference in the
>> join speed though :-(. So that is looking like a dead end.
>>
>>
> I'll try to change the data type to bool but the problem I stand in
> front of is that the code expects that SELECTs return 'Y' or 'N' but
> what I have found out till now is that PostgreSQL returns 't' or 'f'
> for bool data. I think about some solution but they use CPU :-(
>
>> John's idea about re-joining to the main table to pick up the bulk of
>> its fields only after joining to the sub-tables might work.
>>
>>
> I'll try that. It seems it could work.
>
>> regards, tom lane
>>
>>
> Miroslav
>
>------------------------------------------------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: news1@faith.digsys.bg, miroslav.sulc@startnet.cz
Subject: Re: How to read query plan
In-Reply-To: <4235C3E9.2080505@faith.digsys.bg>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox