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).
In response to
pgsql-novice by date
|Next:||From: Nabil Sayegh||Date: 2004-04-05 12:02:56|
|Subject: Re: snowflaking|
|Previous:||From: stm23||Date: 2004-04-05 03:31:05|
|Subject: ecpg preprocessor|