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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 9:49 AM To: Priya Nair Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ADMIN] help needed for performance tuning How is your query written, and are you dealing with any referential interegrity? Corey "Priya Nair" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
