Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group