For example, IIRC when joining an integer column with a SERIAL column,
you must expicitly cast it as an integer or the planner will not use
the indexes, right? (This is a guess, as I remember reading something
like this and thinking, "How in the world is someone supposed to
figure that out, even wi
On Thu, 27 Jan 2005 00:02:29 -0800, Dustin Sallings wrote:
>
> On Jan 26, 2005, at 10:27, Van Ingen, Lane wrote:
>
> > 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
>
Sent: Wed 1/26/2005 11:44 AM
To: pgsql-performance@postgresql.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 (a
To: pgsql-performance@postgresql.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
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 practice