X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 45312475B99 for ; Sat, 3 May 2003 14:34:14 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 69D08475A8D for ; Sat, 3 May 2003 14:34:08 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3006026; Sat, 03 May 2003 11:33:33 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Becky Neville , pgsql-performance@postgresql.org Subject: Re: why is the db so slow? Date: Sat, 3 May 2003 11:32:56 -0700 User-Agent: KMail/1.4.3 References: In-Reply-To: MIME-Version: 1.0 Message-Id: <200305031132.56012.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-31.1 required=5.0 tests=BAYES_01,IN_REP_TO,NO_DNS_FOR_FROM,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/26 X-Sequence-Number: 1805 Becky, > I am running my own database server but I don't have root privilege (and > no hope of getting it.) > 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=20 while to respond. Even if CPU isn't in heavy use, I'd guess some other=20 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 t= hat=20 are teaching PostgreSQL. However, if this is for school, PostgreSQL is not very efficient being run = as=20 a seperate installation for each user. For multiuser installations, it i= s=20 far better to have one installation and many databases with restricted=20 permissions. I also suspect that you database being in /tmp may be causing you problems;= =20 many sysadmins put the /tmp partition on their slowest drive since it's=20 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 tha= t=20 you browse through the online archives of this list, which will be far more= =20 educational than me giving you a few tips. However, be aware that no postgresql.conf settings, however clever, can mak= e=20 up for an overloaded system, poor disk configuration, or slow system I/O.= =20=20=20 At best correct settings ameliorate poor performance. --=20 Josh Berkus Aglio Database Solutions San Francisco