Обсуждение: 90 million rows in one table...

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?

Thanks in advance!

--Arsalan

-------------------------------------------------
WAR IS PEACE
FREEDOM IS SLAVERY
IGNORANCE IS STRENGTH

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

Arsalan Zaidi 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..

For what it is worth, I am runnig very happily with >20M rows.


Allan.

Allan Engelhardt wrote:
> 
> Arsalan Zaidi 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..
> 
> For what it is worth, I am runnig very happily with >20M rows.

so am I

-- 
Mathieu Arnold