crash.sql

application/sql

Filename: crash.sql

Type: application/sql

Part: 1

Message: Re: [HACKERS] [PATCH] Incremental sort

CREATE TABLE t (a int, b int, c int, d int, e int);
INSERT INTO t SELECT 10*random(), 10*random(), 10*random(), 10*random(), 10*random() FROM generate_series(1,1000000);
VACUUM ANALYZE t;
SELECT * FROM (SELECT * FROM t ORDER BY a) foo ORDER BY a, b;