Обсуждение: maintenance diff
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
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
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/
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>
"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
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/
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
Вложения
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --------------------------------------------------------------------------- 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. +
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. +