Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD

Tatsuo Ishii <ishii@postgresql.org>

From: Tatsuo Ishii <ishii@postgresql.org>

To: andres@2ndquadrant.com

Cc: girgen@FreeBSD.org, pgsql-hackers@postgresql.org, robertmhaas@gmail.com, ftigeot@wolfpond.org

Date: 2014-07-03T10:15:32Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add shared_memory_type GUC.
- f1bebef60ec8 12.0 landed

Attachments

0001-Add-shared_memory_type-GUC-9.3.patch (text/x-patch) patch 0001

Hi,

> Hi,
> 
> Attached you can find a short (compile tested only ) patch implementing
> a 'shared_memory_type' GUC, akin to 'dynamic_shared_memory_type'. Will
> only apply to 9.4, not 9.3, but it should be easy to convert for it.
> 
> Greetings,
> 
> Andres Freund

I have rebased Andres's patch against 9.3-STABLE tree. Please take a
look at attached patches and let me know if you find anything strange.

I am going to test the patch on a huge HP machine: DL980G7/64
cores/2TB mem.  With the patch I would be able to report back if using
SysV shared mem fixes the 9.3 performance problem.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp