X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ADA13D84EB for ; Tue, 30 Aug 2005 10:05:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51434-10 for ; Tue, 30 Aug 2005 13:05:13 +0000 (GMT) Received: from mail2.bona.us (mail2.bona.us [216.235.153.18]) by svr1.postgresql.org (Postfix) with SMTP id E1037D84DF for ; Tue, 30 Aug 2005 10:05:11 -0300 (ADT) Received: (qmail 7113 invoked by uid 399); 30 Aug 2005 13:10:58 -0000 Received: from unknown (HELO Akshay) (210.212.168.94) by mail2.bona.us with SMTP; 30 Aug 2005 13:10:58 -0000 From: "Akshay Mathur" To: Subject: Observation about db response time Date: Tue, 30 Aug 2005 18:35:30 +0530 Message-ID: <003401c5ad63$8420d940$9701a8c0@pune.wibhu.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0035_01C5AD91.9DD91540" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.19 required=5 tests=[HTML_90_100=0.189, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200508/513 X-Sequence-Number: 14260 This is a multi-part message in MIME format. ------=_NextPart_000_0035_01C5AD91.9DD91540 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello Friends, We were having a database in pgsql7.4.2 The database was responding very slowly even after full vacuum analyze (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 fasten the database? Regards, akshay --------------------------------------- Akshay Mathur SMTS, Product Verification AirTight Networks, Inc. ( www.airtightnetworks.net) O: +91 20 2588 1555 ext 205 F: +91 20 2588 1445 ------=_NextPart_000_0035_01C5AD91.9DD91540 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello Friends,

 

We were having a database in pgsql7.4.2 The database = was responding very slowly even after full vacuum analyze (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 fasten the = database?

 

Regards,

 

akshay<= font size=3D2 face=3DArial>

 

 

-----------------------------------= ----

Akshay Mathur

SMTS, Product = Verification

AirTight = Networks, Inc. (= www.airtightnetworks.net)

O: +91 20 2588 1555 ext = 205

F: +91 20 2588 1445

 

------=_NextPart_000_0035_01C5AD91.9DD91540--