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 @ : [EMAIL PROTECTED]
begin:vcard fn:Thomas SMETS n:SMETS;Thomas email;internet:[EMAIL PROTECTED] tel;home:+32 (0)2 742 05 94 tel;cell:+32 (0)497 44 68 12 version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
