From jd@commandprompt.com Fri Jul 14 00:58:20 2006 X-Original-To: pgsql-docs-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 91D549FB2DB; Thu, 13 Jul 2006 21:58:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 94054-03; Thu, 13 Jul 2006 21:58:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 926949FB2D5; Thu, 13 Jul 2006 21:58:10 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.6/8.13.6) with ESMTP id k6E0wJRf025186; Thu, 13 Jul 2006 17:58:19 -0700 Message-ID: <44B6EC25.7000708@commandprompt.com> Date: Thu, 13 Jul 2006 17:58:13 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.4 (X11/20060615) MIME-Version: 1.0 To: pgsql-docs@postgresql.org, PostgreSQL-patches Subject: maintenance diff Content-Type: multipart/mixed; boundary="------------080000060402080308000101" X-Virus-Scanned: ClamAV version 0.88.2, clamav-milter version 0.88.2 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Thu, 13 Jul 2006 17:58:20 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/2 X-Sequence-Number: 3592 This is a multi-part message in MIME format. --------------080000060402080308000101 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello, Updated to have stronger wording for vacuuming. Cleaned out some extra superlatives. Added a couple of index entries for Routine Maintenance and added entry specific to Analyze. -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ --------------080000060402080308000101 Content-Type: text/plain; name="maintenance.diff" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="maintenance.diff" ? external_projects.diff ? maintenance.diff Index: external-projects.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/external-projects.sgml,v retrieving revision 1.10 diff -r1.10 external-projects.sgml 4c4 < External Projects --- > PgFoundry and External Projects 10,17c10,20 < efficiently developed separately from the core project. Separate < projects can < have their own developer teams, email lists, bug tracking, < and release schedules. While their independence makes < development easier, it makes users' jobs harder. They have to hunt < around looking for database enhancements to meet their needs. < This section describes some of the more popular externally < developed enhancements and guides you on how to find them. --- > efficiently developed separately from the core project. To help our > community with the development process of their external projects > we have created PgFoundry. > > > > Pgfoundry utlizes the Gforg > software and is similar to SourceForge in its feature set. If you have an > Open Source project that you would like to develop and need project mangement > resources including, mailing lists, forums and cvs please feel free to create > a new project. 21,26c24,29 < Many PostgreSQL-related projects are < hosted at either < GBorg < or pgFoundry. < There are other PostgreSQL-related projects that are hosted < elsewhere, but you will have to do an Internet search to find them. --- > Secondly, many PostgreSQL-related projects are > hosted at either pgFoundry > or GBorg (although > Gbord is considered deprecated). There are other PostgreSQL > noteable related projects that are hosted elsewhere. However, you will also want to > do an Internet search to find others. 55c58 < applications. --- > applications. Website. 61c64 < pgjdbc --- > ODBCng 64c67,68 < A JDBC interface. --- > Another ODBC driver for PostgreSQL. > Website. 70,80c74 < Npgsql < < < .Net interface for more recent < Windows applications. < < < < < < libpqxx --- > pgjdbc 83c77,78 < A newer C++ interface. --- > A JDBC interface. > Website. 89c84 < libpq++ --- > Npgsql 92c87,89 < An older C++ interface. --- > .Net interface for more recent > mono/C# applications. > Website. 98c95 < pgperl --- > libpqxx 101,102c98,99 < A Perl interface with an API similar < to libpq. --- > A newer C++ interface. > Website. 108c105 < DBD-Pg --- > DBD::Pg 111,112c108,109 < A Perl interface that uses the < DBD-standard API. --- > A Perl DBI driver for PostgreSQL. > Website. 121a119 > Website. 127c125 < pgtcl --- > Pyscopg 130c128 < The original version of the Tcl interface. --- > A Python interface librar that is DB API 2.0 compliant. 134,143d131 < < < PyGreSQL < < < A Python interface library. < < < < 145,148d132 < < All of these can be found at < GBorg < or pgFoundry. Index: maintenance.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/maintenance.sgml,v retrieving revision 1.56 diff -r1.56 maintenance.sgml 9a10,13 > > Routine maintenance > > 11,17c15,19 < There are a few routine maintenance chores that must be performed on < a regular basis to keep a PostgreSQL < server running smoothly. The tasks discussed here are repetitive < in nature and can easily be automated using standard Unix tools such < as cron scripts. But it is the database < administrator's responsibility to set up appropriate scripts, and to < check that they execute successfully. --- > PostgreSQL, like any database software requires that tasks > be performed on a regular basis to achieve optimum performance. > The tasks discussed here are required but they > are repetitive in nature and can easily be automated using standard > Unix tools such as cron scripts. 30,32c32,36 < The other main category of maintenance task is periodic vacuuming < of the database. This activity is discussed in < . --- > The are two tasks that must be performed on > a periodic basis. The first is vacuuming. This activity is discussed in > . The sceond is to update the planner > statistics using the analyze command as discussed in > . 42,44c46,48 < to some other database management systems. Nonetheless, < appropriate attention to these tasks will go far towards ensuring a < pleasant and productive experience with the system. --- > to other database management systems. It is also fairly easy, provided > you read the documentation to keep a relatively hands off maintenance > regimen. 56c60 < must be run on a regular basis for several reasons: --- > must be run on a regular basis for several reasons: 60c64 < To recover disk space occupied by updated or deleted --- > To recover or reuse disk space occupied by updated or deleted 85,89c89,94 < The standard form of VACUUM can run in parallel with < normal database operations (SELECTs, INSERTs, UPDATEs, DELETEs, but not < changes to table definitions). < Beginning in PostgreSQL 8.0, there are < configuration parameters that can be adjusted to further reduce the --- > The standard form of VACUUM does not intefere with production > database operations. Items such as SELECTS, INSERTS, UPDATES and DELETES > will continue to function as normal. You will not be able to modify the > definition (Such as ALTER TABLE ADD COLUMN) of a table. > The release of PostgreSQL 8.0, introduced new > configuration parameters to further reduce the potentially negative --------------080000060402080308000101-- From peter_e@gmx.net Fri Jul 14 07:49:34 2006 X-Original-To: pgsql-patches-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E5AC89FB2E0 for ; Fri, 14 Jul 2006 04:49:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 47904-05 for ; Fri, 14 Jul 2006 04:49:30 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.21]) by postgresql.org (Postfix) with SMTP id C7A989FB2A9 for ; Fri, 14 Jul 2006 04:49:30 -0300 (ADT) Received: (qmail invoked by alias); 14 Jul 2006 07:49:28 -0000 Received: from dslb-084-063-113-055.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.113.55] by mail.gmx.net (mp020) with SMTP; 14 Jul 2006 09:49:28 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: "Joshua D. Drake" Subject: Re: [DOCS] maintenance diff Date: Fri, 14 Jul 2006 09:49:27 +0200 User-Agent: KMail/1.9.1 Cc: PostgreSQL-patches References: <44B6EC25.7000708@commandprompt.com> In-Reply-To: <44B6EC25.7000708@commandprompt.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607140949.27702.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/90 X-Sequence-Number: 20244 Joshua D. Drake wrote: > Updated to have stronger wording for vacuuming. Cleaned out some > extra superlatives. Added a couple of index entries for Routine > Maintenance and added entry specific to Analyze. diff -c please. -- Peter Eisentraut http://developer.postgresql.org/~petere/ From xzilla@users.sourceforge.net Fri Jul 14 11:57:45 2006 X-Original-To: pgsql-docs-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1196B9FB352; Fri, 14 Jul 2006 08:57:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 79497-10; Fri, 14 Jul 2006 08:57:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from eastrmmtao06.cox.net (eastrmmtao06.cox.net [68.230.240.33]) by postgresql.org (Postfix) with ESMTP id 6C92C9FB35B; Fri, 14 Jul 2006 08:57:38 -0300 (ADT) Received: from [192.168.0.9] (really [24.250.222.197]) by eastrmmtao06.cox.net (InterMail vM.6.01.06.01 201-2131-130-101-20060113) with ESMTP id <20060714115731.PLKA16402.eastrmmtao06.cox.net@[192.168.0.9]>; Fri, 14 Jul 2006 07:57:31 -0400 From: Robert Treat To: pgsql-docs@postgresql.org Subject: Re: maintenance diff Date: Fri, 14 Jul 2006 07:57:30 -0400 User-Agent: KMail/1.9.1 Cc: "Joshua D. Drake" , PostgreSQL-patches References: <44B6EC25.7000708@commandprompt.com> In-Reply-To: <44B6EC25.7000708@commandprompt.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607140757.31021.xzilla@users.sourceforge.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/3 X-Sequence-Number: 3593 On Thursday 13 July 2006 20:58, Joshua D. Drake wrote: > Hello, > > Updated to have stronger wording for vacuuming. Cleaned out some extra > superlatives. Added a couple of index entries for Routine Maintenance > and added entry specific to Analyze. I noticed a number of typos in this... s/Gbord/Gborg/ s/Gforg/Gforge/ s/including, mailing/including mailing s/forums and cvs/forums, and cvs,/ s/pgFoundry/PgFoundry/ I think there might be some other issues too... like saying gborg is deprecated is likely to imply something wrong with the projects there rather than the site itself. There were a couple of other minor things I noticed too... Joshua, do you mind if I make some changes and resubmit this patch? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL From jd@commandprompt.com Fri Jul 14 15:18:52 2006 X-Original-To: pgsql-patches-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B67EB9FB35B for ; Fri, 14 Jul 2006 12:18:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 30936-04 for ; Fri, 14 Jul 2006 12:18:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 442BE9FB334 for ; Fri, 14 Jul 2006 12:18:42 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.6/8.13.6) with ESMTP id k6EFIefd008722; Fri, 14 Jul 2006 08:18:41 -0700 Message-ID: <44B7B5D4.8040006@commandprompt.com> Date: Fri, 14 Jul 2006 08:18:44 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.4 (X11/20060615) MIME-Version: 1.0 To: Peter Eisentraut CC: PostgreSQL-patches Subject: Re: [DOCS] maintenance diff References: <44B6EC25.7000708@commandprompt.com> <200607140949.27702.peter_e@gmx.net> In-Reply-To: <200607140949.27702.peter_e@gmx.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.2, clamav-milter version 0.88.2 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Fri, 14 Jul 2006 08:18:41 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/94 X-Sequence-Number: 20248 Peter Eisentraut wrote: > Joshua D. Drake wrote: >> Updated to have stronger wording for vacuuming. Cleaned out some >> extra superlatives. Added a couple of index entries for Routine >> Maintenance and added entry specific to Analyze. > > diff -c please. > I have been properly chastised by Neil too. I will have if or you today :) Sorry about that. Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ From jd@commandprompt.com Fri Jul 14 15:20:12 2006 X-Original-To: pgsql-docs-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 38D899FB35B; Fri, 14 Jul 2006 12:20:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 32718-02; Fri, 14 Jul 2006 12:20:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id F37229FB334; Fri, 14 Jul 2006 12:20:01 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.6/8.13.6) with ESMTP id k6EFJrX0008749; Fri, 14 Jul 2006 08:20:02 -0700 Message-ID: <44B7B61D.6010806@commandprompt.com> Date: Fri, 14 Jul 2006 08:19:57 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.4 (X11/20060615) MIME-Version: 1.0 To: Robert Treat CC: pgsql-docs@postgresql.org, PostgreSQL-patches Subject: Re: maintenance diff References: <44B6EC25.7000708@commandprompt.com> <200607140757.31021.xzilla@users.sourceforge.net> In-Reply-To: <200607140757.31021.xzilla@users.sourceforge.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.2, clamav-milter version 0.88.2 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Fri, 14 Jul 2006 08:20:03 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/4 X-Sequence-Number: 3594 Robert Treat wrote: > On Thursday 13 July 2006 20:58, Joshua D. Drake wrote: >> Hello, >> >> Updated to have stronger wording for vacuuming. Cleaned out some extra >> superlatives. Added a couple of index entries for Routine Maintenance >> and added entry specific to Analyze. > > I noticed a number of typos in this... > > s/Gbord/Gborg/ > s/Gforg/Gforge/ (I am not surprised I did that) > s/including, mailing/including mailing > s/forums and cvs/forums, and cvs,/ > s/pgFoundry/PgFoundry/ > > I think there might be some other issues too... like saying gborg is > deprecated is likely to imply something wrong with the projects there rather > than the site itself. I can extend that... The Gborg site is deprecated and all current projects are moving to Gforge. > > There were a couple of other minor things I noticed too... Joshua, do you mind > if I make some changes and resubmit this patch? Let me go back through it first please. Joshua D. Drake > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/