Re: SQL Performance Guidelines

From: "Van Ingen, Lane" <lvaningen(at)ESNCC(dot)com>
To: "Van Ingen, Lane" <lvaningen(at)ESNCC(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: SQL Performance Guidelines
Date: 2005-01-26 18:27:08
Message-ID: A3FF4275060B76459B5C08A64AE330C869CE@twmail.esncc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Clarification: I am talking about SQL coding practices in Postgres (how to write queries for best
results), not tuning-related considerations (although that would be welcomed too).

-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org on behalf of Van Ingen, Lane
Sent: Wed 1/26/2005 11:44 AM
To: pgsql-performance(at)postgresql(dot)org
Cc:
Subject: [PERFORM] SQL Performance Guidelines

Does anybody know where I can lay my hands on some guidelines to get best SQL performance
out of PostgreSQL? We are about to get into a project that will be new from the ground up (and\we are using Postgres for the first time). Would like to share some guidelines with developers on best practices
in Postgres? Thanks for your help.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Turner 2005-01-26 18:35:27 Re: [SQL] OFFSET impact on Performance???
Previous Message Josh Berkus 2005-01-26 18:03:15 Re: Ideal disk setup for Postgresql 7.4?