On 11/20/07, Josh Harrison <joshques@xxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/