Re: Question about Lockhart's book - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Question about Lockhart's book
Date
Msg-id 52BDCC85.1000307@agliodbs.com
Whole thread Raw
In response to Question about Lockhart's book  (Christian Convey <christian.convey@gmail.com>)
Responses Re: Question about Lockhart's book
List pgsql-hackers
On 12/27/2013 08:14 AM, Christian Convey wrote:
> Hi Andrew,
> 
> Thanks for your response.  Sometimes overall software architectures stay
> (mostly) unchanged for a long time, and so I figured that's possibly the
> case for Postgresql as well.  But I didn't know, which is why I asked.

Some things in that book will still be accurate and informative.  The
problem is that you, as a beginner, won't know which things are still
good and which are obsolete.

I'd suggest:

- Developer documentation in our primary docs
- Developer FAQ on the wiki
- Bruce's presentations on various internals
- Tom's presentations on how the query planner works
- Various other people's presentations on other aspects, such as foreign
data wrappers, event triggers, etc.

Unfortunately, there's no central index of presentations.

I'm a big fan of "learn by doing", and here's a program which would
bring you up on a LOT of PostgreSQL:

1. Write a few of your own C functions, including trigger functions and
an operator.

2. Write your own foreign data wrapper for something.

3. Write your own Type, including input/output functions, stats
estimation and custom indexing.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: truncating pg_multixact/members
Next
From: Alvaro Herrera
Date:
Subject: Re: [COMMITTERS] pgsql: Upgrade to Autoconf 2.69