By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,904 Members | 1,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,904 IT Pros & Developers. It's quick & easy.

book for postgresql

P: n/a
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.

Thanks in advance.
Nov 22 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
A long time ago, in a galaxy far, far away, ew***@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/li...ributions.html
If a hole in the street is a manhole, is a hole in a man a streethole?
Nov 22 '05 #2

P: n/a
On Mon, 9 Feb 2004, Christopher Browne wrote:
Date: Mon, 09 Feb 2004 20:57:13 -0500
From: Christopher Browne <cb******@acm.org>
To: "pg*********@postgresql.org.pgsql-general"@postgresql.org
Subject: Re: [GENERAL] book for postgresql

A long time ago, in a galaxy far, far away, ew***@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
.................................................. ...
---------------------------(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

Nov 23 '05 #3

P: n/a
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
pg***@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

---------------------------(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

Nov 23 '05 #4

P: n/a

Bret Busby <br**@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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #5

P: n/a
On Tue, 1 Jun 2004, Greg Stark wrote:

Bret Busby <br**@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: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

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

Nov 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.