> The first log statement is expected. The second log statement, however, isn't.
> The total table size is (as noted earlier) about 5GB and, in fact, fit
> into one nice hash table (approx 15GB in size).
> Is the sorting that is necessary for index creation unable to use a
> hash table? (This is a standard btree index).
How big is the source table? You're not sorting the *result* table,
you're sorting the source table if you're summarizing it.
If the original source data is only 5GB, I'd check your code for a
PostgreSQL Experts Inc.
In response to
pgsql-performance by date
|Next:||From: Greg Matthews||Date: 2011-11-18 01:07:51|
|Subject: probably cause (and fix) for floating-point assist faults on itanium|
|Previous:||From: Tom Lane||Date: 2011-11-18 00:33:49|
|Subject: Re: external sort performance |