Postgres Pro
Downloads
Home   >   mailing lists

How to analyze function performance - Mailing list pgsql-performance

From Mindaugas
Subject How to analyze function performance
Date
Msg-id 016401c69075$8a35e8c0$f20214ac@bite.lt
Whole thread Raw
Responses Re: How to analyze function performance
Re: How to analyze function performance
List pgsql-performance
Tree view 
  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

pgsql-performance by date:

Previous
From: "jody brownell"
Date:
Subject: Re: Postgres consuming way too much memory???
Next
From: Tomas Vondra
Date:
Subject: Re: How to analyze function performance