From: Josh Berkus <josh@agliodbs.com>
To: Becky Neville <rebecca.neville@yale.edu>
To: pgsql-performance@postgresql.org
Subject: Re: why is the db so slow?
Date: Sat, 3 May 2003 11:32:56 -0700
Message-ID: <200305031132.56012.josh@agliodbs.com> (raw)
In-Reply-To: <Pine.LNX.4.44.0305031334230.7237-100000@termite.zoo.cs.yale.edu>
References: <Pine.LNX.4.44.0305031334230.7237-100000@termite.zoo.cs.yale.edu>
Becky,
> I am running my own database server but I don't have root privilege (and
> no hope of getting it.)
<snip>
> typing something as dumb as \! pwd is not instantaneous either and there
> doesn't seem to be anyone else hogging up the CPU.
It sounds to me like the system has something wrong with it if "pwd" takes a
while to respond. Even if CPU isn't in heavy use, I'd guess some other
process is eating RAM or disk I/O
> I am on Linux and due to lack of space in my own account, I have PGDATA
> pointing to /tmp.
> (This is for a class project to analyze query performance ...I can
> recreate the data at any time if necessary.)
Really? What class? I'm personally very interested to know of schools that
are teaching PostgreSQL.
However, if this is for school, PostgreSQL is not very efficient being run as
a seperate installation for each user. For multiuser installations, it is
far better to have one installation and many databases with restricted
permissions.
I also suspect that you database being in /tmp may be causing you problems;
many sysadmins put the /tmp partition on their slowest drive since it's
regarded as disposable.
> Are there any parameters I can set to speed things up?
Lots, the settings of many of which are a matter of debate. I suggest that
you browse through the online archives of this list, which will be far more
educational than me giving you a few tips.
However, be aware that no postgresql.conf settings, however clever, can make
up for an overloaded system, poor disk configuration, or slow system I/O.
At best correct settings ameliorate poor performance.
--
Josh Berkus
Aglio Database Solutions
San Francisco
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-performance@postgresql.org
Cc: josh@agliodbs.com, rebecca.neville@yale.edu
Subject: Re: why is the db so slow?
In-Reply-To: <200305031132.56012.josh@agliodbs.com>
References: <Pine.LNX.4.44.0305031334230.7237-100000@termite.zoo.cs.yale.edu> <200305031132.56012.josh@agliodbs.com>
* 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