Hi
I have a table with 29384048 records in oracle and postgresql. The table has
47 columns (16 numeric and 27 varchar and the rest timestamp). The tablesize in
postgresql is twice as much than the tablesize in oracle (for the same number
of rows and columns). There are no updates or deletes in this table. It is a
test table that is used only for querying. The tables are vacuumed regularly
Even a simple seqscan query takes twice as much time in postgres than in oracle.
Does postgresql generally occupy more space than oracle tables?
Thanks
Sharmila
____________________________________________________________________________________
Get easy, one-click access to your favorites.
Make Yahoo! your homepage.
http://www.yahoo.com/r/hs
