Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B00012E0037 for ; Sun, 23 Mar 2008 06:00:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 53674-03 for ; Sun, 23 Mar 2008 06:00:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.174]) by postgresql.org (Postfix) with ESMTP id E0EEA2E002D for ; Sun, 23 Mar 2008 06:00:26 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 28so2156036wff.28 for ; Sun, 23 Mar 2008 02:00:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=3inZF97m1+6ZLL7zBgAy3csBHrGEXMBb1wtmIo0+1mM=; b=KiZRcOc9dZg53pTAMvJVeY6gsxkpp/bWosWH2ApIp+aYMjbpxJsWcfZOz0lkG3ZmRrzmadB68nCcHzcaGBaDxC1jWRndi05cvTCSgriOsxFQQaoMdiNLkgOZHwjo9wAT/NNS2G7KcobyHAZEqiAs48E+BbPRpVCI2JumoOYZ5Sg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Eec+FFG5779if0U/PcOaKH9I7upFZJl04Ra2ZgH50FG8qAHiXOQ/OJ1bVXSmcsq8dunCoIb9eHcC4rjhB3dNx4ugoQk6bTTylHUJinSXW4foZgqHdRIt6a+hDDvDoFjy+gdy6HKMZr4prNeHjimb8gfD2UgwnZuRu87ZADH0ecM= Received: by 10.143.6.1 with SMTP id j1mr3614848wfi.45.1206262825911; Sun, 23 Mar 2008 02:00:25 -0700 (PDT) Received: by 10.142.203.17 with HTTP; Sun, 23 Mar 2008 02:00:25 -0700 (PDT) Message-ID: <57a815bf0803230200p1654e065p379c5e890830da63@mail.gmail.com> Date: Sun, 23 Mar 2008 20:00:25 +1100 From: "Mikel Lindsaar" To: pgsql-admin@postgresql.org Subject: Book recommendations MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/187 X-Sequence-Number: 28670 SELECT book.title, book.author, book.feedback FROM postgresql_admin_community JOIN books ON book.subject ILIKE '%postgres%' JOIN readings ON readings.reader_id = postgresql_admin_community.id WHERE postgres_admin_community.user_experience_level = 'I have spent years around databases, but never really 'in' them. I could write SQL if I had to, I set up my fair share of simple DBs that backed website content management systems and the like. I also spent about a year a university going through basic relational DB design and theory so I have a fairly solid grounding in keying, indices, relationships etc. All of my exposure to databases up until a few months ago was MySQL, then SqlServer. Now that I have a fairly serious postgresql installation happening, I am finding myself fairly deep and looking at non trivial issues like seriously playing with the explain analyze command, working out the best configs and making sure the backups work and are regular. I have done this so far by reading a lot of the Postgres manual and every website I can find, and the system is working quite well for now. But I want to take the next step.' LIMIT 10 ORDER BY book.popularity Regards Mikel