| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | creimer(at)brturbo(dot)com(dot)br |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Context switch storm |
| Date: | 2006-11-03 15:25:47 |
| Message-ID: | 2400.1162567547@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
creimer(at)brturbo(dot)com(dot)br writes:
> And why this happens only with 8.0 and 8.1 and not with the 7.4?
8.0 and 8.1 are vulnerable to this behavior because of conflicts for
access to pg_subtrans (which didn't exist in 7.4). The problem occurs
when you have old open transactions, causing the window over which
pg_subtrans must be accessed to become much wider than normal.
8.2 should eliminate or at least alleviate the issue, but in the
meantime see if you can get your applications to not sit on open
transactions.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2006-11-03 15:27:28 | Re: profiling PL/pgSQL? |
| Previous Message | Tom Lane | 2006-11-03 14:50:53 | Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs |