Skip site navigation (1) Skip section navigation (2)

Differing performance between Ubuntu 10.04 and 10.10

From: Tony Day <tonyd(at)panztel(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Differing performance between Ubuntu 10.04 and 10.10
Date: 2010-12-02 01:05:50
Message-ID: AANLkTi=C9UqD=L5X_SQ4JRfbnGiRd+db1zXe2swaJDk9@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Folks

Has anybody encountered any differences between performance of
Postgres 8.4.5 between Ubuntu 10.04 64 bit (Lucid) and Ubuntu 10.10 64
bit (Maverick) ?

A colleague and I have similar spec dev machines.
He is running Maverick and I am running Lucid.
Both machines have a very "standard" desktop setup - most software
installed from Ubuntu repos.

We both loaded a production sized database dump onto our dev machines
and tested our application (a Rails app).
We noticed some interesting differences.

Time to load dump
Lucid - approximately 30 minutes
Maverick - more than 4 hours 30 minutes (we left it to finish
overnight so we are not sure how long it took in the end).
The load used psql to load an uncompressed dump created with pg_dump -
same file on both machines.

Time to load a fairly complex page
Lucid - more than 120 seconds
Maverick - approximately 7 seconds


We realise that this is a fairly crude comparison but it seems odd to
us that one machine is noticeably faster to load the dump and the
other is noticeably faster to execute the query.

Some of the things that we have considered that we thought might
account for the difference:

version of Postgres - 8.4.5 on both machines (from Ubuntu repo)
file system type - ext4 on both machines
postgresql.conf - the same on both machines

Does anybody have any suggestions as to what might cause such a
difference (or noticed such a difference themselves) ?

Many thanks

Regards, Tony

pgsql-novice by date

Next:From: Basil BourqueDate: 2010-12-02 03:03:23
Subject: Get server's time in UTC time zone, in ISO 8601 format
Previous:From: Pushpendra Singh ThakurDate: 2010-12-01 21:05:31
Subject: Hot standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group