From: | Hans-Jürgen Schönig <postgres(at)cybertec(dot)at> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PREPARE / EXECUTE |
Date: | 2002-10-23 16:55:06 |
Message-ID: | 3DB6D46A.5000903@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This is exactly what we do in case of complex stuff. I know that it can
help to reduce the problem for the planner.
However: If you have explicit joins across 10 tables the SQL statement
is not that readable any more and it is still slower than a prepared
execution plan.
I guess it is worth thinking about prepared plans somewhere on disk.
Is there a way to transform ASCII -> plan?
Hans
Bruno Wolff III wrote:
>On Wed, Oct 23, 2002 at 18:04:01 +0200,
> Hans-Jürgen Schönig <postgres(at)cybertec(dot)at> wrote:
>
>
>>An example:
>>I have a join across 10 tables + 2 subselects across 4 tables
>>on the machine I use for testing:
>> planner: 12 seconds
>> executor: 1 second
>>
>>The application will stay the same forever.
>>I could be 10 times faster if there was a way to load the execution plan
>>into the backend.
>>
>>
--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at
<http://cluster.postgresql.at>, www.cybertec.at
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Copeland | 2002-10-23 17:52:34 | Re: PREPARE / EXECUTE |
Previous Message | Nicolae Mihalache | 2002-10-23 16:46:41 | Re: crashes with postgresql 7.2.1 on IRIX 6.5 |