Skip site navigation (1) Skip section navigation (2)

Re: Tuning/performance question.

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning/performance question.
Date: 2003-09-28 10:09:56
Message-ID: 200309281539.56558.shridhar_daithankar@persistent.co.in (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
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


In response to

pgsql-performance by date

Next:From: Holger MarzenDate: 2003-09-28 11:13:54
Subject: Re: Tuning/performance question.
Previous:From: David GriffithsDate: 2003-09-28 03:49:23
Subject: Tuning/performance question.

pgsql-general by date

Next:From: Holger MarzenDate: 2003-09-28 11:13:54
Subject: Re: Tuning/performance question.
Previous:From: Shridhar DaithankarDate: 2003-09-28 10:08:36
Subject: C/C++/Java [was Re: State of Beta 2]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group