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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
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 19:22:51
Message-ID: 9413.1082661771@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
Markus Bertheau <twanger(at)bluetwanger(dot)de> writes:
>> 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?

Already done for 7.5.

http://archives.postgresql.org/pgsql-committers/2004-02/msg00025.php

			regards, tom lane

In response to

pgsql-performance by date

Next:From: scott.marloweDate: 2004-04-22 21:16:41
Subject: Re: Setting Shared Buffers , Effective Cache, Sort Mem
Previous:From: Pailloncy Jean-GĂ©rardDate: 2004-04-22 18:46:51
Subject: Re: 225 times slower

pgsql-advocacy by date

Next:From: Peter EisentrautDate: 2004-04-22 20:48:54
Subject: Re: Press Release Party
Previous:From: Markus BertheauDate: 2004-04-22 18:20:47
Subject: Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks

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