Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
How to analyze function performance
- From: "Mindaugas" <mind(at)bi(dot)lt>
- To: <pgsql-performance(at)postgresql(dot)org>
- Subject: How to analyze function performance
- Date: Thu, 15 Jun 2006 15:16:32 +0300
Hello, Is it possible to somehow analyze function performance? E.g. we are using function cleanup() which takes obviously too much time to execute but I have problems trying to figure what is slowing things down. When I explain analyze function lines step by step it show quite acceptable performance. PostgreSQL 8.0 is running on two dual core Opterons. Thanks, Mindaugas
- Follow-Ups:
- Re: How to analyze function performance
- From: Tom Lane
- Re: How to analyze function performance
- From: Tomas Vondra
- Re: How to analyze function performance
- Prev by Date: Re: Postgres consuming way too much memory???
- Next by Date: Re: How to analyze function performance
- Previous by thread: Is it possible to start two instances of postgresql?
- Next by thread: Re: How to analyze function performance
- Indexes: