book on advanced postgresql?

[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

[Tom Lane]

"John Wells" <jb@sourceillus trated.com> 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...res/index.html

regards, tom lane

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

http://archives.postgresql.org

[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" <jb@sourceillus trated.com> 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...res/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

[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

[Bruno Wolff III]

On Fri, Oct 03, 2003 at 10:08:43 -0400,
John Wells <jb@sourceillus trated.com> 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 ma*******@postg resql.org

[Tom Lane]

Bruno Wolff III <br***@wolff.to > writes:

On Fri, Oct 03, 2003 at 10:08:43 -0400,
John Wells <jb@sourceillus trated.com> 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...ide-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

[Holger Marzen]

On Fri, 3 Oct 2003, John Wells wrote:

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 have the book "PostgreSQL Introduction and Concepts" by Bruce Momjian.
For advanced SQL I have ordered Joe Celko's "SQL for Smarties" because
it was recommended by some people.

--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pk...rch=0xB5A1AFE1

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

[Network Administrator]

John,

I usually just grab the PDF's, convert them to PS files and then add the code to
duplex and print to a tray with 3 hole paper. :)

All in all I don't think that is too expensive but I can't really say I've had
to pay to do that recently.
Quoting John Wells <jb@sourceillus trated.com>:

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" <jb@sourceillus trated.com> 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...res/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

--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

_______________ _______________ ______
This email account is being host by:
VCSN, Inc : http://vcsn.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Gene Vital]

I have it and it is an excellent book!
It has, on occasion, made my brain hurt though :)
Holger Marzen wrote:

On Fri, 3 Oct 2003, John Wells wrote:

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 have the book "PostgreSQL Introduction and Concepts" by Bruce Momjian.
For advanced SQL I have ordered Joe Celko's "SQL for Smarties" because
it was recommended by some people.

--
Eugene Vital
Any technology indistinguishab le from magic is insufficiently advanced.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Christopher Browne]

Quoth ho****@marzen.d e (Holger Marzen):

For advanced SQL I have ordered Joe Celko's "SQL for Smarties" because
it was recommended by some people.

I keep it around; it is quite interesting. It is NOT
PostgreSQL-specific at all; Celko is fairly negative about the notion
of being DBMS-specific in general.

He is preparing a book on Sets and Trees, essentially expanding on
chapters 27 and 28, which should be quite interesting. SQL doesn't
usually "play very well" with tree structures, so that certainly
warrants an expansion of the literature.
--
output = ("cbbrowne" "@" "cbbrowne.c om")
http://cbbrowne.com/info/rdbms.html
First Rule of Computer Security
- Only forbid that which can be made impossible.
- Facilitate the possible.
- Have the wisdom to explain the difference.
-- Mark Miller