I have two fairly simple tables as described below. The relationship
between them is through assignment_id. The problem is when I try to
join these two tables the planner does a sequential scan on
fa_assignment_detail and the query takes forever to resolve. I've run
the usual vacuum and anal
Lennin Caro wrote:
--- On Wed, 10/1/08, H. William Connors II <[EMAIL PROTECTED]> wrote:
From: H. William Connors II <[EMAIL PROTECTED]>
Subject: [PERFORM] bizarre query performance question
To: pgsql-performance@postgresql.org
Date: Wednesday, October 1, 2008, 8:34 PM
I hav
