| From: | Spiros Ioannou <sivann(at)inaccess(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | hlinnaka(at)iki(dot)fi, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Subject: | Re: Lots of stuck queries after upgrade to 9.4 |
| Date: | 2015-07-20 13:09:55 |
| Message-ID: | CACKh8C-xLwkyPqQdhKfkGe_fxq0tZwhf3UKCKd_tQaXppUOHng@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Debian 6, x64, HP Proliant, dbsize: 3TB on EMC AX-4i (iscsi), 16 cores,
24GB RAM.
kernel: Linux vserver11 2.6.32-5-xen-amd64 #1 SMP Sun Dec 7 22:52:42 UTC
2014 x86_64 GNU/Linux
I attach postgresql.conf
*Spiros Ioannou IT Manager, inAccesswww.inaccess.com
<http://www.inaccess.com>M: +30 6973-903808T: +30 210-6802-358*
On 20 July 2015 at 16:04, Andres Freund <andres(at)anarazel(dot)de> wrote:
> Hi,
>
> On 2015-07-20 15:58:33 +0300, Spiros Ioannou wrote:
> > Happened again, another backtrace from a COMMIT process. I changed the
> > commit_delay to 0 (it was 4000 to help with our storage) and will report
> > back.
>
> What hardware & OS is this happening on?
>
> Regards,
>
> Andres
>
| Attachment | Content-Type | Size |
|---|---|---|
| postgresql.conf | application/octet-stream | 21.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafal Pietrak | 2015-07-20 13:33:44 | Re: INSERT ... ON CONFLICT DO UPDATE |
| Previous Message | Andres Freund | 2015-07-20 13:04:13 | Re: Lots of stuck queries after upgrade to 9.4 |