Re: What does "Table rewrite" mean?

2018-01-20 Thread Alvaro Herrera
Michael Paquier wrote: > On Fri, Jan 19, 2018 at 11:33:43AM -0500, Tom Lane wrote: > > It means reading the whole table and writing it out in some modified > > form (for instance, with some column transformed into a new datatype). > > It's not "dangerous" in any way ... but if you've got many GB of

Re: Correction of intermediate certificate handling

2018-01-20 Thread Bruce Momjian
On Thu, Jan 18, 2018 at 12:17:40PM +0900, Michael Paquier wrote: > On Wed, Jan 17, 2018 at 09:00:17PM -0500, Bruce Momjian wrote: > > On Thu, Jan 18, 2018 at 10:25:03AM +0900, Michael Paquier wrote: > > > /etc/ssl/openssl.cnf is not available on macos or Windows, which can > > > lead to a bit of co

Re: overlapping ranges

2018-01-20 Thread Peter Eisentraut
On 1/20/18 15:58, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/ddl-partitioning.html > Description: > > In the date partitioning example the first and last dates are the first of > the month,

overlapping ranges

2018-01-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/ddl-partitioning.html Description: In the date partitioning example the first and last dates are the first of the month, which will cause conflicts. The last date needs to be the fi

Re: What does "Table rewrite" mean?

2018-01-20 Thread Michael Paquier
On Fri, Jan 19, 2018 at 11:33:43AM -0500, Tom Lane wrote: > It means reading the whole table and writing it out in some modified > form (for instance, with some column transformed into a new datatype). > It's not "dangerous" in any way ... but if you've got many GB of data in > the table and you ca