book for postgresql

A long time ago, in a galaxy far, far away, ewong@mail.com (Ed Wong) wrote:

I am an oracle dba and new to postgresql. Could you tell me what is
the best postgres book out there to start with? I am looking for a
book which is sort of a complete reference including some dba chapters
as well.

There are three fairly good books in printed form:

- New Riders has one that is about the most recent one published,
which, it seems to me, has about the best explanation of the query
optimizer going, as well as quite a lot of other fairly deep
technical material;

- Addison Wesley published Bruce Momjian's book which is getting a bit
dated, but which is still quite good;

- O'Reilly has a third one that is also "dated but good."

The online material is also a good source, and is commonly included
along with the PostgreSQL installation.

All four of these sources are quite good. I have all but Bruce's book
on my desk...
--
output = ("cbbrowne" "@" "cbbrowne.com")
http://www3.sympatico.ca/cbbrowne/linuxdistributions.html
If a hole in the street is a manhole, is a hole in a man a streethole?

On Mon, Feb 09, 2004 at 08:57:13PM -0500, Christopher Browne (cbbrowne@acm.org) wrote:

There are three fairly good books in printed form:

I would add to these:

PostgreSQL by Douglas & Douglas
Developer's Library

Published about a year ago.
--
Ken Dyke,
406.581.0495

On Mon, 9 Feb 2004, Christopher Browne wrote:

Date: Mon, 09 Feb 2004 20:57:13 -0500
From: Christopher Browne <cbbrowne@acm.org>
To: "pgsql-admin@postgresql.org.pgsql-general"@postgresql.org
Subject: Re: [GENERAL] book for postgresql

A long time ago, in a galaxy far, far away, ewong@mail.com (Ed Wong) wrote:

I am an oracle dba and new to postgresql. Could you tell me what is
the best postgres book out there to start with? I am looking for a
book which is sort of a complete reference including some dba chapters
as well.

There are three fairly good books in printed form:

- New Riders has one that is about the most recent one published,
which, it seems to me, has about the best explanation of the query
optimizer going, as well as quite a lot of other fairly deep
technical material;

- Addison Wesley published Bruce Momjian's book which is getting a bit
dated, but which is still quite good;

- O'Reilly has a third one that is also "dated but good."

The online material is also a good source, and is commonly included
along with the PostgreSQL installation.

All four of these sources are quite good. I have all but Bruce's book
on my desk...

For some strange reason, the message above, took somewhat over
three months to come through, maybe due to the To address in the header
(?).

I am wondering whether, given that Bruce Momjian's book appears to be
regarded as "a bit dated", a 2nd Edition is on the way?

--
Bret Busby
Armadale
West Australia
..............

"So once you do know what the question actually is,
you'll know what the answer means."
- Deep Thought,
Chapter 28 of
"The Hitchhiker's Guide to the Galaxy:
A Trilogy In Four Parts",
written by Douglas Adams,
published by Pan Books, 1992
....................................................

Bret Busby wrote:

- New Riders has one that is about the most recent one published,
which, it seems to me, has about the best explanation of the query
optimizer going, as well as quite a lot of other fairly deep
technical material;

- Addison Wesley published Bruce Momjian's book which is getting a bit
dated, but which is still quite good;

- O'Reilly has a third one that is also "dated but good."

The online material is also a good source, and is commonly included
along with the PostgreSQL installation.

All four of these sources are quite good. I have all but Bruce's book
on my desk...

For some strange reason, the message above, took somewhat over
three months to come through, maybe due to the To address in the header
(?).

I am wondering whether, given that Bruce Momjian's book appears to be
regarded as "a bit dated", a 2nd Edition is on the way?

I talked to the publisher and they didn't seem excited about a second
edition of my book. I will ask again in a few months.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Bret Busby <bret@busby.net> writes:

For some strange reason, the message above, took somewhat over
three months to come through, maybe due to the To address in the header
(?).

I also just received a message from a pgsql mailing list dated Feb 12. The
delay seemed to be in the queue on ns.pcbuddy.net [66.132.188.173]. And
someone commented a few months ago that I was unknowingly responding to a
long-dead thread, presumably due to a similar occurrence.

Is it possible these mail servers aren't running their queues regularly? If a
network failure causes a delivery failure on the first attempt messages will
sit in a queue until they're retried. If qmail isn't configured to run its
queue regularly then they'll languish there.

--
greg

On Tue, 1 Jun 2004, Greg Stark wrote:

Bret Busby <bret@busby.net> writes:

For some strange reason, the message above, took somewhat over
three months to come through, maybe due to the To address in the header
(?).

I also just received a message from a pgsql mailing list dated Feb 12. The
delay seemed to be in the queue on ns.pcbuddy.net [66.132.188.173]. And
someone commented a few months ago that I was unknowingly responding to a
long-dead thread, presumably due to a similar occurrence.

Is it possible these mail servers aren't running their queues regularly? If a
network failure causes a delivery failure on the first attempt messages will
sit in a queue until they're retried. If qmail isn't configured to run its
queue regularly then they'll languish there.

'k, way back, I removed 66.132.191.19 out of the list of mail relays ...
IP isn't the same, but they may have changed the IP since ... but we
haven't been relaying through it in awhile ... so we aren't adding to its
queue ...

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664