pl/pgsql performance

From: Mehdi Ravanbakhsh <babakco(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: pl/pgsql performance
Date: 2014-04-25 08:48:05
Message-ID: CAFnRD1myZ7zCv67+9vfRcHyETo2=aZ_Np7FPz7szXuxyrfoz4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi All

I have one big Pl/Pgsql function (about 1500 line code) , i can divided it
to about 5 part and call each script from main script . In this case i
need to know which way is faster .

and some question about pgsql :

1- is pgsql engine open one process for each script ?
2- how i can chose max connection number for pgsql server based on cpu core
and RAM capacity that have maximum Efficiency?

Thanks and Best ergards.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2014-04-25 08:53:03 Re: pl/pgsql performance
Previous Message Дмитрий Шалашов 2014-04-25 08:29:02 Re: Server vacuuming the same table again and again