Skip site navigation (1) Skip section navigation (2)

Re: DBA tasks

From: Thomas SMETS <tsmets(at)gmail(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: DBA tasks
Date: 2006-07-26 21:44:46
Message-ID: 44C7E24E.7080406@brutele.be (view raw or flat)
Thread:
Lists: pgsql-admin

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(at)yahoo(dot)com


Attachment: tsmets.vcf
Description: text/x-vcard (165 bytes)

In response to

pgsql-admin by date

Next:From: Michael FuhrDate: 2006-07-26 23:13:16
Subject: Re: create table problems
Previous:From: Chris HooverDate: 2006-07-26 20:51:34
Subject: create table problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group