Hello All.
I have a table with ca. 100.000.000 records. The main idea is make
Partitioning for this table (1000 or 1 tables).
Let's take for example.
CREATE TABLE test
(
id integer,
data date not null default now()
)
WITHOUT OIDS;
CREATE TABLE test00 ( CHECK ( id%100 = 0 ) ) INHERITS (te
2.3% 0:26.29 24%
124 postgres 1520M 1306M16% 0:03.05 5.0%
How to encrease postgresql speed? Why postgres took only 5.0% of CPU time?
Nurlan Mukhanov
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
