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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

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