Copy of DB behaves different from original

From: jason(at)soundconcept(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: Copy of DB behaves different from original
Date: 2004-09-01 20:59:07
Message-ID: 20040901205907.15186.qmail@mail1.soundconcept.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

I have a database that I made a copy of (useing pg_dump) to test a new
program on. The program runs just fine on the new(copy) database. However,
when I switched my program to run on my old(original) database it runs
around 10 times slower and takes up way more processor power. I tried
vacuumdb on the old database and it made no difference. Any idea what my
problem might be? I could just drop and restore the old database, but I
would really like to understand what might be going on so I could watch for
it in the future and hopefully prevent it from happening again.

Any information is greatly appreciated.

Jason Haselbauer
Soundconcept.net
jason(at)soundconcept(dot)net

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2004-09-01 21:42:09 Re: Copy of DB behaves different from original
Previous Message Tom Lane 2004-09-01 14:27:05 Re: [NOVICE] Applicationl Crash - Connection reset by peer !!!