Re: problem with large maintenance_work_mem settings and

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: problem with large maintenance_work_mem settings and
Date: 2006-03-08 15:45:09
Message-ID: 14703.1141832709@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> writes:
> CREATE INDEX on a 1,8B row table (5 int columns - index created on the
> first row about 300M distinct values):

> before: 11h 51min
> after: 3h 11min(!)

Cool. Does it seem to be I/O bound now? Would you be willing to do it
over with oprofile turned on?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2006-03-08 15:47:21 Add switches for DELIMITER and NULL in pg_dump COPY
Previous Message Stefan Kaltenbrunner 2006-03-08 15:35:11 Re: problem with large maintenance_work_mem settings and