Re: [GENERAL] Book recommendation?
On 1 Feb 2011, at 21:15, Greg Smith wrote: > Herouth Maoz wrote: >> My sysadmin ran into the following book: >> >> PostgreSQL 9.0 High Performance, by Gregory Smith, ISBN 184951030X >> http://amzn.com/184951030X >> > > That guy's a troublemaker, but I guess he writes OK. It must be tough to be reminded of him every time you look into a mirror. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4d487b6011733122416624! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Book recommendation?
Herouth Maoz wrote: My sysadmin ran into the following book: PostgreSQL 9.0 High Performance, by Gregory Smith, ISBN 184951030X http://amzn.com/184951030X That guy's a troublemaker, but I guess he writes OK. There are three customer reviews at http://www.amazon.com/PostgreSQL-High-Performance-Gregory-Smith/product-reviews/184951030X/ and two longer ones at: http://people.planetpostgresql.org/andrew/index.php?/archives/130-Buy-this-book,-now..html http://www.postgresonline.com/journal/archives/192-postgresql9highperformance.html And here's some free samples: https://www.packtpub.com/article/postgresql-9-reliable-controller-disk-setup https://www.packtpub.com/article/postgresql-9-balancing-hardware-spending https://www.packtpub.com/article/server-configuration-tuning-postgresql https://www.packtpub.com/article/unix-monitoring-tool-for-postgresql https://www.packtpub.com/article/postgresql-tips-tricks https://www.packtpub.com/sites/default/files/0301OS-Chapter-2-Database-Hardware.pdf -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Book recommendation?
On Tue, Feb 1, 2011 at 8:56 AM, Herouth Maoz wrote: > My sysadmin ran into the following book: > > PostgreSQL 9.0 High Performance, by Gregory Smith, ISBN 184951030X > http://amzn.com/184951030X highly recommended. Also take a look at the pg admin cookbook from packt. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Book recommendation?
hero...@unicell.co.il (Herouth Maoz) writes: > As a result of my recent encounter with table bloat and other tuning > issues I've been running into, I'm looking for a good resource for > improving my tuning skills. > > My sysadmin ran into the following book: > > PostgreSQL 9.0 High Performance, by Gregory Smith, ISBN 184951030X > http://amzn.com/184951030X > > Which covers versions 8.1 through 9. > > Any opinions on this book? Other suggestions? It's the best thing in that vein that is available, and is rather good. The only thing that's *somewhat* comparable is _PostgreSQL_ by Korry Douglas & Susan Douglas, which, alas, is now 7 years old, and thus rather dated. It was the one reference that had substantive material on query planning, though that's likely somewhat less relevant to you. You should certainly take a look at Greg Smith's book. -- (reverse (concatenate 'string "moc.liamg" "@" "enworbbc")) http://linuxdatabases.info/info/finances.html "what would we do without C? we would have PASAL, BASI, OBOL, and Ommon Lisp." -- #Erik -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Book recommendation?
On Tue, Feb 1, 2011 at 11:14 AM, Jeff Ross wrote: > I doubt you'll find a better book resource for recent versions of > PostgreSQL. Both are well and clearly written, and cover a lot of ground > in great detail. > > Greg Smith has helped me and countless others on this and the Performance > list and he is truly an authoritative resource. > I've hired Greg for performance tuning work, and I must say he *really* knows what he's doing. I've read some chapters in the book and he seems to get across his knowledge very well into those pages. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Book recommendation?
On 02/01/11 08:55, Herouth Maoz wrote: As a result of my recent encounter with table bloat and other tuning issues I've been running into, I'm looking for a good resource for improving my tuning skills. My sysadmin ran into the following book: PostgreSQL 9.0 High Performance, by Gregory Smith, ISBN 184951030X http://amzn.com/184951030X Which covers versions 8.1 through 9. Any opinions on this book? Other suggestions? Thank you, Herouth I bought this when it first came out. I bought the pdf version directly from Packt bundled with the PostgreSQL 9 Admin Cookbook for an amazingly low price. I doubt you'll find a better book resource for recent versions of PostgreSQL. Both are well and clearly written, and cover a lot of ground in great detail. Greg Smith has helped me and countless others on this and the Performance list and he is truly an authoritative resource. Jeff -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Book recommendation?
> As a result of my recent encounter with table bloat and other tuning > issues I've been running into, I'm looking for a good resource for > improving my tuning skills. > > My sysadmin ran into the following book: > > PostgreSQL 9.0 High Performance, by Gregory Smith, ISBN 184951030X > http://amzn.com/184951030X > > Which covers versions 8.1 through 9. > > Any opinions on this book? Other suggestions? 100% positive - go and buy it. It's very thorough, it covers a lot of associated topics (hw, filesystem, ...) and it's fresh. There were several reviews at planet.postgresql.org and all of them weve very positive. regards Tomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Book recommendation?
As a result of my recent encounter with table bloat and other tuning issues I've been running into, I'm looking for a good resource for improving my tuning skills. My sysadmin ran into the following book: PostgreSQL 9.0 High Performance, by Gregory Smith, ISBN 184951030X http://amzn.com/184951030X Which covers versions 8.1 through 9. Any opinions on this book? Other suggestions? Thank you, Herouth -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Book recommendation
I'm looking for a really good book on SQL (not Postgres particularly) to include such arcanery as Triggers Stored procedures Query optimisation Examples illustrating these concepts will be a big bonus. Any recommendations? Si. -- Simon Drabble [EMAIL PROTECTED]