Re: [PERFORM] Stuck using Sequential Scan

2004-09-10 Thread Oliver Elphick
On Tue, 2004-09-07 at 22:32, Jeremy M. Guthrie wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I have a problem where I have the table format listed below. I have the > primary key tsyslog_id and the index built against it. However, when I > select a unique row, it will only ever

[PERFORM] Stuck using Sequential Scan

2004-09-10 Thread Jeremy M. Guthrie
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a problem where I have the table format listed below. I have the primary key tsyslog_id and the index built against it. However, when I select a unique row, it will only ever do a seq scan even after I turn off all other types except indexs