Postgres database three types of speed comparison for creating statements

1. Number of records in table: 1578463

Select COUNT (*) from Reorder_guideline; Count---------1578463 (1 Row Records)

2. three statements creating tables CREATE TABLE:

(1) most commonly used (23171.485ms)

A1stream_db=> CREATE table reorder_guideline_2 as table reorder_guideline; Time: 23171.485 ms

(2) with unlogged logo (1734.085ms)

Create unlogged table reorder_guideline_2 as table reorder_guideline; Time: 1734.085 ms

(3) temporary table with temp ID (1666.934ms)

Create temp table reorder_guideline_2 as table reorder_guideline; Time: 1666.934 ms

Postgres database three types of speed comparison for creating statements