Hi Joel,
I'm running on a more or less similar hw config and my speed is pretty
ok.
My base is currently weighing in at 50Gig.
You may be having problems with the query itself. Aside from index'es
how you construct the query can have a dramatic impact on execution
time.
I can highly recommend the book "SQL Tuning" by Dan Tow.
It's database independant so I think this guy is relly on to the core
of the
problem. He's got a web site on (I shit you not):
http://www.singingsql.com/
Have you looked into the I/O rates (iostat) on your disk devices. One
of them
might be broken/slow.
Good luck
John
>>> "Joel Fradkin" <jfradkin@wazagua.com> 02/15/05 8:12 pm >>>
Hi,
I am trying to get postgres working on a Dell and am finidng my SQL
queries
run incrediably slow.
I have tried to adjust cache and buffers, etc with no luck.
Any advice on who would be best for help either it's a config issue or
a
query issue etc.
I been trying for a few weeks to get up to speed and diagnose, but I
am
running out of time.
Joel Fradkin
