Postgres Pro
Downloads
Home   >   mailing lists

Re: Tuning/performance question. - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Tuning/performance question.
Date
Msg-id 200309281539.56558.shridhar_daithankar@persistent.co.in
Whole thread Raw
In response to Tuning/performance question.  (David Griffiths <dgriffiths@boats.com>)
List pgsql-general
Tree view 
On Sunday 28 September 2003 09:19, David Griffiths wrote:
> No difference. Note that all the keys that are used in the joins are
> numeric(10)'s, so there shouldn't be any cast-issues.

Can you make them bigint and see? It might make some difference perhaps.

Checking the plan in the meantime.. BTW what tuning you did to postgresql?

Check http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html, assuming
you haven't seen earlier..

 HTH

 Shridhar

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: C/C++/Java [was Re: State of Beta 2]
Next
From: Holger Marzen
Date:
Subject: Re: Tuning/performance question.