| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org, "JAIRO Gubler" <jairo(dot)gubler(at)digitro(dot)com(dot)br> |
| Subject: | Re: slow line insert |
| Date: | 2001-07-16 16:02:09 |
| Message-ID: | 7780.995299329@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br> writes:
> The problem is realted with "1 | serv_acaoserv | 154406" tuple, wich
> takes 5-10 secs to be updated, whether it's called from this stored
> procedure or from a simple UPDATE clause. All other tuples goes fine,
> update time is about 10-30ms.
Have you updated that particular row many more times than the rest?
If so, you have a lot of dead versions of the row that need to be
cleaned out.
> I did not tried a vacuumdb yet.
You should run vacuum on a regular basis.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | markMLl.pgsql-general | 2001-07-16 16:12:01 | Re: html to postgres... |
| Previous Message | Thalis A. Kalfigopoulos | 2001-07-16 15:59:47 | Re: PASSWORD() function for postgresql? |