[PERFORM] TPC-H Scaling Factors X PostgreSQL Cluster Command

2007-04-21 Thread Nelson Kotowski
Hello everyone, This is my first post in here, i am in need of some help... Wel, i am running PostgreSQL 8.2.4, in a single node, in this machine: Dell PowerEdge 1950 Intel Xeon 2.33 (2 CPUs) 4GB RAM Sata HD 160GB Debian Distribution Some relevant parameters: In Linux: -> SHMMAX: 32MB In pos

Re: [PERFORM] TPC-H Scaling Factors X PostgreSQL Cluster Command

2007-04-23 Thread Nelson Kotowski
EMAIL PROTECTED]> wrote: 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 f