Joe Conway wrote:
> Nabil Sayegh wrote:
> [...big snowflake query and explain analyze results...]
>> Is there anything I can do to speed it a bit up?
>> We can assume, that
>> a) inserts are done very rarely and
>> b) the number of actual results are very low
> One simple idea is to use PREPARE and EXECUTE. This is only useful if
> you can PREPARE once and then EXECUTE multiple times (i.e. as long as
> you don't need to reconnect prior to every execution of the query).
Hm, unfortunately my queries (at least the expensive ones) are only executed once per session.
If only it could be made persistent, then it would help :(
Any other ideas?
What if I create views for such queries?
Would these be faster (i.e. prepared automatically/persistent)?
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-04-06 04:25:26|
|Subject: Re: Help for MSSQL "Compute" equivalent in Postgres |
|Previous:||From: Joe Conway||Date: 2004-04-05 05:27:09|
|Subject: Re: snowflaking|