Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Guillaume SmetDate: 2008-05-22 18:34:39
Subject: Re: Index creation time and distribution
Previous:From: Matthew WakelingDate: 2008-05-22 14:10:06
Subject: Re: Index creation time and distribution

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group