From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Piotr Legiecki <piotrlg(at)ams(dot)edu(dot)pl> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: old server, new server, same performance |
Date: | 2010-05-14 14:07:50 |
Message-ID: | AANLkTin6xI_c-hCKsTg4H7x8e-fpEUXiZ_gs5fg43sCS@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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?
From | Date | Subject | |
---|---|---|---|
Next Message | Yeb Havinga | 2010-05-14 14:13:12 | Re: old server, new server, same performance |
Previous Message | Kevin Grittner | 2010-05-14 14:04:52 | Re: old server, new server, same performance |