From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Nelson Kotowski <nkotowski@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: TPC-H Scaling Factors X PostgreSQL Cluster Command
Date: Mon, 23 Apr 2007 10:46:45 +0100
Message-ID: <462C8085.3020602@enterprisedb.com> (raw)
In-Reply-To: <d34b24380704210754q53aa86c8l3a63211d81febbf7@mail.gmail.com>
References: <d34b24380704210754q53aa86c8l3a63211d81febbf7@mail.gmail.com>
Nelson Kotowski wrote:
> So far, i need to do it in three different scale factors (1, 2 and 5GB
> databases).
>
> My build process comprehends creating the tables without any foreign keys,
> indexes, etc. - Running OK!
> Then, i load the data from the flat files generated through DBGEN software
> into these tables. - Running OK!
>
> Finally, i run a "optimize" script that does the following:
>
> - Alter the tables to add the mandatory foreign keys;
> - Create all mandatory indexes;
> - Cluster the orders table by the orders table index;
> - Cluster the lineitem table by the lineitem table index;
> - Vacuum the database;
> - Analyze statistics.
Cluster will completely rewrite the table and indexes. On step 2, you
should only create the indexes you're clustering on, and create the rest
of them after clustering.
Or even better, generate and load the data in the right order to start
with, so you don't need to cluster at all.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: heikki@enterprisedb.com, nkotowski@gmail.com
Subject: Re: TPC-H Scaling Factors X PostgreSQL Cluster Command
In-Reply-To: <462C8085.3020602@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox