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

Re: 90 million rows in one table...

From: Horst Herb <hherb(at)malleenet(dot)net(dot)au>
To: "Arsalan Zaidi" <azaidi(at)directi(dot)com>
Cc: "PostgreSQL" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: 90 million rows in one table...
Date: 2001-09-20 11:41:34
Message-ID: 0109202141341K.01860@munin.gnumed.dhs.org (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Thursday 20 September 2001 17:35, you wrote:
> Hi
>
> We're writing an application which is going to create a table with around
> 90 million rows...
>
> Has anyone done something like this with PostgreSQL? Will the DB run, or
> will it choke..
>
>
> In addition, what kind of effect does turning multi-byte support have on
> database stability and speed? Any repercussions at all?

Why don't you just try? Create a dummy data base, dummy table and fill it 
with dummy data to get some real life timings on your own hardware. Wouldn't 
take more than one afternoon to do a little bit of testing

Horst

In response to

pgsql-interfaces by date

Next:From: Allan EngelhardtDate: 2001-09-20 12:41:47
Subject: Re: 90 million rows in one table...
Previous:From: Arsalan ZaidiDate: 2001-09-20 07:35:51
Subject: 90 million rows in one table...

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