Re: WIP: Fast GiST index build
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexander Korotkov <aekorotkov@gmail.com>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-07-08T14:18:05Z
Lists: pgsql-hackers
Alexander Korotkov <aekorotkov@gmail.com> writes: > I found that results of previous tests with USNOA2 were not fully correct. > Tables for tests with various parameters contained tuples in different > order. I assumed that query > CREATE TABLE tab2 AS (SELECT * FROM tab1); > creates tab2 as exact copy of tab1, i.e. tab2 contain tuples in same order > as tab1. But actually, it isn't always so. In aggregate with only few used > test cases it can cause significant error. For test purposes, you could turn off synchronize_seqscans to prevent that. regards, tom lane