| From: | Raimon Fernandez <coder(at)montx(dot)com> |
|---|---|
| To: | Vick Khera <vivek(at)khera(dot)org> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SELECT is immediate but the UPDATE takes forever |
| Date: | 2010-12-09 03:58:55 |
| Message-ID: | 43D5FD70-0B2C-43A5-B8E3-40B1A13588D1@montx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
On 8dic, 2010, at 18:18 , Vick Khera wrote:
> 2010/12/7 Raimon Fernandez <coder(at)montx(dot)com>:
>> I'm using now another database with same structure and data and the delay doesn't exist there, there must be something wrong in my current development database.
>>
>
> does autovacuum run on it?
no
> is the table massively bloated?
no
> is your disk system really, really slow to allocate new space?
no
now:
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 ...
thanks,
r.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Allan Kamau | 2010-12-09 04:51:24 | Error handling in PL/PgSQL (without execution termination) |
| Previous Message | Raimon Fernandez | 2010-12-09 03:41:48 | Re: SELECT is immediate but the UPDATE takes forever |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vick Khera | 2010-12-09 13:32:51 | Re: SELECT is immediate but the UPDATE takes forever |
| Previous Message | Raimon Fernandez | 2010-12-09 03:41:48 | Re: SELECT is immediate but the UPDATE takes forever |