Re: help needed for performance tuning

it is a simple select from the table .The table has only 25 rows.it took 13 seconds for the query to give result.I did a vacumm every 5 mintues.Now it is fast.Now it takes only 1 sec

select * from a ;

Thanks..

-----Original Message-----
From: Corey(dot)Brune(at)transplace(dot)com [mailto:Corey(dot)Brune(at)transplace(dot)com]
Sent: Friday, August 01, 2003 9:49 AM
To: Priya Nair
Cc: pgsql-admin(at)postgresql(dot)org; pgsql-admin-owner(at)postgresql(dot)org
Subject: Re: [ADMIN] help needed for performance tuning

How is your query written, and are you dealing with any referential
interegrity?

Corey

"Priya Nair"
<pnair(at)nubridges(dot)com> To: <pgsql-admin(at)postgresql(dot)org>
Sent by: cc:
pgsql-admin-owner(at)post Subject: [ADMIN] help needed for performance tuning
gresql.org


07/31/03 02:36 PM

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?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)