From: =?UTF-8?B?5p2O5ZiJ?= <lijia@thunisoft.com>
To: "'Steve Midgley'" <science@misuse.org>
Cc: "'postgres list'" <pgsql-sql@postgresql.org>
References: <001501d19087$287a1850$796e48f0$@com>
 <CAJexoSJBkDioBE3d9=sh9MzSty+1wYv-XgqbM31hOO_YV0hx=g@mail.gmail.com>
In-Reply-To: 
 <CAJexoSJBkDioBE3d9=sh9MzSty+1wYv-XgqbM31hOO_YV0hx=g@mail.gmail.com>
Subject: =?UTF-8?Q?=E7=AD=94=E5=A4=8D:_=5BSQL=5D_postgresql_cpu_questio?=
	=?UTF-8?Q?n?=
Date: Thu, 7 Apr 2016 14:43:30 +0800
Message-ID: <002701d19098$cca996b0$65fcc410$@com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0028_01D190DB.DACCD6B0"
Thread-Index: AdGQiVTqD6LvqdN+QKe8U75yvOz5xgADszvA
Content-Language: zh-cn
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

这是一封 MIME 格式的多部分邮件。

------=_NextPart_000_0028_01D190DB.DACCD6B0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

thanks

=20

=E5=8F=91=E4=BB=B6=E4=BA=BA: Steve Midgley [mailto:science@misuse.org]=20
=E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2016=E5=B9=B44=E6=9C=887=E6=97=A5 =
12:46
=E6=94=B6=E4=BB=B6=E4=BA=BA: =E6=9D=8E=E5=98=89
=E6=8A=84=E9=80=81: postgres list
=E4=B8=BB=E9=A2=98: Re: [SQL] postgresql cpu question

=20

2016-04-06 21:37 GMT-07:00 =E6=9D=8E=E5=98=89 <lijia@thunisoft.com>:

postgresql  can limit the cpu number?

=20

=20

One method: =
https://www.commandprompt.com/blogs/alexey_klyukin/2012/06/binding_postgr=
esql_server_to_specific_cpu_cores_in_linux/=20


------=_NextPart_000_0028_01D190DB.DACCD6B0
Content-Type: text/html;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:=E5=AE=8B=E4=BD=93;
	panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:"\@=E5=AE=8B=E4=BD=93";
	panose-1:2 1 6 0 3 1 1 1 1 1;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:=E5=AE=8B=E4=BD=93;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DZH-CN link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><span lang=3DEN-US =
style=3D'font-size:10.5pt;font-family:"Calibri","sans-serif";
color:#1F497D'>thanks<o:p></o:p></span></p>

<p class=3DMsoNormal><span lang=3DEN-US =
style=3D'font-size:10.5pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0cm 0cm 0cm'>

<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt'>=E5=8F=91=E4=BB=B6=E4=BA=BA<span =
lang=3DEN-US>:</span></span></b><span
lang=3DEN-US style=3D'font-size:10.0pt'> Steve Midgley =
[mailto:science@misuse.org] <br>
</span><b><span =
style=3D'font-size:10.0pt'>=E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4<span =
lang=3DEN-US>:</span></span></b><span
lang=3DEN-US style=3D'font-size:10.0pt'> 2016</span><span =
style=3D'font-size:10.0pt'>=E5=B9=B4<span
lang=3DEN-US>4</span>=E6=9C=88<span lang=3DEN-US>7</span>=E6=97=A5<span =
lang=3DEN-US> 12:46<br>
</span><b>=E6=94=B6=E4=BB=B6=E4=BA=BA<span =
lang=3DEN-US>:</span></b><span lang=3DEN-US> =
</span>=E6=9D=8E=E5=98=89<span
lang=3DEN-US><br>
</span><b>=E6=8A=84=E9=80=81<span lang=3DEN-US>:</span></b><span =
lang=3DEN-US> postgres list<br>
</span><b>=E4=B8=BB=E9=A2=98<span lang=3DEN-US>:</span></b><span =
lang=3DEN-US> Re: [SQL] postgresql
cpu question<o:p></o:p></span></span></p>

</div>

<p class=3DMsoNormal><span lang=3DEN-US><o:p>&nbsp;</o:p></span></p>

<div>

<div>

<div>

<p class=3DMsoNormal><span lang=3DEN-US>2016-04-06 21:37 GMT-07:00 =
</span>=E6=9D=8E=E5=98=89<span
lang=3DEN-US> &lt;<a href=3D"mailto:lijia@thunisoft.com" =
target=3D"_blank">lijia@thunisoft.com</a>&gt;:<o:p></o:p></span></p>

<div>

<div>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=3DEN-US>postgresql&nbsp; can limit the cpu =
number?<o:p></o:p></span></p>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=3DEN-US>&nbsp;<o:p></o:p></span></p>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:13.85pt;background:white'><span =
lang=3DEN-US><o:p>&nbsp;</o:p></span></p>

</div>

</div>

<div>

<p class=3DMsoNormal><span lang=3DEN-US>One method: <a
href=3D"https://www.commandprompt.com/blogs/alexey_klyukin/2012/06/bindin=
g_postgresql_server_to_specific_cpu_cores_in_linux/">https://www.commandp=
rompt.com/blogs/alexey_klyukin/2012/06/binding_postgresql_server_to_speci=
fic_cpu_cores_in_linux/</a>&nbsp;<o:p></o:p></span></p>

</div>

</div>

</div>

</div>

</div>

</body>

</html>

------=_NextPart_000_0028_01D190DB.DACCD6B0--