Обсуждение: help needed for performance tuning

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
3minutes..Do you think vacuum of the table every 10 min will help to speed this up? 

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)

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
avacumm every 5 mintues.Now it is fast.Now it takes only 1 sec 

select * from a ;

Thanks..

-----Original Message-----
From: Corey.Brune@transplace.com [mailto:Corey.Brune@transplace.com]
Sent: Friday, August 01, 2003 9:49 AM
To: Priya Nair
Cc: pgsql-admin@postgresql.org; pgsql-admin-owner@postgresql.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@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)