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
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 |