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
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