复制CREATE TABLE foo ( aid bigint NOT NULL,大分读 bid bigint NOT NULL ); ALTER TABLE foo ADD CONSTRAINT foo_pkey PRIMARY KEY (aid, bid); CREATE INDEX foo_bid_idx ON foo(bid); INSERT INTO foo (aid, bid) SELECT i, i / 10000 FROM generate_series(1, 20000000) AS i; VACUUM (ANALYZE) foo; 1.2.3.4.5.6.7.8.9.10.11.
喜欢
讨厌