Re: Index creation time and distribution

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index creation time and distribution
Date: 2008-05-22 16:50:33
Message-ID: dcc563d10805220950i25b51461qdc4baa26777d46a7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, May 22, 2008 at 6:32 AM, Guillaume Smet
<guillaume(dot)smet(at)gmail(dot)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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Smet 2008-05-22 18:34:39 Re: Index creation time and distribution
Previous Message Matthew Wakeling 2008-05-22 14:10:06 Re: Index creation time and distribution