| From: | Corey(dot)Brune(at)transplace(dot)com |
|---|---|
| To: | "Priya Nair" <pnair(at)nubridges(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-admin-owner(at)postgresql(dot)org |
| Subject: | Re: help needed for performance tuning |
| Date: | 2003-08-01 13:49:06 |
| Message-ID: | OF97C6B3FF.C2FFB7BE-ON86256D75.004BC459@transplace.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
How is your query written, and are you dealing with any referential
interegrity?
Corey
"Priya Nair"
<pnair(at)nubridges(dot)com> To: <pgsql-admin(at)postgresql(dot)org>
Sent by: cc:
pgsql-admin-owner(at)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(at)postgresql(dot)org)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Priya Nair | 2003-08-01 13:54:39 | Re: help needed for performance tuning |
| Previous Message | Richard Huxton | 2003-08-01 13:31:31 | Re: [GENERAL] error while loading shared libraries: libpq.so.3 |