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 7: don't forget to increase your free space map settings
