hi,
I got the same result after work_mem = 64,
but I can get to D5 and D6 after using bigger data sample (at least 10
records) as Tom said!
2014-07-19 6:35 GMT+08:00 土卜皿 pengcz.n...@gmail.com:
2014-07-19 6:26 GMT+08:00 Tom Lane t...@sss.pgh.pa.us:
=?UTF-8?B?5Zyf5Y2c55q/?=
hi, all
for studying polyphase merge algorithm of tuplesort.c, I use ddd and
apend a table, which has a schema as follows:
CREATE TABLE Towns (
id SERIAL UNIQUE NOT NULL,
code VARCHAR(10) NOT NULL, -- Only unique inside a department
article TEXT,
name TEXT NOT NULL, -- Names are not
=?UTF-8?B?5Zyf5Y2c55q/?= pengcz.n...@gmail.com writes:
for studying polyphase merge algorithm of tuplesort.c, I use ddd and
apend a table, which has a schema as follows:
...
and has 36684 records, and every record is like:
id code article name department
31800266\N
2014-07-19 6:26 GMT+08:00 Tom Lane t...@sss.pgh.pa.us:
=?UTF-8?B?5Zyf5Y2c55q/?= pengcz.n...@gmail.com writes:
for studying polyphase merge algorithm of tuplesort.c, I use ddd and
apend a table, which has a schema as follows:
...
and has 36684 records, and every record is like:
id