A tale of two similar databases

From: kishore(dot)sainath(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: A tale of two similar databases
Date: 2006-01-17 09:22:20
Message-ID: 1137489740.311825.221100@z14g2000cwz.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I am using PostgreSQL 7.3.2 on a server running Red Hat Linux 9.0.

I have two databases ( identical schema and similar data ).

One database, D1 contains the actual data of a Production Application.
The other D2 contains dummy data which is used during development and
testing of the application.

D2 actually contains a recent snapshot of D1 and hence contain almost
the same data.

The strange thing is that D1 is extremely fast whereas D2 is relatively
slow for any given query.
(Thank God, it isnt the other way round :) )

Eg,
An extensive Statistics query returns in a matter of seconds on D1 but
takes close to a minute on D2

I would like to know if anybody can answer why it is so.

Thanks in advance
- Kishore

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-01-17 09:28:55 Re: Stored procedures..PLEASE HELP
Previous Message Alagu Madhu 2006-01-17 08:46:52 Re: Stored procedures..PLEASE HELP