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

Re: Simple view confuses PostgreSQL query planning

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Simple view confuses PostgreSQL query planning
Date: 2004-05-20 21:43:38
Message-ID: m3zn824vw5.fsf@conexa.fciencias.unam.mx (view raw or flat)
Thread:
Lists: pgsql-sql
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Get rid of the CASEs (perhaps you could wrap them into functions
> declared STRICT) and the view would be flattenable.

Will do that. Thanks.

Regards,
Manuel.

In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2004-05-21 06:53:37
Subject: Re: OR clause causing strange index performance
Previous:From: Tom LaneDate: 2004-05-20 19:06:23
Subject: Re: Simple view confuses PostgreSQL query planning

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