[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-announce
Subject: pg_partman 5.1.0 & 4.8.0 released
From: Crunchy Data via PostgreSQL Announce <announce-noreply () postgresql ! org>
Date: 2024-04-06 22:43:25
Message-ID: 171244340515.683.5132146684622534011 () wrigleys ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Crunchy Data is proud to announce the release of pg_partman 5.1.0 & 4.8.0.
Highlights of this release
Version 5.1.0 April 2, 2024
* Support LIST partitioning for single value integers.
* EXPERIMENTAL support for partitioning based on numeric values
* Allow explicit ordering of partition set maintenance
* Properly inherit tablespaces
Further changes and bug fixes can be found in the CHANGELOG
Version 4.8.0
* Fix the partition_gap_fill() function to allow skipping the analyze step. Note \
this is not an option in 5.x since the analyze step was refactored and never runs \
automatically during a call to the gap fill function anymore.
* Note that there is no way to directly install version 4.8.0. A prior version must \
be installed first and then upgraded to 4.8.0. It is recommended that you migrate to \
the latest major version for continued support of pg_partman.
About pg_partman
pg_partman is an extension to create and manage both time-based and number-based \
table partition sets. As of version 5.0.0, only built-in, declarative partitioning is \
supported and the older trigger-based methods have been deprecated.
The declarative partitioning built into PostgreSQL provides the commands to create a \
partitioned table and its children, but it does not provide a means of automating \
that child table maintenance over time (Ex. adding new children, dropping old ones \
based on a retention policy). It also does not provide a means to easily turn an \
existing table into a partitioned table or vice versa. pg_partman aims to use the \
built-in declarative features that PostgreSQL provides, but build upon them to \
provide those missing features as well as many others to help make managing \
partitions easier.
Please submit issues or pull requests for any issues encountered. General questions \
can be submitted to discussions.
Links:
Website - [https://github.com/pgpartman/pg_partman](https://github.com/pgpartman/pg_partman)
Installation - [https://github.com/pgpartman/pg_partman#installation](https://github.com/pgpartman/pg_partman#installation)
Documentation - [https://github.com/pgpartman/pg_partman/blob/master/doc/pg_partman.md](https://github.com/pgpartman/pg_partman/blob/master/doc/pg_partman.md)
Release Notes - [https://github.com/pgpartman/pg_partman/blob/master/CHANGELOG.txt](https://github.com/pgpartman/pg_partman/blob/master/CHANGELOG.txt)
Crunchy Data - [https://www.crunchydata.com](https://www.crunchydata.com)
Crunchy Data is proud to support the development and maintenance of pg_partman.
[Attachment #5 (text/html)]
<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>pg_partman 5.1.0 & 4.8.0 released</title>
<style>
@media only screen and (max-width: 620px) {
table[class=body] h1 {
font-size: 28px !important;
margin-bottom: 10px !important;
}
table[class=body] p,
table[class=body] ul,
table[class=body] ol,
table[class=body] td,
table[class=body] span,
table[class=body] a {
font-size: 16px !important;
}
table[class=body] .wrapper,
table[class=body] .article {
padding: 10px !important;
}
table[class=body] .content {
padding: 0 !important;
}
table[class=body] .container {
padding: 0 !important;
width: 100% !important;
}
table[class=body] .main {
border-left-width: 0 !important;
border-radius: 0 !important;
border-right-width: 0 !important;
}
table[class=body] .btn table {
width: 100% !important;
}
table[class=body] .btn a {
width: 100% !important;
}
table[class=body] .img-responsive {
height: auto !important;
max-width: 100% !important;
width: auto !important;
}
}
@media all {
.ExternalClass {
width: 100%;
}
.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
line-height: 100%;
}
.apple-link a {
color: inherit !important;
font-family: inherit !important;
font-size: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
text-decoration: none !important;
}
#MessageViewBody a {
color: inherit;
text-decoration: none;
font-size: inherit;
font-family: inherit;
font-weight: inherit;
line-height: inherit;
}
.btn-primary table td:hover {
background-color: #34495e !important;
}
.btn-primary a:hover {
background-color: #34495e !important;
border-color: #34495e !important;
}
}
</style>
</head>
<body class="" style="background-color: #f6f6f6; font-family: sans-serif; \
-webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4; margin: 0; \
padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <table \
border="0" cellpadding="0" cellspacing="0" class="body" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; \
background-color: #f6f6f6;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> <td class="container" style="font-family: sans-serif; font-size: \
14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580px; padding: \
10px; width: 580px;">
<div class="content" style="box-sizing: border-box; display: block; Margin: \
0 auto; max-width: 580px; padding: 10px;">
<span class="preheader" style="color: transparent; display: none; height: \
0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; \
visibility: hidden; width: 0;"></span> <table class="main" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: \
#ffffff; border-radius: 3px;">
<tr>
<td class="wrapper" style="font-family: sans-serif; font-size: 14px; \
vertical-align: top; box-sizing: border-box; padding: 20px;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; \
vertical-align: top;">
<div>
<h1 style="color: #000; font-family: sans-serif; line-height: 1.4; margin: 0; \
margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: \
center">pg_partman 5.1.0 & 4.8.0 released</h1> </div>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Crunchy Data is proud to announce the release of pg_partman \
5.1.0 & 4.8.0.</p> <p style="font-family: sans-serif; font-size: 14px; \
font-weight: normal; margin: 0; margin-bottom: 15px">Highlights of this release</p> \
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Version 5.1.0 April 2, 2024</p> <ul style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px"> \
<li style="list-style-position: inside; margin-left: 5px">Support LIST partitioning \
for single value integers.</li> <li style="list-style-position: inside; margin-left: \
5px">EXPERIMENTAL support for partitioning based on numeric values</li> <li \
style="list-style-position: inside; margin-left: 5px">Allow explicit ordering of \
partition set maintenance</li> <li style="list-style-position: inside; margin-left: \
5px">Properly inherit tablespaces</li> </ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Further changes and bug fixes can be found in the CHANGELOG </p> \
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Version 4.8.0</p> <ul style="font-family: sans-serif; font-size: \
14px; font-weight: normal; margin: 0; margin-bottom: 15px"> <li \
style="list-style-position: inside; margin-left: 5px">Fix the partition_gap_fill() \
function to allow skipping the analyze step. Note this is not an option in 5.x since \
the analyze step was refactored and never runs automatically during a call to the gap \
fill function anymore.</li> <li style="list-style-position: inside; margin-left: \
5px">Note that there is no way to directly install version 4.8.0. A prior version \
must be installed first and then upgraded to 4.8.0. It is recommended that you \
migrate to the latest major version for continued support of pg_partman.</li> </ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">About pg_partman</p> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">pg_partman is \
an extension to create and manage both time-based and number-based table partition \
sets. As of version 5.0.0, only built-in, declarative partitioning is supported and \
the older trigger-based methods have been deprecated.</p> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">The \
declarative partitioning built into PostgreSQL provides the commands to create a \
partitioned table and its children, but it does not provide a means of automating \
that child table maintenance over time (Ex. adding new children, dropping old ones \
based on a retention policy). It also does not provide a means to easily turn an \
existing table into a partitioned table or vice versa. pg_partman aims to use the \
built-in declarative features that PostgreSQL provides, but build upon them to \
provide those missing features as well as many others to help make managing \
partitions easier.</p> <p style="font-family: sans-serif; font-size: 14px; \
font-weight: normal; margin: 0; margin-bottom: 15px">Please submit issues or pull \
requests for any issues encountered. General questions can be submitted to \
discussions.</p> <p style="font-family: sans-serif; font-size: 14px; font-weight: \
normal; margin: 0; margin-bottom: 15px">Links:</p> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">Website - <a \
href="https://github.com/pgpartman/pg_partman" style="color: #3498db; \
text-decoration: underline">https://github.com/pgpartman/pg_partman</a></p> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Installation - <a \
href="https://github.com/pgpartman/pg_partman#installation" style="color: #3498db; \
text-decoration: underline">https://github.com/pgpartman/pg_partman#installation</a></p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Documentation - <a \
href="https://github.com/pgpartman/pg_partman/blob/master/doc/pg_partman.md" \
style="color: #3498db; text-decoration: \
underline">https://github.com/pgpartman/pg_partman/blob/master/doc/pg_partman.md</a></p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Release Notes - <a \
href="https://github.com/pgpartman/pg_partman/blob/master/CHANGELOG.txt" \
style="color: #3498db; text-decoration: \
underline">https://github.com/pgpartman/pg_partman/blob/master/CHANGELOG.txt</a></p> \
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Crunchy Data - <a href="https://www.crunchydata.com" \
style="color: #3498db; text-decoration: \
underline">https://www.crunchydata.com</a></p> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">Crunchy Data is \
proud to support the development and maintenance of pg_partman.</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="footer" style="clear: both; Margin-top: 10px; text-align: \
center; width: 100%;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td class="content-block" style="font-family: sans-serif; \
vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-size: 12px; color: \
#999999; text-align: center;">
<span class="apple-link" style="color: #999999; font-size: 12px; \
text-align: center;"> This email was sent to you from Crunchy Data. It was delivered \
on their behalf by the PostgreSQL project. Any questions about the content of the \
message should be sent to Crunchy Data.
</span>
<br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mailinglist, \
for the content tag Related Open Source.
To unsubscribe from
further emails, or change which emails you want to receive, please click the personal \
unsubscribe link that you can find in the headers of this email, or visit
<a href="https://lists.postgresql.org/unsubscribe/" style="color: #3498db; \
text-decoration: underline">https://lists.postgresql.org/unsubscribe/</a>.
</td>
</tr>
</table>
</div>
</div>
</td>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> </tr>
</table>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic