On Mon, Jul 13, 2009 at 5:23 AM, Suvankar Roy<suvankar.roy@xxxxxxx> wrote: > > Hi, > > I have some 99,000 records in a table (OBSERVATION_ALL) in a Postgres DB as > well as a Greenplum DB. > > The Primary key is a composite one comprising of 2 columns (so_no, > serial_no). > > The execution of the following query takes 8214.016 ms in Greenplum but only > 729.134 ms in Postgres. > select * from observation_all order by so_no, serial_no; > > I believe that execution time in greenplum should be less compared to > postgres. Can anybody throw some light, it would be of great help. What versions are you comparing? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
