Postgres Pro
Downloads
Home   >   mailing lists

Re: planner doesn't use multicolumn index - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: planner doesn't use multicolumn index
Date
Msg-id vv78ov80ffnvhhbrnj0f3qbhopaimnr63k@email.aon.at
Whole thread Raw
In response to planner doesn't use multicolumn index  (Adrian Demaestri <ademaestri@yahoo.com>)
List pgsql-performance
Tree view 
On Wed, 8 Oct 2003 09:08:59 -0500 (CDT), Adrian Demaestri
<ademaestri@yahoo.com> wrote:
>the type of the fields are int2 and
>int4, the where condition is v.g. partido=99 and partida=123).

Write your search condition as

    WHERE partido=99::int2 and partida=123

Servus
 Manfred

pgsql-performance by date:

Previous
From: Jeff
Date:
Subject: Presentation
Next
From: Jeff
Date:
Subject: Re: Sun performance - Major discovery!