Mark Lewis <[EMAIL PROTECTED]> writes:
> What you probably want to do is tell PG that you're looking for a
> literal underscore and not for any matching character by escaping the
> underscore, that will allow it to do a much quicker index scan.
The other half of the problem is that the planner is
On Wed, 2007-08-29 at 18:01 +0530, Karthikeyan Mahadevan wrote:
>
> *
>
> 1)
>
> EXPLAIN ANALYSE SELECT
> job_category.job_id,job.name,job.state,job.build_id,cat.name as
>
*
1)
EXPLAIN ANALYSE SELECT
job_category.job_id,job.name,job.state,job.build_id,cat.name as
reporting_group
FROM category,job_category,job,category as cat
WHERE job.job_id=job
