On Sat, Mar 30, 2013 at 11:00 PM, Kelphet Xiong <kelphet@xxxxxxxxx> wrote: > I guess it is because postgres only uses a single thread to read > the data or “pushing the data around in RAM” according to Kevin’s statement. > Then my question is actually why postgres can not use the remaining > 93.4%CPU. postgres can use an arbitrary amount of threads to read data, but only one per database connection. > Btw, I also tried the command suggested by Ants Aasma, but got an error: > > explain (analyze on, timing off) select * from inventory; > ERROR: syntax error at or near "analyze" > > LINE 1: explain (analyze on, timing off) select * from inventory; > > ^ Ability to manipulate timing was added in 9.2. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
