| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Marzen | 2003-09-28 11:13:54 | Re: Tuning/performance question. |
| Previous Message | Shridhar Daithankar | 2003-09-28 10:08:36 | C/C++/Java [was Re: State of Beta 2] |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Marzen | 2003-09-28 11:13:54 | Re: Tuning/performance question. |
| Previous Message | David Griffiths | 2003-09-28 03:49:23 | Tuning/performance question. |