Thread: maintenance diff

maintenance diff

From
"Joshua D. Drake"
Date:
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/


? 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
<   <title>External Projects</title>
---
>   <title>PgFoundry and External Projects</title>
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 <ulink url="http://www.pgfoundry.org/">PgFoundry</ulink>.
>   </para>
>
>   <para>
>    <ulink url="http://www.pgfoundry.org/">Pgfoundry</ulink> 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 <productname>PostgreSQL</productname>-related projects are
<    hosted at either
<    <ulink url="http://gborg.postgresql.org"><productname>GBorg</></ulink>
<    or <ulink url="http://pgfoundry.org"><productname>pgFoundry</></ulink>.
<    There are other <productname>PostgreSQL</productname>-related projects that are hosted
<    elsewhere, but you will have to do an Internet search to find them.
---
>    Secondly, many <productname>PostgreSQL</productname>-related projects are
>    hosted at either <ulink url="http://pgfoundry.org"><productname>pgFoundry</></ulink>
>    or <ulink url="http://gborg.postgresql.org"><productname>GBorg</></ulink> (although
>    Gbord is considered deprecated). There are other <productname>PostgreSQL</productname>
>    noteable related projects that are hosted elsewhere. However, you will also want to
>    do an Internet search to find others.
55c58
<        applications.
---
>        applications. <ulink url="http://odbc.postgresql.org/">Website.</ulink>
61c64
<      <term>pgjdbc</term>
---
>      <term>ODBCng</term>
64c67,68
<        A <application>JDBC</> interface.
---
>        Another ODBC driver for PostgreSQL.
>        <ulink url="http://projects.commandprompt.com/public/odbcng/">Website.</ulink>
70,80c74
<      <term>Npgsql</term>
<      <listitem>
<       <para>
<        <application>.Net</> interface for more recent
<        <application>Windows</> applications.
<       </para>
<      </listitem>
<     </varlistentry>
<
<     <varlistentry>
<      <term>libpqxx</term>
---
>      <term>pgjdbc</term>
83c77,78
<        A newer <application>C++</> interface.
---
>        A <application>JDBC</> interface.
>        <ulink url="http://jdbc.postgresql.org/">Website.</ulink>
89c84
<      <term>libpq++</term>
---
>      <term>Npgsql</term>
92c87,89
<        An older <application>C++</> interface.
---
>        <application>.Net</> interface for more recent
>        <application>mono/C#</> applications.
>        <ulink url="http://pgfoundry.org/projects/npgsql/">Website.</ulink>
98c95
<      <term>pgperl</term>
---
>      <term>libpqxx</term>
101,102c98,99
<        A <application>Perl</> interface with an <acronym>API</> similar
<        to <application>libpq</>.
---
>        A newer <application>C++</> interface.
>        <ulink url="http://thaiopensource.org/development/libpqxx/">Website.</ulink>
108c105
<      <term>DBD-Pg</term>
---
>      <term>DBD::Pg</term>
111,112c108,109
<        A <application>Perl</> interface that uses the
<        <acronym>DBD</>-standard <application>API</>.
---
>        A <application>Perl</> DBI driver for PostgreSQL.
>        <ulink url="http://search.cpan.org/dist/DBD-Pg/">Website.</ulink>
121a119
>        <ulink url="http://gborg.postgresql.org/project/pgtclng/projdisplay.php">Website.</ulink>
127c125
<      <term>pgtcl</term>
---
>      <term>Pyscopg</term>
130c128
<        The original version of the <application>Tcl</> interface.
---
>        A <application>Python</> interface librar that is DB API 2.0 compliant.
134,143d131
<
<     <varlistentry>
<      <term>PyGreSQL</term>
<      <listitem>
<       <para>
<        A <application>Python</> interface library.
<       </para>
<      </listitem>
<     </varlistentry>
<
145,148d132
<
<    All of these can be found at
<    <ulink url="http://gborg.postgresql.org"><productname>GBorg</></ulink>
<    or <ulink url="http://pgfoundry.org"><productname>pgFoundry</></ulink>.
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
>  <indexterm zone="maintenance">
>   <primary>Routine maintenance</primary>
>  </indexterm>
>
11,17c15,19
<    There are a few routine maintenance chores that must be performed on
<    a regular basis to keep a <productname>PostgreSQL</productname>
<    server running smoothly.  The tasks discussed here are repetitive
<    in nature and can easily be automated using standard Unix tools such
<    as <application>cron</application> 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 <emphasis>required</emphasis> but they
>    are repetitive in nature and can easily be automated using standard
>    Unix tools such as <application>cron</application> scripts.
30,32c32,36
<    The other main category of maintenance task is periodic <quote>vacuuming</>
<    of the database.  This activity is discussed in
<    <xref linkend="routine-vacuuming">.
---
>    The are two tasks that <emphasis>must</emphasis> be performed on
>    a periodic basis. The first is vacuuming. This activity is discussed in
>    <xref linkend="routine-vacuuming">. The sceond is to update the planner
>    statistics using the analyze command as discussed in
>    <xref linkend="vacuum-for-statistics">.
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:
---
>    <emphasis>must</emphasis> be run on a regular basis for several reasons:
60c64
<       <simpara>To recover disk space occupied by updated or deleted
---
>       <simpara>To recover or reuse disk space occupied by updated or deleted
85,89c89,94
<    The standard form of <command>VACUUM</> can run in parallel with
<    normal database operations (SELECTs, INSERTs, UPDATEs, DELETEs, but not
<    changes to table definitions).
<    Beginning in <productname>PostgreSQL</productname> 8.0, there are
<    configuration parameters that can be adjusted to further reduce the
---
>    The standard form of <command>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 <productname>PostgreSQL</productname> 8.0, introduced new
>    configuration parameters to further reduce the potentially negative

Re: [DOCS] maintenance diff

From
Peter Eisentraut
Date:
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/

Re: [DOCS] maintenance diff

From
Robert Treat
Date:
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

Re: [DOCS] maintenance diff

From
"Joshua D. Drake"
Date:
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/



Re: [DOCS] maintenance diff

From
"Joshua D. Drake"
Date:
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/



Maintenance and External Projects (try 2)

From
"Joshua D. Drake"
Date:
Hello,

I did further work on both of these. Cleaned up some stupid spelling and
typos (forgot an s here, a y there ;)).

The commit log doesn't change from previous except that I added a
reference to Sourceforge for external projects, and I specified that
there are three required routing maintenance tasks.

Please let me know if there is anything else you would like me to do or add.

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/


*** external-projects.sgml    2006-07-14 09:35:39.820149250 -0700
--- external-projects.sgml.diff    2006-07-14 09:33:42.864840000 -0700
***************
*** 1,29 ****
  <!-- $PostgreSQL: pgsql/doc/src/sgml/external-projects.sgml,v 1.10 2006/03/10 19:10:47 momjian Exp $ -->

   <appendix id="external-projects">
!   <title>External Projects</title>

    <para>
     <productname>PostgreSQL</productname> is a complex software project,
     and managing it is difficult. We have found that many
     enhancements to <productname>PostgreSQL</productname> can be more
!    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.
    </para>

    <para>
!    Many <productname>PostgreSQL</productname>-related projects are
!    hosted at either
!    <ulink url="http://gborg.postgresql.org"><productname>GBorg</></ulink>
!    or <ulink url="http://pgfoundry.org"><productname>pgFoundry</></ulink>.
!    There are other <productname>PostgreSQL</productname>-related projects that are hosted
!    elsewhere, but you will have to do an Internet search to find them.
    </para>

   <sect1 id="external-interfaces">
--- 1,34 ----
  <!-- $PostgreSQL: pgsql/doc/src/sgml/external-projects.sgml,v 1.10 2006/03/10 19:10:47 momjian Exp $ -->

   <appendix id="external-projects">
!   <title>PgFoundry and External Projects</title>

    <para>
     <productname>PostgreSQL</productname> is a complex software project,
     and managing it is difficult. We have found that many
     enhancements to <productname>PostgreSQL</productname> can be more
!    efficiently developed separately from the core project.
!   </para>
!
!   <para>
!    To help our community with the development of their external projects
!    we have created <ulink url="http://www.pgfoundry.org/">PgFoundry</ulink>.
!    <ulink url="http://www.pgfoundry.org/">Pgfoundry</ulink> utlizes the Gforge
!    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 management
!    resources such as mailing lists, forums and cvs please feel free to create
!    a new project.
    </para>

    <para>
!    Secondly, many <productname>PostgreSQL</productname>-related projects are
!    still hosted at <ulink url="http://gborg.postgresql.org"><productname>GBorg</></ulink>.
!    Gborg is the original external community developer site. It is currently deprecated
!    in favor of PgFoundry but still contains many active and relevant projects. There
!    are other popular <productname>PostgreSQL</productname> related projects that are
!    hosted independently as well as at other community sites such as
!    <ulink url="http://www.sf.net">SourceForge</ulink>. You should you google if you
!    don't find the project you are looking for.
    </para>

   <sect1 id="external-interfaces">
***************
*** 36,46 ****
    <para>
     <productname>PostgreSQL</productname> includes very few interfaces
     with the base distribution. <application>libpq</> is packaged because
!    it is the primary <application>C</> interface and many other
!    interfaces are built on top of it. <application>ecpg</> is packaged
!    because it is tied to the server-side grammar so is very dependent
!    on the database version. All the other interfaces are independent
!    projects and must be installed separately.
    </para>

    <para>
--- 41,50 ----
    <para>
     <productname>PostgreSQL</productname> includes very few interfaces
     with the base distribution. <application>libpq</> is packaged because
!    it is the primary dependecy of most interfaces available to PostgreSQL.
!    We also package <application>ecpg</> is because it is tied to the
!    server-side grammar. All other interfaces, such as PHP, Perl, Python,
!    and Ruby are external projects.
    </para>

    <para>
***************
*** 52,115 ****
       <listitem>
        <para>
         This is the most common interface for <application>Windows</>
!        applications.
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>pgjdbc</term>
       <listitem>
        <para>
!        A <application>JDBC</> interface.
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>Npgsql</term>
!      <listitem>
!       <para>
!        <application>.Net</> interface for more recent
!        <application>Windows</> applications.
!       </para>
!      </listitem>
!     </varlistentry>
!
!     <varlistentry>
!      <term>libpqxx</term>
       <listitem>
        <para>
!        A newer <application>C++</> interface.
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>libpq++</term>
       <listitem>
        <para>
!        An older <application>C++</> interface.
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>pgperl</term>
       <listitem>
        <para>
!        A <application>Perl</> interface with an <acronym>API</> similar
!        to <application>libpq</>.
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>DBD-Pg</term>
       <listitem>
        <para>
!        A <application>Perl</> interface that uses the
!        <acronym>DBD</>-standard <application>API</>.
        </para>
       </listitem>
      </varlistentry>
--- 56,113 ----
       <listitem>
        <para>
         This is the most common interface for <application>Windows</>
!        applications. <ulink url="http://odbc.postgresql.org/">Website.</ulink>
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>ODBCng</term>
       <listitem>
        <para>
!        Another ODBC driver for PostgreSQL.
!        <ulink url="http://projects.commandprompt.com/public/odbcng/">Website.</ulink>
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>pgjdbc</term>
       <listitem>
        <para>
!        A <application>JDBC</> interface.
!        <ulink url="http://jdbc.postgresql.org/">Website.</ulink>
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>Npgsql</term>
       <listitem>
        <para>
!        <application>.Net</> interface for more recent
!        <application>mono/C#</> applications.
!        <ulink url="http://pgfoundry.org/projects/npgsql/">Website.</ulink>
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>libpqxx</term>
       <listitem>
        <para>
!        A newer <application>C++</> interface.
!        <ulink url="http://thaiopensource.org/development/libpqxx/">Website.</ulink>
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>DBD::Pg</term>
       <listitem>
        <para>
!        A <application>Perl</> DBI driver for PostgreSQL.
!        <ulink url="http://search.cpan.org/dist/DBD-Pg/">Website.</ulink>
        </para>
       </listitem>
      </varlistentry>
***************
*** 119,151 ****
       <listitem>
        <para>
         A newer version of the <application>Tcl</> interface.
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>pgtcl</term>
       <listitem>
        <para>
!        The original version of the <application>Tcl</> interface.
        </para>
       </listitem>
      </varlistentry>
-
-     <varlistentry>
-      <term>PyGreSQL</term>
-      <listitem>
-       <para>
-        A <application>Python</> interface library.
-       </para>
-      </listitem>
-     </varlistentry>
-
     </variablelist>
-
-    All of these can be found at
-    <ulink url="http://gborg.postgresql.org"><productname>GBorg</></ulink>
-    or <ulink url="http://pgfoundry.org"><productname>pgFoundry</></ulink>.
     </para>

   </sect1>
--- 117,137 ----
       <listitem>
        <para>
         A newer version of the <application>Tcl</> interface.
+        <ulink url="http://gborg.postgresql.org/project/pgtclng/projdisplay.php">Website.</ulink>
        </para>
       </listitem>
      </varlistentry>

      <varlistentry>
!      <term>Pyscopg</term>
       <listitem>
        <para>
!        A <application>Python</> interface library that is DB API 2.0 compliant.
!        <ulink url="http://www.initd.org/">Website.</ulink>
        </para>
       </listitem>
      </varlistentry>
     </variablelist>
     </para>

   </sect1>
***************
*** 175,181 ****
    <para>
     There are several administration tools available for
     <productname>PostgreSQL</>. The most popular is
!    <application>pgAdmin</>, and there are several commercially
     available ones.
    </para>

--- 161,167 ----
    <para>
     There are several administration tools available for
     <productname>PostgreSQL</>. The most popular is
!    <application><ulink url="http://www.pgadmin.org/">pgAdmin</ulink></>, and there are several commercially
     available ones.
    </para>

*** maintenance.sgml    2006-07-14 09:35:40.180171750 -0700
--- maintenance.diff    2006-07-14 10:06:13.642756000 -0700
***************
*** 7,48 ****
    <primary>maintenance</primary>
   </indexterm>

    <para>
!    There are a few routine maintenance chores that must be performed on
!    a regular basis to keep a <productname>PostgreSQL</productname>
!    server running smoothly.  The tasks discussed here are repetitive
!    in nature and can easily be automated using standard Unix tools such
!    as <application>cron</application> scripts.  But it is the database
!    administrator's responsibility to set up appropriate scripts, and to
!    check that they execute successfully.
    </para>
!
    <para>
!    One obvious maintenance task is creation of backup copies of the data on a
!    regular schedule.  Without a recent backup, you have no chance of recovery
!    after a catastrophe (disk failure, fire, mistakenly dropping a critical
!    table, etc.).  The backup and recovery mechanisms available in
!    <productname>PostgreSQL</productname> are discussed at length in
!    <xref linkend="backup">.
    </para>

    <para>
!    The other main category of maintenance task is periodic <quote>vacuuming</>
!    of the database.  This activity is discussed in
!    <xref linkend="routine-vacuuming">.
    </para>

    <para>
!    Something else that might need periodic attention is log file management.
     This is discussed in <xref linkend="logfile-maintenance">.
    </para>

!   <para>
!    <productname>PostgreSQL</productname> is low-maintenance compared
!    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.
!   </para>

   <sect1 id="routine-vacuuming">
    <title>Routine Vacuuming</title>
--- 7,46 ----
    <primary>maintenance</primary>
   </indexterm>

+  <indexterm zone="maintenance">
+   <primary>Routine maintenance</primary>
+  </indexterm>
+
    <para>
!    PostgreSQL, like any database software requires that certain tasks
!    be performed regularly to achieve optimum performance. The tasks
!    discussed here are <emphasis>required</emphasis> but they
!    are repetitive in nature and can easily be automated using standard
!    Unix tools such as <application>cron</application> scripts.
    </para>
!
    <para>
!    <productname>PostgreSQL</productname> is low-maintenance compared
!    to other database management systems. It is also fairly easy, provided
!    you read the documentation.
    </para>

    <para>
!    There are three tasks that <emphasis>must</emphasis> be performed on
!    a periodic basis. The first is backups. If you do not have a current backup
!    and your system experiences a catostrophic failure, you will loose your data.
!    You can read further about backups procedures in <xref linked="backup">.
!    The second is vacuum which is discussed in <xref linkend="routine-vacuuming">.
!    The third is to update the planner statistics using the analyze command as
!    discussed in <xref linkend="vacuum-for-statistics">.
    </para>

    <para>
!    Another task that may need periodic attention is log file management.
     This is discussed in <xref linkend="logfile-maintenance">.
    </para>

!

   <sect1 id="routine-vacuuming">
    <title>Routine Vacuuming</title>
***************
*** 53,63 ****

    <para>
     <productname>PostgreSQL</productname>'s <command>VACUUM</> command
!    must be run on a regular basis for several reasons:

      <orderedlist>
       <listitem>
!       <simpara>To recover disk space occupied by updated or deleted
        rows.</simpara>
       </listitem>

--- 51,61 ----

    <para>
     <productname>PostgreSQL</productname>'s <command>VACUUM</> command
!    <emphasis>must</emphasis> be run on a regular basis for several reasons:

      <orderedlist>
       <listitem>
!       <simpara>To recover or reuse disk space occupied by updated or deleted
        rows.</simpara>
       </listitem>

***************
*** 82,92 ****
    </para>

    <para>
!    The standard form of <command>VACUUM</> can run in parallel with
!    normal database operations (SELECTs, INSERTs, UPDATEs, DELETEs, but not
!    changes to table definitions).
!    Beginning in <productname>PostgreSQL</productname> 8.0, there are
!    configuration parameters that can be adjusted to further reduce the
     performance impact of background vacuuming.  See
     <xref linkend="runtime-config-resource-vacuum-cost">.
    </para>
--- 80,91 ----
    </para>

    <para>
!    The standard form of <command>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 <productname>PostgreSQL</productname> 8.0, introduced new
!    configuration parameters to further reduce the potentially negative
     performance impact of background vacuuming.  See
     <xref linkend="runtime-config-resource-vacuum-cost">.
    </para>

Re: [DOCS] Maintenance and External Projects (try 2)

From
Tom Lane
Date:
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Please let me know if there is anything else you would like me to do or add.

A round of copy-editing seems indicated, at least.

            regards, tom lane

Re: [DOCS] Maintenance and External Projects (try 2)

From
"Joshua D. Drake"
Date:
Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
>> Please let me know if there is anything else you would like me to do or add.
>
> A round of copy-editing seems indicated, at least.

Oh, no doubt. I tried to fix as much as I find, including a bunch of
stuff already there. However, I do not claim, in any way to be an editor.

Sincerely,

Joshua D. Drake

>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


--

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



Re: [DOCS] Maintenance and External Projects (try 2)

From
Robert Treat
Date:
On Friday 14 July 2006 15:23, Joshua D. Drake wrote:
> Tom Lane wrote:
> > "Joshua D. Drake" <jd@commandprompt.com> writes:
> >> Please let me know if there is anything else you would like me to do or
> >> add.
> >
> > A round of copy-editing seems indicated, at least.
>
> Oh, no doubt. I tried to fix as much as I find, including a bunch of
> stuff already there. However, I do not claim, in any way to be an editor.
>

The following patches provide some editorializing for Joshua's patches.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Attachment

Re: [DOCS] Maintenance and External Projects (try 2)

From
Bruce Momjian
Date:
Patch applied.  Thanks.

---------------------------------------------------------------------------


Robert Treat wrote:
> On Friday 14 July 2006 15:23, Joshua D. Drake wrote:
> > Tom Lane wrote:
> > > "Joshua D. Drake" <jd@commandprompt.com> writes:
> > >> Please let me know if there is anything else you would like me to do or
> > >> add.
> > >
> > > A round of copy-editing seems indicated, at least.
> >
> > Oh, no doubt. I tried to fix as much as I find, including a bunch of
> > stuff already there. However, I do not claim, in any way to be an editor.
> >
>
> The following patches provide some editorializing for Joshua's patches.
>
> --
> Robert Treat
> Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

[ Attachment, skipping... ]

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +