From mk_spam@comcast.net Wed Apr 7 19:10:03 2004 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D268DD1BB16 for ; Wed, 7 Apr 2004 16:10:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 54324-09 for ; Wed, 7 Apr 2004 16:10:02 -0300 (ADT) Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [204.127.202.55]) by svr1.postgresql.org (Postfix) with ESMTP id B37C3D1D05F for ; Wed, 7 Apr 2004 16:09:55 -0300 (ADT) Received: from game (c-24-13-191-126.client.comcast.net[24.13.191.126]) by comcast.net (sccrmhc11) with SMTP id <2004040719095701100rrcgue>; Wed, 7 Apr 2004 19:09:57 +0000 Message-ID: <00dd01c41cd3$ed6e1bf0$0201a8c0@game> Reply-To: "Nid" From: "Nid" To: Subject: Postgresql educational sources Date: Wed, 7 Apr 2004 14:10:01 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00DA_01C41CAA.045EDB80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_50, HTML_MESSAGE, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200404/88 X-Sequence-Number: 6388 This is a multi-part message in MIME format. ------=_NextPart_000_00DA_01C41CAA.045EDB80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Rather than ask some general, unanswerable question on how to tune my datab= ase...I thought I ask where I might find an introduction to...or manual/tut= orial for the depths of managing a postgres db. Books? Websites? Assume = a basic to intermediate knowledge of DBs in general with a desire to learn = about postgres from the ground up. If it makes a difference I'm using a po= stgres db in a Red Hat Linux OS environment. Thanks! nid ------=_NextPart_000_00DA_01C41CAA.045EDB80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Rather than ask some general, unanswerable= question=20 on how to tune my database...I thought I ask where I might find an introduc= tion=20 to...or manual/tutorial for the depths of managing a postgres db. =20 Books?  Websites?  Assume a basic to intermediate knowledge of DB= s in=20 general with a desire to learn about postgres from the ground up.  If = it=20 makes a difference I'm using a postgres db in a Red Hat Linux OS=20 environment.  Thanks!
 
nid
------=_NextPart_000_00DA_01C41CAA.045EDB80-- From scott.marlowe@ihs.com Wed Apr 7 20:28:11 2004 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8CABCD1D062 for ; Wed, 7 Apr 2004 17:28:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95511-02 for ; Wed, 7 Apr 2004 17:28:10 -0300 (ADT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 71729D1C9DA for ; Wed, 7 Apr 2004 17:28:07 -0300 (ADT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i37KRWjX014298; Wed, 7 Apr 2004 14:27:32 -0600 (MDT) Date: Wed, 7 Apr 2004 14:27:29 -0600 (MDT) From: "scott.marlowe" To: Nid Cc: Subject: Re: Postgresql educational sources In-Reply-To: <00dd01c41cd3$ed6e1bf0$0201a8c0@game> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-IHS-MailScanner-Envelope-Sender: scott.marlowe@ihs.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/90 X-Sequence-Number: 6390 On Wed, 7 Apr 2004, Nid wrote: > Rather than ask some general, unanswerable question on how to tune my > database...I thought I ask where I might find an introduction to...or > manual/tutorial for the depths of managing a postgres db. Books? > Websites? Assume a basic to intermediate knowledge of DBs in general > with a desire to learn about postgres from the ground up. If it makes a > difference I'm using a postgres db in a Red Hat Linux OS environment. > Thanks! The online (adminstration) docs are quite good, and for tuning, look at the excellent tuning document on varlena: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html From xzilla@users.sourceforge.net Thu Apr 8 15:06:34 2004 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5AF22D1D07E for ; Thu, 8 Apr 2004 12:06:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67575-09 for ; Thu, 8 Apr 2004 12:06:30 -0300 (ADT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 75554D1CCBF for ; Thu, 8 Apr 2004 12:06:29 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i38F7acM023307; Thu, 8 Apr 2004 11:07:37 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i38F6Cl09664; Thu, 8 Apr 2004 11:06:13 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id FVMA763Q; Thu, 8 Apr 2004 11:06:10 -0400 Subject: Re: Postgresql educational sources From: Robert Treat To: "scott.marlowe" Cc: Nid , pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 08 Apr 2004 11:06:11 -0400 Message-Id: <1081436772.2470.55.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/112 X-Sequence-Number: 6412 On Wed, 2004-04-07 at 16:27, scott.marlowe wrote: > On Wed, 7 Apr 2004, Nid wrote: > > > Rather than ask some general, unanswerable question on how to tune my > > database...I thought I ask where I might find an introduction to...or > > manual/tutorial for the depths of managing a postgres db. Books? > > Websites? Assume a basic to intermediate knowledge of DBs in general > > with a desire to learn about postgres from the ground up. If it makes a > > difference I'm using a postgres db in a Red Hat Linux OS environment. > > Thanks! > > The online (adminstration) docs are quite good, and for tuning, look at > the excellent tuning document on varlena: > > http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html > Actually I might rather suggest looking at http://techdocs.postgresql.org/ which has a slew of links/articles/tutorials regarding development and administration of postgresql databases (including a link to Scott's aforementioned doc) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL