On May 14, 2010, at 3:52 PM, Scott Marlowe wrote: > 2010/5/14 Piotr Legiecki <piot...@sci.pam.szczecin.pl>: >> So what is the problem? My simple 'benchmarks' I have done with pgAdmin in >> spare time. >> >> pgAdmin is the latest 1.8.2 on both D and E. >> Using pgAdmin on my (D) computer I have run SELECT * from some_table; and >> noted the execution time on both A and B servers: > > So, any chance you'll run it like I asked: > > select count(*) from some_table; > > ?
I agree that select * is a very bad test and probably the problem here. Even if you do 'select * from foo' locally to avoid the network and pipe it to /dev/null, it is _significantly_ slower than count(*) because of all the data serialization. > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
