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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Radu Ilie | 2011-01-26 13:49:21 | BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore |
Previous Message | Tom Lane | 2011-01-26 03:03:48 | Re: Multicolun index creation never completes on 9.0.1/solaris |