| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SELECT is immediate but the UPDATE takes forever |
| Date: | 2010-12-09 13:32:51 |
| Message-ID: | AANLkTinFWjd5tU3urAEsvnEptp32eZxGO3eCO8goW51q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
On Wed, Dec 8, 2010 at 10:58 PM, Raimon Fernandez <coder(at)montx(dot)com> wrote:
> well, after a VACUUM things are going faster ... I'm still trying to analyze the function as it seems there are other bottlechecnk, but at least the first update now is faster as before ...
>
If that's the case then your 'no' answer to "is the table bloated" was
probably incorrect, and your answer to "is your I/O slow to grow a
file" is also probably incorrect.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Richardson | 2010-12-09 14:11:39 | How can I create a PgAgent job creation script? |
| Previous Message | Paul Taylor | 2010-12-09 12:25:56 | Tuning Postgres for single user manipulating large amounts of data |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raimon Fernandez | 2010-12-09 16:08:41 | Re: SELECT is immediate but the UPDATE takes forever |
| Previous Message | Raimon Fernandez | 2010-12-09 03:58:55 | Re: SELECT is immediate but the UPDATE takes forever |