Re: improve routine vacuuming docs

From: Neil Conway <neilc(at)samurai(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: improve routine vacuuming docs
Date: 2003-12-12 21:53:18
Message-ID: 87ptetpusx.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> It's kind of hard to see what you have really changed. Can you
> provide a summary?

The majority of the changes are in the 3rd patch hunk; ISTM it is
pretty easy to see what has been changed. I spent more time discussing
the differences between VACUUM and VACUUM FULL, added a note that some
update-intensive sites VACUUM as frequently as every five minutes, and
so on.

> You should <command>VACUUM</command> your database every day.
>
> Instead, either write
>
> You should vacuum your database every day.

Well, my reasoning was that the phrase "VACUUM", particularly when
typeset as a command, has an exact technical meaning within the
context of PostgreSQL. It is derived from the English word "vacuum",
but our usage of the term differs significantly from any definition
you'd find in a normal dictionary. For example, I don't think this is
optimal:

The presence of a for update trigger on the table [...]

(To invent a random example) I think this is clearer:

The presence of a <literal>FOR UPDATE</literal> trigger on the
table [...]

Here, the PG-specific term is differently typeset and capitalized.

However, I Am Not A Technical Writer, so I may be completely
wrong. BTW, can anyone recommend a good book on technical writing in
English?

-Neil

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2003-12-12 21:57:24 Re: make "wal_debug" GUC var a boolean
Previous Message Tom Lane 2003-12-12 21:50:52 Re: make "wal_debug" GUC var a boolean