Il Tuesday 13 November 2007 17:36:30 SHARMILA JOTHIRAJAH ha scritto: > 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
This's an interesting point fore sure as far as the data types for the two table are comparable. If this yelds true, the more space an RDBMS occupies, the slower the access. I think. -- Reg me Please ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster