On Fri, Jan 27, 2012 at 06:31, sridhar bamandlapally <sridhar.bn1@xxxxxxxxx> wrote: > -------------------------------------------------------------------------- > | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | > -------------------------------------------------------------------------- > | 0 | SELECT STATEMENT | | 7444K| 944M| 16077 (4)| 00:03:13 | > | 1 | TABLE ACCESS FULL| EMP | 7444K| 944M| 16077 (4)| 00:03:13 | > -------------------------------------------------------------------------- Sorry to take this off topic, but... Seriously, over 3 minutes to read 944 MB of data? That's less than 5 MB/s, what's wrong with your database? :) Regards, Marti -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
