Re: ctid access is slow
От | Ilja Golshtein |
---|---|
Тема | Re: ctid access is slow |
Дата | |
Msg-id | 430B24F7.000003.06520@colgate.yandex.ru обсуждение исходный текст |
Ответ на | Re: ctid access is slow (Robert Treat <xzilla@users.sourceforge.net>) |
Ответы |
Re: ctid access is slow
|
Список | pgsql-general |
Hi! >> Could anybody help me with this [artificial] query >> >> select ctid from aaa where ctid in (select ctid from aaa limit 10); [skipped] >I think using an indexed field would probably be faster for you, especially >if you have a PK on the table. I used to think ctid is the same as rowid in Oracle, where rowid access is the fastest. Is it wrong? After all, why oid is faster then ctid? I consider using index of course. I just cannot believe it is the best what I can do here. >Barring that, make sure you have >vacuumed/analyzed and send us explain analyze output. I played with fresh database. server version is 8.0.3, enable_tidscan is on, looks like hints have no effect. Thanks. -- Best regards Ilja Golshtein
В списке pgsql-general по дате отправления: