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

Re: CREATE INDEX rather sluggish

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gavin Hamill <gdh(at)laterooms(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: CREATE INDEX rather sluggish
Date: 2006-03-30 15:19:13
Message-ID: 14852.1143731953@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Gavin Hamill <gdh(at)laterooms(dot)com> writes:
> The table has just under six million rows - should it really be taking 
> nearly six minutes to add an index?

Try running it with trace_sort enabled to get more info about where the
time is going.

We've been doing some considerable work on the sorting code in the last
couple months, so 8.2 should be better, but I'd like to verify that
you're not seeing something we don't know about.

> maintenance_work_mem = 262144

Fooling with this might affect the results some.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2006-03-30 15:24:23
Subject: Re: Index scan startup time
Previous:From: Peter EisentrautDate: 2006-03-30 15:16:13
Subject: Re: Index scan startup time

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