Skip site navigation (1) Skip section navigation (2)

Postgresql7.4.5 running slow on plpgsql function

From: "Chun Yit(Chronos)" <ivanbeh(at)chronos(dot)com(dot)my>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Postgresql7.4.5 running slow on plpgsql function
Date: 2005-06-23 09:56:52
Message-ID: 000601c577d9$e2658600$a279640a@Beh (view raw or flat)
Thread:
Lists: pgsql-performance
>hi, need some help with some experts here.
>currently we have a function that use together with temp table, it calls search result function, everytime
>this function is calling, it will go through some filter before come out as a result.
>now we have some major problem , the first time the function execute, it take about 13 second
>second time the function is execute, it take about 17 second, every time you execute the function
>the time taken will grow about 4 second, ?
>may i know what going on here?
>since we use function with temp table, so every statement that related to temp table will using EXECUTE
>command.
>
>regards
>ivan

Responses

pgsql-performance by date

Next:From: Meetesh KariaDate: 2005-06-23 10:40:15
Subject: How are text columns stored?
Previous:From: Radu-Adrian PopescuDate: 2005-06-23 09:22:17
Subject: Re: Performance Tuning Article

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group