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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
