Re: help needed for performance tuning

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

Corey





                    "Priya Nair"
                    <pnair@nubridges.com>        To:     <pgsql-admin@postgresql.org>
                    Sent by:                     cc:
                    pgsql-admin-owner@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@postgresql.org)