pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas SMETS <tsmets@gmail.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: DBA tasks
Date: Wed, 26 Jul 2006 23:44:46 +0200
Message-ID: <44C7E24E.7080406@brutele.be> (raw)
In-Reply-To: <20060724010008.GA20562@winnie.fuhr.org>
References: <C0837C9B-0A5C-4BCE-B8F0-0E9421E604FA@object-craft.com.au>
	<20060724010008.GA20562@winnie.fuhr.org>



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

Attachments:

tsmets.vcf (text/x-vcard, 163B) download 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

view thread (4+ messages)

Message-ID: <44C7E24E.7080406@brutele.be>
Permalink:  ../44C7E24E.7080406@brutele.be/
Also on:    postgresql.org/message-id/44C7E24E.7080406@brutele.be

 · 

reply

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-admin@postgresql.org
  Cc: tsmets@gmail.com, mike@fuhr.org
  Subject: Re: DBA tasks
  In-Reply-To: <44C7E24E.7080406@brutele.be>
  References: <C0837C9B-0A5C-4BCE-B8F0-0E9421E604FA@object-craft.com.au> <20060724010008.GA20562@winnie.fuhr.org> <44C7E24E.7080406@brutele.be>

* 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