Re: Index creation time and distribution

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, May 22, 2008 at 6:32 AM, Guillaume Smet
<guillaume.smet@xxxxxxxxx> 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?


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux