| From: | "Trevor Talbot" <quension(at)gmail(dot)com> |
|---|---|
| To: | "Josh Harrison" <joshques(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgresql storage and performance questions |
| Date: | 2007-11-20 17:47:31 |
| Message-ID: | 90bce5730711200947h6dd91d8dtbbdadf8dd193b243@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/20/07, Josh Harrison <joshques(at)gmail(dot)com> wrote:
> We are working on migrating our database from oracle to postgres.
> Postgres tablesize is twice than oracle tablesize for all my
> tables.And so the query also takes twice as much time than oracle. So
> we were checking to see what makes postgres slower than oracle even
> for basic full tablescan queries.
A similar question came up recently:
http://archives.postgresql.org/pgsql-general/2007-11/msg00619.php
You won't see anything that dramatic, but you might try to see how
8.3beta does with your test data.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Harrison | 2007-11-20 18:04:48 | Re: postgresql storage and performance questions |
| Previous Message | Joshua D. Drake | 2007-11-20 17:18:13 | Re: [GENERAL] PostgreSQL Conference 08 East! |