Re: Performance problem on RH7.1 - Mailing list pgsql-general

From Tom Lane
Subject Re: Performance problem on RH7.1
Date
Msg-id 14344.1088374472@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance problem on RH7.1  (Együd Csaba <csegyud@vnet.hu>)
Responses Re: Performance problem on RH7.1
List pgsql-general
=?iso-8859-1?Q?Egy=FCd_Csaba?= <csegyud@vnet.hu> writes:
> It is strange that the laptop substantially faster then the server. The
> get_stock* functions are executed 2-3 times faster.

So what do those stored procedures do exactly?

What it smells like to me is a bad plan for a query executed in one of
the stored procedures, but it's hard to theorize with no data.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql on debian
Next
From: "Jonathan Raemdonck"
Date:
Subject: indexing lat lon