From: akshay@airtightnetworks.net
To: pgsql-performance@postgresql.org
Subject: Observation about db response time
Date: Sat, 27 Aug 2005 21:28:57 +0530 (IST)
Message-ID: <2527.192.168.1.175.1125158337.squirrel@mailserv> (raw)
Hello Friends,
We were having a database in pgsql7.4. The database was responding very
slowly even after full vacuum (select
count(*) from some_table_having_18000_records was taking 18 Sec).
We took a backup of that db and restored it back. Now the same db on
same PC is responding fast (same query is taking 18 ms).
But we can't do the same as a solution of slow response. Do anybody has
faced similar problem? Is this due to any internal problem of pgsql? Is
there any clue to fasteen the database?
Regards,
akshay
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: akshay@airtightnetworks.net
Subject: Re: Observation about db response time
In-Reply-To: <2527.192.168.1.175.1125158337.squirrel@mailserv>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox