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

Re: Multicolun index creation never completes on 9.0.1/solaris

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Multicolun index creation never completes on 9.0.1/solaris
Date: 2011-01-26 03:09:52
Message-ID: 14811.1296011392@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Josh Berkus <josh(at)agliodbs(dot)com> writes:
> Well, for the straight test on event_time, the rows in the table should
> have been more-or-less physically already in order.  This table is
> most-insert, and event_time mostly corresponds to current server time.

That would result in a very long initial run (probably all or most of
the data), which fits with your observation so far.  But we don't know
what happens after that.

BTW, are you paying attention to vmstat or similar measure of the amount
of I/O and CPU work getting done?  vmstat data ought to make it possible
to estimate the size of those runs, even though the trace_sort logic
isn't telling us.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Radu IlieDate: 2011-01-26 13:49:21
Subject: BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore
Previous:From: Tom LaneDate: 2011-01-26 03:03:48
Subject: Re: Multicolun index creation never completes on 9.0.1/solaris

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