On 11/20/07, Josh Harrison <joshques@gmail.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.