Re: [PERFORM] Index use and slow queries

2005-03-12 Thread Tom Lane
Russell Smith <[EMAIL PROTECTED]> writes: > On Sun, 13 Mar 2005 04:40 pm, Tom Pfeifer wrote: >> I get really slow repoonse times when using the following select statement >> (About 20 seconds). >> maach=# explain select * from tst where tst_id = 639246; > Before 8.0, bigint would not use an ind

Re: [PERFORM] Index use and slow queries

2005-03-12 Thread Russell Smith
On Sun, 13 Mar 2005 04:40 pm, Tom Pfeifer wrote: > Hello, > > > My version of Postgresql is 7.4.3. > I have a simple table with 2 indexes: > Table "public.tst" >  Column |    Type |  Modifiers > +

[PERFORM] Index use and slow queries

2005-03-12 Thread Tom Pfeifer
Hello, My version of Postgresql is 7.4.3. I have a simple table with 2 indexes: Table "public.tst"  Column |    Type |  Modifiers +-+-  tst_id | bigint