help needed for performance tuning

From: "Priya Nair" <pnair(at)nubridges(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: help needed for performance tuning
Date: 2003-07-31 19:36:14
Message-ID: 3430B9A60E93564FAB3B5861335CBDCF849439@germanium.numethods.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi
It takes 10 -12 seconds for a select of a table with 25 rows.One of the filed of this table is getting updated every 3 minutes..Do you think vacuum of the table every 10 min will help to speed this up?

Browse pgsql-admin by date

  From Date Subject
Next Message Priya Nair 2003-07-31 19:40:51 Recall: help needed for performance tuning
Previous Message Joe Maldonado 2003-07-31 19:22:12 Partitioning tables...