| 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-08 17:18:05 |
| Message-ID: | AANLkTinjmjXpuF2zjV=SsX6FhZVLNUrvA7vmsrj9mu6-@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
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? is the table massively bloated? is your
disk system really, really slow to allocate new space?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bricklen | 2010-12-08 17:52:04 | Re: How to obtain the maximum value of a date, between 3 tables... |
| Previous Message | Adrian Klaver | 2010-12-08 17:12:05 | Re: Maximum size for char or varchar with limit |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raimon Fernandez | 2010-12-09 03:40:13 | use a variable name for an insert in a trigger for an audit |
| Previous Message | Alban Hertroys | 2010-12-07 18:20:08 | Re: SELECT is immediate but the UPDATE takes forever |