Received: from smtp.ualg.pt (smtp.ualg.pt [193.136.224.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g15CIkl32696 for ; Tue, 5 Feb 2002 07:18:47 -0500 (EST) (envelope-from llsousa@ualg.pt) Received: from localhost (smtp.ualg.pt [127.0.0.1]) by smtp.ualg.pt (Postfix) with ESMTP id 32F814BB71 for ; Tue, 5 Feb 2002 12:18:48 +0000 (WET) Received: from ualg.pt (corisco.uceh.ualg.pt [10.10.20.126]) by smtp.ualg.pt (Postfix) with ESMTP id 6EFCA4BB6D for ; Tue, 5 Feb 2002 12:18:47 +0000 (WET) Message-ID: <3C5FCDA7.4050302@ualg.pt> Date: Tue, 05 Feb 2002 12:18:47 +0000 From: Luis Sousa User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.5) Gecko/20011023 X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql Subject: Execute some of the elements of the RULE without a plan to the VIEW Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS snapshot-20010714 X-Archive-Number: 200202/52 X-Sequence-Number: 6483 Hi I have a RULE that executes 5 queries. Each query executed is created a plan to the view, that means that in the end I will have 5 query plans to that view, when I only needed 1. I don't know if this is the best way, but I'm doing 5 queries because I have to pass to a function 17 parameters and postgres have the limitation of 16. I have two tables of parameters, that I use. First I delete all that could be there before, then I insert the new parameters and after I execute my function, all inside the rule. Can I do this in other way to improve the perfomance ? Thanks, Luis Sousa