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

Re: Index creation time and distribution

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index creation time and distribution
Date: 2008-05-22 18:34:39
Message-ID: 1d4e0c10805221134u50793d5ew7d9f1031cd0ad944@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, May 22, 2008 at 6:50 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2008-05-22 19:18:00
Subject: Re: Index creation time and distribution
Previous:From: Scott MarloweDate: 2008-05-22 16:50:33
Subject: Re: Index creation time and distribution

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