Re: DBA tasks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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

begin:vcard
fn:Thomas SMETS
n:SMETS;Thomas
email;internet:duvelbier-tsmets@xxxxxxxxx
tel;home:+32 (0)2 742 05 94
tel;cell:+32 (0)497 44 68 12
version:2.1
end:vcard


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux