Re: old server, new server, same performance

2010/5/14 Piotr Legiecki <piotrlg(at)ams(dot)edu(dot)pl>:
> Hi
> The goal: migrate postgresql from A to B.
>
> Simple and works fine (using pg_dump, psql -d dbname <bakcup_file).
>
> 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:
> - on A (the old one) about 120sec
> - on B (the new monster) about 120sec (???)

It could well be you're measuring the time it takes to trasnfer that
data from server to client.

How fast is select count(*) from table on each machine?