From: John Jensen <JRJ@ft.fo>
To: pgsql-admin@postgresql.org
To: jfradkin@wazagua.com
Subject: Re: who is best for support?
Date: Wed, 16 Feb 2005 08:23:01 +0000
Message-ID: <s21302f5.054@fs3.ft.fo> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: JRJ@ft.fo, jfradkin@wazagua.com
Subject: Re: who is best for support?
In-Reply-To: <s21302f5.054@fs3.ft.fo>
References: <s21302f5.054@fs3.ft.fo>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox