On 27 Leden 2012, 10:06, Marti Raudsepp wrote: > 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? :) Yes, those results are quite suspicious. There's probably something interfering with the queries (other queries, different processes, block cleanout, ...) or maybe this is purely due to caching. sridhar, run the queries repeatedly and my quess is the difference will disappear (and the fist query will be a bit faster I guess). Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
