[GENERAL] book on advanced postgresql?

2003-10-03 Thread John Wells
Are there any books out there that are fairly current, but go into the
more advanced aspects of Postgresql, such as internals and advanced
programming?  I'd rather avoid the whole intro to SQL with a few extra
chapters on Postgresql if I could help it.

Thanks,

John



---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [GENERAL] book on advanced postgresql?

2003-10-03 Thread Tom Lane
John Wells [EMAIL PROTECTED] writes:
 Are there any books out there that are fairly current, but go into the
 more advanced aspects of Postgresql, such as internals and advanced
 programming?  I'd rather avoid the whole intro to SQL with a few extra
 chapters on Postgresql if I could help it.

I'm not aware of any that are tilted towards advanced stuff.  Erm, have
you tried just reading the documentation :-) ?  I realize it's not
always easy to find what you need, but we could use suggestions about
how to make it better ...
http://developer.postgresql.org/docs/postgres/index.html

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [GENERAL] book on advanced postgresql?

2003-10-03 Thread John Wells
Tom,

I'd love to, but I can't read at a terminal for longer than an hour or so.
 I really prefer the dead tree version.

Does anyone provide printed copies of the documentation for a fee?  I know
some companies do this for other apps...

Thanks,

John

Tom Lane said:
 John Wells [EMAIL PROTECTED] writes:
 Are there any books out there that are fairly current, but go into the
 more advanced aspects of Postgresql, such as internals and advanced
 programming?  I'd rather avoid the whole intro to SQL with a few extra
 chapters on Postgresql if I could help it.

 I'm not aware of any that are tilted towards advanced stuff.  Erm, have
 you tried just reading the documentation :-) ?  I realize it's not
 always easy to find what you need, but we could use suggestions about
 how to make it better ...
 http://developer.postgresql.org/docs/postgres/index.html

   regards, tom lane

 ---(end of broadcast)---
 TIP 6: Have you searched our list archives?

http://archives.postgresql.org



---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [GENERAL] book on advanced postgresql?

2003-10-03 Thread Shridhar Daithankar
John Wells wrote:
Tom,

I'd love to, but I can't read at a terminal for longer than an hour or so.
 I really prefer the dead tree version.
You can get the tarball of HTMLs out of a build and view it in lynx or something 
like that if you prefer. They are very simple HTMLs.

I agree that when eyes are tired of looking at a CRT, printed copy works much 
better.

 Shridhar

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


Re: [GENERAL] book on advanced postgresql?

2003-10-03 Thread Bruno Wolff III
On Fri, Oct 03, 2003 at 10:08:43 -0400,
  John Wells [EMAIL PROTECTED] wrote:
 Tom,
 
 I'd love to, but I can't read at a terminal for longer than an hour or so.
  I really prefer the dead tree version.
 
 Does anyone provide printed copies of the documentation for a fee?  I know
 some companies do this for other apps...

You should be able to print the documentation on a printer. The released
versions come with postscript and/or pdf versions of the documentation.
The beta versions don't and it is a pain to generate the above. However,
if you just want 7.3 documentation, that should be available.
I think the 7.4 documentation is better, because it is all in one book
and some redundant information is eliminated. However, I don't know of
any postscript or pdf versions of the documentation that are available for
download.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [GENERAL] book on advanced postgresql?

2003-10-03 Thread Tom Lane
Bruno Wolff III [EMAIL PROTECTED] writes:
 On Fri, Oct 03, 2003 at 10:08:43 -0400,
   John Wells [EMAIL PROTECTED] wrote:
 Does anyone provide printed copies of the documentation for a fee?  I know
 some companies do this for other apps...

 You should be able to print the documentation on a printer. The released
 versions come with postscript and/or pdf versions of the documentation.
 The beta versions don't and it is a pain to generate the above.

In theory you can build the postscript versions for yourself, per the
procedure here:
http://developer.postgresql.org/docs/postgres/docguide-build.html
after you've installed all the tools listed on the preceding page.

Building the HTML version is pretty simple, but it does look like
making a nice printed version is tedious ... which, no doubt, is
why no one does it for beta releases.

If you are happy with reading docs for back releases, Prime Time
Freeware has PDF and hardcopy versions I believe:
http://www.ptf.com/

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [GENERAL] book on advanced postgresql?

2003-10-03 Thread Peter Eisentraut
Tom Lane writes:

 Building the HTML version is pretty simple, but it does look like
 making a nice printed version is tedious ... which, no doubt, is
 why no one does it for beta releases.

For printable versions, the size and complexity of the PostgreSQL
documentation breaks every tool known to me.  That is the reason why
printable version are so hard to find.

-- 
Peter Eisentraut   [EMAIL PROTECTED]


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