Hi Could you explain us how you test Oracle - Select * from TABLENAME- in takes 0.009 milliseconds Is it with oracle sql developer ? How long does it take with sql*plus ? Note that sql developer only display first 50 or 100 rows , You should use the « count rows » button to get a better duration estimate. Regards PAscal -- Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html