From: | f vf <fvalentef(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Executing more than one function. |
Date: | 2011-08-23 15:30:06 |
Message-ID: | CAA2T4CXFMaTQDP47KyWXajDQ_ifLwUWnYQq1_Nrt7Gvv=R+CHQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have a set of plsql functions that I want to execute. All these functions
perform queries and insert data in the database and I need to execute them
in order.
What I have noticed is that if I execute this script
BEGIN;
SELECT function1();
COMMIT;
BEGIN;
SELECT function2();
COMMIT;
BEGIN;
SELECT function3();
COMMIT;
it takes more time than if I execute one function at the time and sum the
execution times of each one:
BEGIN;
SELECT functionX();
COMMIT;
In some cases if there are several millions of tuples in the database
running all the rules in the same script takes 10 times more than running
one at the time.
Can anyone explain why this happens and how can I prevent it?
Thanks for the help.
Filipe
From | Date | Subject | |
---|---|---|---|
Next Message | Giuseppe Sacco | 2011-08-23 16:42:29 | Re: Executing more than one function. |
Previous Message | Raghavendra | 2011-08-23 15:00:55 | Re: Wal archiving and streaming replication |