2010/5/14 Piotr Legiecki <piotrlg@xxxxxxxxxx>: > 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? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
