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

From Scott Marlowe
Subject Re: Index creation time and distribution
Date
Msg-id dcc563d10805220950i25b51461qdc4baa26777d46a7@mail.gmail.com
Whole thread Raw
In response to Index creation time and distribution  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Responses Re: Index creation time and distribution
List pgsql-performance
On Thu, May 22, 2008 at 6:32 AM, Guillaume Smet
<guillaume.smet@gmail.com> wrote:
> Hi -performance,
>
>
> LOG:  duration: 1636301.317 ms  statement: CREATE INDEX
> index_journal_clazz ON journal USING btree (clazz);
> LOG:  duration: 20613.009 ms  statement: CREATE INDEX
> index_journal_date ON journal USING btree (date);

Just curious, what happens if you create the date index first, then
the clazz one?

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Index creation time and distribution
Next
From: "Guillaume Smet"
Date:
Subject: Re: Index creation time and distribution