X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9D6189FB1B7 for ; Wed, 26 Jul 2006 18:45:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 18781-01 for ; Wed, 26 Jul 2006 18:44:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 36EA09FA7BA for ; Wed, 26 Jul 2006 18:44:55 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so882077nfc for ; Wed, 26 Jul 2006 14:44:53 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:disposition-notification-to:date:user-agent:x-accept-language:mime-version:to:cc:subject:references:in-reply-to:content-type:from; b=UgLVXyFHAvBWwZlg9fBEpHNdMN4VMW4u0St59KsaJNGxC0GioMuOZvZwPQcaeYfLSmoM4ufDFzewforpHqeW1Cz1fArWzVmMCWbL7WAXqAuwrvDGFtYTsKSBlVggXAyeLA/2YP1eM4QtQhCpdyM1NIGROBzjFQ5FqYGNoLQbUCU= Received: by 10.49.41.18 with SMTP id t18mr1157964nfj; Wed, 26 Jul 2006 14:44:53 -0700 (PDT) Received: from ?192.168.2.41? ( [212.68.230.235]) by mx.gmail.com with ESMTP id a23sm1450100nfc.2006.07.26.14.44.47; Wed, 26 Jul 2006 14:44:50 -0700 (PDT) Message-ID: <44C7E24E.7080406@brutele.be> Date: Wed, 26 Jul 2006 23:44:46 +0200 User-Agent: Mozilla Thunderbird 1.0.8 (X11/20060502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Michael Fuhr CC: pgsql-admin@postgresql.org Subject: Re: DBA tasks References: <20060724010008.GA20562@winnie.fuhr.org> In-Reply-To: <20060724010008.GA20562@winnie.fuhr.org> Content-Type: multipart/mixed; boundary="------------070002020908040201050706" From: Thomas SMETS X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/232 X-Sequence-Number: 22478 This is a multi-part message in MIME format. --------------070002020908040201050706 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Fine but in the long run, we'd need something like Donald Burleson's web site / books with extended internals explainaintions, no ... ? \T, Michael Fuhr wrote: >On Mon, Jul 24, 2006 at 08:43:15AM +1000, Mark Matthews wrote: > > >>Can anyone recommend good reference text, web or other, for general >>PostgreSQL DBA tasks. >> >> > >The PostgreSQL documentation is a good place to start. See "Server >Administration," especially the chapters concerning routine maintenance, >backup and restore, and monitoring. > >http://www.postgresql.org/docs/8.1/interactive/admin.html > >(Adjust the link to match the version you're running.) > > > >>Stuff like: >>* Things to do to clean up periodically (CLUSTER, VACUUM FULL, etc) >> >> > >See above. > > > >>* How to analyse queries to optimise data retrieval (Use of EXPLAIN, >>etc) >> >> > >See "Performance Tips" in the documentation and the tuning documents >at powerpostgresql.com. You could also peruse the list archives, >especially pgsql-performance, to see how real performance problems >have been investigated and addressed. For example, search for >threads that contain the words "EXPLAIN ANALYZE". > >http://www.postgresql.org/docs/8.1/interactive/performance-tips.html >http://www.powerpostgresql.com/Docs/ >http://archives.postgresql.org/pgsql-performance/ > >The General Bits newsletter has interesting articles; see the >Archives and General Tidbits links. > >http://www.varlena.com/varlena/GeneralBits/ > > > >>We are running Debian stable (sarge) and therefore 7.4. Moving to 8.1 >>soon (hopefully) >> >> > >Before upgrading read the Release Notes for all newer versions to >see what changes you'll be getting. See also "If You Are Upgrading" >in the Installation Instructions and read the Backup and Restore >chapter, which has a "Migration Between Releases" section. > >http://www.postgresql.org/docs/8.1/interactive/release.html >http://www.postgresql.org/docs/8.1/interactive/install-upgrading.html >http://www.postgresql.org/docs/8.1/interactive/migration.html > > > -- Thomas SMETS rue J. Wytsmanstraat 62 1050 Brussels T. : +32 (0)2 742 05 94 M. : +32 (0)497 44 68 12 @ : duvelbier-tsmets@yahoo.com --------------070002020908040201050706 Content-Type: text/x-vcard; charset=utf-8; name="tsmets.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="tsmets.vcf" begin:vcard fn:Thomas SMETS n:SMETS;Thomas email;internet:duvelbier-tsmets@yahoo.com tel;home:+32 (0)2 742 05 94 tel;cell:+32 (0)497 44 68 12 version:2.1 end:vcard --------------070002020908040201050706--