help needed for performance tuning

Поиск
Список
Период
Сортировка
Искать

help needed for performance tuning

От:
"Priya Nair" <pnair@nubridges.com>
Дата:
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?



Re: help needed for performance tuning

От:
Corey.Brune@transplace.com
Дата:

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

Corey




                                                                                                                      
                    "Priya Nair"                                                                                      
                            To:                                      
                    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)




Re: help needed for performance tuning

От:
"Priya Nair" <pnair@nubridges.com>
Дата:
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.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"                                                                                      
                            To:                                      
                    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)




FAQ