On 12/22/2017 05:46 PM, Timokhin Maxim wrote:
>
> Hello! We have a large table 11GB ( about 37 million records ) and we
> need to alter a table - add a new column with default values is
> false. Also 'NOT NULL' is required.
>
> So, first I've done:
>
> ALTER TABLE clusters ALTER COLUMN "is_paid"
Hello,
Does the tale have foreign keys, if not you could create another table may be
unlogged and then do the changes you want via INSERT ... SELECT; and finally
convert the unlogged table to logged table.
In addition to that there are several ways to increase data writing performance
for exam
