Re: [PERFORM] Timestamp index not used in some cases

2009-05-13 Thread Евгений Василев
On Tuesday 12 May 2009 12:55:14 Scott Marlowe wrote: > On Tue, May 12, 2009 at 3:00 AM, Евгений Василев > > wrote: > > I have the following table: > > > > CREATE TABLE "temp".tmp_135528 > > ( > > id integer NOT NULL, > > prid integer, > > group_id integer, > > iinv integer, > > oinv integer, > > i

Re: [PERFORM] Timestamp index not used in some cases

2009-05-12 Thread Scott Marlowe
On Tue, May 12, 2009 at 3:00 AM, Евгений Василев wrote: > I have the following table: > > CREATE TABLE "temp".tmp_135528 > ( > id integer NOT NULL, > prid integer, > group_id integer, > iinv integer, > oinv integer, > isum numeric, > osum numeric, > idate timestamp without time zone, > odate times

[PERFORM] Timestamp index not used in some cases

2009-05-12 Thread Евгений Василев
I have the following table: CREATE TABLE "temp".tmp_135528 ( id integer NOT NULL, prid integer, group_id integer, iinv integer, oinv integer, isum numeric, osum numeric, idate timestamp without time zone, odate timestamp without time zone, CONSTRAINT t_135528_pk PRIMARY KEY (id