Skip site navigation (1) Skip section navigation (2)

Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Eduardo Almeida <edalmeida(at)yahoo(dot)com>,Jan Wieck <JanWieck(at)yahoo(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks
Date: 2004-04-22 18:20:47
Message-ID: 1082658047.4524.0.camel@yarrow.bertheau.de (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
В Чтв, 22.04.2004, в 17:54, Tom Lane пишет:
> Eduardo Almeida <edalmeida(at)yahoo(dot)com> writes:
> > About 7hs:30min to load the data and 16:09:25 to
> > create the indexes
> 
> You could probably improve the index-create time by temporarily
> increasing sort_mem.  It wouldn't be unreasonable to give CREATE INDEX
> several hundred meg to work in.  (You don't want sort_mem that big
> normally, because there may be many sorts happening in parallel,
> but in a data-loading context there'll just be one active sort.)

Doesn't this provide a reason for CREATE INDEX not to honour sort_mem?

-- 
Markus Bertheau <twanger(at)bluetwanger(dot)de>


In response to

Responses

pgsql-performance by date

Next:From: Bruce MomjianDate: 2004-04-22 18:31:22
Subject: Re: Wierd context-switching issue on Xeon patch for 7.4.1
Previous:From: Josh BerkusDate: 2004-04-22 18:11:43
Subject: Re: Wierd context-switching issue on Xeon patch for 7.4.1

pgsql-advocacy by date

Next:From: Tom LaneDate: 2004-04-22 19:22:51
Subject: Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks
Previous:From: Josh BerkusDate: 2004-04-22 18:19:55
Subject: Press Release Party

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group