indexes are not used
| От | dev Rp |
|---|---|
| Тема | indexes are not used |
| Дата | |
| Msg-id | F64TwaSydQLfCiylt6E00022e8b@hotmail.com обсуждение исходный текст |
| Ответы |
Re: indexes are not used
|
| Список | pgsql-general |
Hi, I have a table with 60,000 rows and integer as primary key. When I use select max(userid) from users; it is doing for sequential scan on users table, so that it is taking 40 seconds to get the result. So I have set the sequential scan to off by using follwing option. set enable_seqscan to 'off'. still it is going for sequentail scan. Postgresql is installed on Solaris 5.8 on P3 500 mhz processor having 256 mb ram. Is there is any other way to force to use index or do I have to tune the database to reduce query time. Thanks in advance. Looking forward for an early solution Devi _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
В списке pgsql-general по дате отправления: