[Rd] PostgreSQL book

Douglas Bates bates@stat.wisc.edu
18 Nov 2000 15:01:02 -0600

Bruce Momjian has just published a book on PostgreSQL that should be
available from bookstores in the next month or so.  It can be
downloaded as a PDF file now from

I found the book to be well written and informative.  I recommend it.

Especially if you have to deal with large data sets, the combination
of relational databases and R is very useful.  Currently I am working
on a project where we have information on 3.5 million subjects
amounting to a total of 10.5 million records.  Processing these in
MySQL and PostgreSQL is much, much more efficient than what my
colleagues were doing with SAS and SPSS.  We took a sample of 180,000
subjects (550,000 records) and fit multilevel (linear mixed-effects)
models using lme in R after accessing the data from the relational

Douglas Bates                            bates@stat.wisc.edu
Statistics Department                    608/262-2598
University of Wisconsin - Madison        http://www.stat.wisc.edu/~bates/
r-devel mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-devel-request@stat.math.ethz.ch