Project

General

Profile

Actions

Feature #4276

closed

Test database conversion time

Added by Pavel Kácha over 4 years ago. Updated almost 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Development - Core
Target version:
Start date:
08/21/2018
Due date:
% Done:

100%

Estimated time:
To be discussed:
No

Description

Find out rough times to prepare migration:
  • crate new table
  • alter table old jsonb NULL
  • repeat: select old jsonb into new jsonb limit XXX; until done
  • alter table drop old jsonb
  • vacuum
  • cluster

Related issues

Blocked by Mentat - Feature #4275: Split jsonb column into its own tableClosedPavel Kácha

Actions
Actions

Also available in: Atom PDF