| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Bahadur Singh <bahadursingh(at)yahoo(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: BUG #1697: Select getting slower on continously updating data |
| Date: | 2005-06-02 13:02:59 |
| Message-ID: | 20050602130259.GB9716@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-novice pgsql-performance |
This does not belong on the pgsql-bugs list. The pgsql-novice or
pgsql-performance lists seem more appropiate. I have set followups
to the pgsql-novice list.
On Thu, Jun 02, 2005 at 12:05:00 +0100,
Bahadur Singh <bahadursingh(at)yahoo(dot)com> wrote:
>
> Hello,
>
> I found situtation that, when I am selecting data from a table of 200
> records, getting slower as I do continous update to the same existing data.
You need to be vacuuming (and possibly analyzing) the table more often as the
updates will leave dead rows in the table which will bloat the table size and
slow down access, particularly sequential scans. If the updates modify the
data value distributions significantly, then you will also need to
reanalyze the table to help the planner make good decisions.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-06-02 15:46:28 | Re: More graceful handling of invalid log_*_stats conf in 7.4 |
| Previous Message | Bahadur Singh | 2005-06-02 11:05:00 | BUG #1697: Select getting slower on continously updating data |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tövis | 2005-06-02 17:12:36 | ecpg use or not |
| Previous Message | Bahadur Singh | 2005-06-02 11:05:00 | BUG #1697: Select getting slower on continously updating data |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Fandel | 2005-06-02 13:10:03 | Re: postgresql-8.0.1 performance tuning |
| Previous Message | Martin Fandel | 2005-06-02 12:50:00 | Re: postgresql-8.0.1 performance tuning |