Re: why postgresql over other RDBMS - Mailing list pgsql-general

From PFC
Subject Re: why postgresql over other RDBMS
Date
Msg-id op.ts7nm6mocigqcu@apollo13
Whole thread Raw
In response to Re: why postgresql over other RDBMS  (Vivek Khera <vivek@khera.org>)
Responses Re: why postgresql over other RDBMS
Re: why postgresql over other RDBMS
List pgsql-general
On Thu, 31 May 2007 22:20:09 +0200, Vivek Khera <vivek@khera.org> wrote:

>
> On May 25, 2007, at 5:28 PM, Tom Lane wrote:
>
>> That's true at the level of DDL operations, but AFAIK we could
>> parallelize table-loading and index-creation steps pretty effectively
>> --- and that's where all the time goes.
>
> I would be happy with parallel builds of the indexes of a given table.
> That way you have just one scan of the whole table to build all its
> indexes.

    Will the synchronized seq scan patch be able to do this by issuing all
the CREATE INDEX commands at the same time from several different database
connections ?

pgsql-general by date:

Previous
From: Ray Stell
Date:
Subject: Re: jdbc pg_hba.conf error
Next
From: PFC
Date:
Subject: Re: why postgresql over other RDBMS