| From: | yangjie <yangjie(at)highgo(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: hash partitioning based on v10Beta2 |
| Date: | 2017-08-29 02:44:51 |
| Message-ID: | A4CDB3DF-0FF1-4211-B808-5E3C0A958A0C@highgo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>
</head>
<body>
<style>
font{
line-height: 1.7;
}
</style>
<div style = 'font-family:"微软雅黑"; font-size: 14px; color:#000000; line-height:1.7;'>
<div>
<div><div class="input-wrap">
<div class="textarea-warp">Hi,</div><div class="textarea-warp"><br></div>
</div>
<div class="output-wrap">
<div class="text-output" id="text-output" style="top: 15px;"><span class="text-dst sentence-0">When the number of partitions and the data are more, adding new partitions, there will be some efficiency problems.</span></div></div></div>
<div><div class="output-wrap">
<div class="text-output" id="text-output" style="top: 15px;"><span class="text-dst sentence-0">I don't know how the solution you're talking about is how to implement a hash partition?</span></div></div></div>
<div><span><br></span></div>
<div id="ntes-pcmail-signature" style="font-family:'微软雅黑'">
<style type="text/css">
a#ntes-pcmail-signature-default:hover {
text-decoration: underline;
color: #199cff;
cursor: pointer;
}
a#ntes-pcmail-signature-default:active {
text-decoration: underline;
color: #246fce;
cursor: pointer;
}
</style>
<div style="font-size:14px; padding: 0; margin:0;">
<div style="font-family:"微软雅黑"; font-size: 14px; color:#000000">
<style>
font{
line-height: 1.7;
}
</style>
<div style="font-family: 微软雅黑; font-size: 14px;">
<style>
font{
line-height: 1.7;
}
</style>
<div style="font-family: 微软雅黑; font-size: 14px;">
<style>
font{
line-height: 1.7;
}
</style>
<div style="font-size: 14px;">
<style>
font{
line-height: 1.7;
}
</style>
<div style="font-size: 14px;">
<style>
font{
line-height: 1.7;
}
</style>
<div style="font-size: 14px;">
<style>
font{
line-height: 1.7;
}
</style>
<div style="font-size: 14px;">
<style>
font{
line-height: 1.7;
}
</style>
<div id="ntes-pcmail-signature-default" style="font-size: 14px; text-decoration: none;"><p class="MsoNormal" style="margin: 0cm 0cm 0.0001pt; text-align: justify; line-height: 23.8px;">---</p><p class="MsoNormal" style="margin: 0cm 0cm 0.0001pt; text-align: justify; line-height: 23.8px;">young</p><p class="MsoNormal" style="margin: 0cm 0cm 0.0001pt; text-align: justify; line-height: 23.8px;">HighGo Database: <a href="http://www.highgo.com">http://www.highgo.com</a></p></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div><br>
</div><div class="J-reply" style="background-color:#f2f2f2;color:black;padding-top:6px;padding-bottom:6px;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;margin-top:45px;margin-bottom:20px;font-family:'微软雅黑';">
<div style="font-size:14px;line-height:1.5;word-break:break-all;margin-left:10px;margin-right:10px">On <span class="mail-date">8/28/2017 22:25</span>，<a class="mail-to" style="text-decoration:none;color:#2a83f2;" href="mailto:robertmhaas(at)gmail(dot)com">Robert Haas<robertmhaas(at)gmail(dot)com></a> wrote： </div>
</div>
<blockquote id="ntes-pcmail-quote" style="margin: 0; padding: 0; font-size: 14px; font-family: '微软雅黑';">
On Sat, Aug 26, 2017 at 12:40 AM, yangjie(at)highgo(dot)com <yangjie(at)highgo(dot)com> wrote:
<br>> A partition table can be create as bellow:
<br>>
<br>> CREATE TABLE h1 PARTITION OF h;
<br>> CREATE TABLE h2 PARTITION OF h;
<br>> CREATE TABLE h3 PARTITION OF h;
<br>
<br>This syntax is very problematic for reasons that have been discussed
<br>on the existing hash partitioning thread. Fortunately, a solution has
<br>already been implemented... you're the third person to try to write a
<br>patch for this feature.
<br>
<br>--
<br>Robert Haas
<br>EnterpriseDB: http://www.enterprisedb.com
<br>The Enterprise PostgreSQL Company
<br></blockquote><!--😀-->
</div>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 4.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-08-29 02:59:29 | Re: hash partitioning based on v10Beta2 |
| Previous Message | Tom Lane | 2017-08-29 02:26:24 | Re: Re: [COMMITTERS] pgsql: pg_rewind: Fix some problems when copying files >2GB. |