pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Andrzej Zawadzki <zawadaa@gmail.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Adding Column on Huge Table
Date: Tue, 19 Mar 2019 21:53:16 +0100
Message-ID: <5b26ed21-a7b5-6c1b-af10-10df4d44a4f7@gmail.com> (raw )
In-Reply-To: <HK0PR03MB2977B9460C4CC7D0383D05BDAD400@HK0PR03MB2977.apcprd03.prod.outlook.com >
References: <HK0PR03MB2977B9460C4CC7D0383D05BDAD400@HK0PR03MB2977.apcprd03.prod.outlook.com >
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 19.03.2019 16:56, Moin Akther wrote:<br>
</div>
<blockquote type="cite"
cite="mid:HK0PR03MB2977B9460C4CC7D0383D05BDAD400@HK0PR03MB2977.apcprd03.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
Dear Experts,</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
<br>
</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
We want to add a column on table size of 1.5TB, we have to
perform this activity with minimal downtime. </div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
<br>
</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
What are the best practises to add a column on huge table ?</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
<br>
</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
How much time alter statement will take to add column ?</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
<br>
</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
Any alternate solution other than alter statement to add column
?</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
<br>
</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
Will adding a new column on a huge table generate huge WAL files
?</div>
<div style="font-family: "Segoe UI", "Helvetica
Neue", sans-serif; font-size: 11pt; color: rgb(38, 114,
236);">
<br>
</div>
<div id="signature">
<div id="divtagdefaultwrapper" dir="ltr" style=""><font
face="Calibri, Arial, Helvetica, sans-serif, EmojiFont,
Apple Color Emoji, Segoe UI Emoji, NotoColorEmoji, Segoe UI
Symbol, Android Emoji, EmojiSymbols" color="#2672ec"><span
id="ms-rterangepaste-start" style="font-size: 12pt;"></span></font></div>
</div>
</blockquote>
<p>No offense, but don't you have any test environment?</p>
<p>Try that or maybe you have so show times.</p>
<p><br>
</p>
<p>-- <br>
</p>
<p>Andrzej Zawadzki<br>
</p>
</body>
</html>
view thread (6+ messages) latest in thread
Message-ID: <5b26ed21-a7b5-6c1b-af10-10df4d44a4f7@gmail.com>
Permalink: ../5b26ed21-a7b5-6c1b-af10-10df4d44a4f7@gmail.com/
Also on: postgresql.org/message-id/5b26ed21-a7b5-6c1b-af10-10df4d44a4f7@gmail.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: zawadaa@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Adding Column on Huge Table
In-Reply-To: <5b26ed21-a7b5-6c1b-af10-10df4d44a4f7@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox