Re: Strange Create Index behaviour

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Strange Create Index behaviour
Date: 2006-02-15 21:27:27
Message-ID: 1140038847.12131.155.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On Wed, 2006-02-15 at 20:00 +0000, Gary Doades wrote:

> I have put together a test case

Please enable trace_sort=on and then repeat tests and post the
accompanying log file.

I think this is simply the sort taking longer depending upon the data
distribution, but I'd like to know for sure.

Thanks,

Best Regards, Simon Riggs

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-02-15 21:27:54 Re: Strange Create Index behaviour
Previous Message Gary Doades 2006-02-15 21:11:15 Re: Strange Create Index behaviour

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-02-15 21:27:54 Re: Strange Create Index behaviour
Previous Message Josh Rovero 2006-02-15 21:20:23 Re: Reliability recommendations