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