Re: Index creation time and distribution - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: Index creation time and distribution
Date
Msg-id 1d4e0c10805221134u50793d5ew7d9f1031cd0ad944@mail.gmail.com
Whole thread Raw
In response to Re: Index creation time and distribution  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
On Thu, May 22, 2008 at 6:50 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> Just curious, what happens if you create the date index first, then
> the clazz one?

It's not due to any cache effect if it's your question. It's mostly
CPU time and changing the order doesn't change the behaviour.

I'll make some tests with 8.3 in a few weeks (I'll be out of town next
week) to see if using PostgreSQL qsort reduces the problem.

--
Guillaume

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Index creation time and distribution
Next
From: Tom Lane
Date:
Subject: Re: Index creation time and distribution