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

Re: Performance while loading data and indexing

From: "Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com>
To: <shridhar_daithankar(at)persistent(dot)co(dot)in>,<pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance while loading data and indexing
Date: 2002-09-26 09:17:50
Message-ID: 4D618F6493CE064A844A5D496733D6670390D4@freedom.icomedias.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On 26 Sep 2002 at 14:05, Shridhar Daithankar wrote:
> Some time back I posted a query to build a site with 150GB of database. In
last 
> couple of weeks, lots of things were tested at my place and there are some 
> results and again some concerns. 

> 2) Creating index takes huge amount of time.
> Load time: 14581 sec/~8600 rows persec/~ an MB of data per sec.
> Create unique composite index on 2 char and a timestamp field:  25226 sec.
> Database size on disk: 26GB
> Select query: 1.5 sec. for approx. 150 rows.

I never tried 150GB of data, but 10GB of data, and this worked fine for me. 
Maybe it will help if you post your table schema, including which indexes you
use, and the average size of one tuple.


Responses

pgsql-hackers by date

Next:From: Shridhar DaithankarDate: 2002-09-26 09:31:35
Subject: Re: [HACKERS] Performance while loading data and indexing
Previous:From: Justin CliftDate: 2002-09-26 09:17:32
Subject: Re: Performance while loading data and indexing

pgsql-general by date

Next:From: Shridhar DaithankarDate: 2002-09-26 09:31:35
Subject: Re: [HACKERS] Performance while loading data and indexing
Previous:From: Justin CliftDate: 2002-09-26 09:17:32
Subject: Re: Performance while loading data and indexing

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