Re: [GENERAL] Performance problem with 50,000,000 rows

2001-10-12 Thread tony
On Thu, 2001-10-11 at 00:03, Feite Brekeveld wrote: > Just, reading it and I always enter these kind of queries like: > > select i.isbn, > t.vendor, > i.store, > i.qty > from bk_inv i, > bk_title t > where >t.vendor = '01672708' and >i.is

Re: [GENERAL] Performance problem with 50,000,000 rows

2001-10-10 Thread Feite Brekeveld
David Link wrote: Just, reading it and I always enter these kind of queries like: select i.isbn, t.vendor, i.store, i.qty from bk_inv i, bk_title t where t.vendor = '01672708' and i.isbn = t.isbn; Don't know if it makes a difference but I

[GENERAL] Performance problem with 50,000,000 rows

2001-10-10 Thread David Link
I'm new to PG but this just seems wrong. Can someone take a look: .---. .---. | bk_inv| | bk_title | |---| |---| | isbn |<--->| isbn | | store | | vendor| | qty | | | | week | `-