| From: | SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Postgres table size |
| Date: | 2007-11-13 16:36:30 |
| Message-ID: | 624802.39420.qm@web31109.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dan | 2007-11-13 17:02:31 | Sharing database handles across forked child processes |
| Previous Message | Tom Lane | 2007-11-13 16:28:49 | Re: (Never?) Kill Postmaster? |