Thread: Re: book for postgresql

Re: book for postgresql

From
Christopher Browne
Date:
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?

Re: book for postgresql

From
Bret Busby
Date:
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
....................................................


Re: book for postgresql

From
Bruce Momjian
Date:
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

Problems with pgsql mail servers?

From
Greg Stark
Date:
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

Re: Problems with pgsql mail servers?

From
"Marc G. Fournier"
Date:
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