Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B04F49FA9BD for ; Thu, 2 Nov 2006 12:08:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 40775-02 for ; Thu, 2 Nov 2006 12:08:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 8529C9FB298 for ; Thu, 2 Nov 2006 12:08:23 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1Gff73-00042c-T7 for pgsql-admin@postgresql.org; Thu, 02 Nov 2006 11:08:18 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 23C164172; Thu, 2 Nov 2006 11:08:17 -0500 (EST) Date: Thu, 2 Nov 2006 11:08:17 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: New to PostgreSQL Message-ID: <20061102160817.GC28643@phlogiston.dyndns.org> References: <002a01c6fded$663e8e50$b501a8c0@D1RPQZB1> <200611021013.25097.achill@matrix.gatewaynet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200611021013.25097.achill@matrix.gatewaynet.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/10 X-Sequence-Number: 23537 On Thu, Nov 02, 2006 at 11:13:24AM +0300, Achilleas Mantzios wrote: > > I think, apart from postgresql you gotta get familiar with the linux/*bsd/unix > concepts as well, as sometimes performance has to do with OS tuning too. Let me echo that, because it's extremely important: when I was in charge of hiring people to work on our databases, I was very concerned not to get the sort of people who felt that the system was "the sysadmin's problem". You _cannot_ treat the operating system as not your problem when addressing performance questions in PostgreSQL. This is a very unfamiliar situation to most Oracle and some DB2 administrators, in my experience. The good ones, of course, have no problem catching on; the bad ones never deserved the name DBA anyway ;-) A -- Andrew Sullivan | ajs@crankycanuck.ca Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz