Re: [HACKERS] [PATCHES] COPY with no WAL, in certain circumstances

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] [PATCHES] COPY with no WAL, in certain circumstances
Date: 2007-01-10 18:15:47
Message-ID: 20070110181547.GI12217@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Sat, Jan 06, 2007 at 09:20:53PM -0500, Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Simon Riggs wrote:
> >> Reason for no documentation was that CREATE INDEX and CREATE TABLE AS
> >> SELECT already use this optimisation, but to my knowledge neither was/is
> >> documented on those command pages.
>
> > I wasn't aware those used the optimization. Seems they all should be
> > documented somewhere.
>
> We don't document every single optimization in the system ... if we did,
> the docs would be as big as the source code and equally unreadable by
> non-programmers. I think it's a much better idea just to mention it one
> place and not try to enumerate exactly which commands have the optimization.

I think it would be reasonable to refer to the 'tuning page' from the
appropriate pages in the documentation... I'm thinking of something
similar to the "SEE ALSO" section of man pages.

The big complain that I have (and have heard) about the docs is that
it's very hard to find something unless you know exactly what it is
you're looking for. If you don't know that there are performance
shortcuts associated with CREATE INDEX you're unlikely to find out about
them.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-01-10 18:16:23 Re: [PATCHES] fix build on Solaris 10/x86_64 in 64bit mode with Sun Studio 11
Previous Message Bruce Momjian 2007-01-10 18:07:10 Re: [HACKERS] [PATCHES] SGML index build fix

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-01-10 18:16:23 Re: [PATCHES] fix build on Solaris 10/x86_64 in 64bit mode with Sun Studio 11
Previous Message Bruce Momjian 2007-01-10 18:07:10 Re: [HACKERS] [PATCHES] SGML index build fix