Re: Huge number of raws

From: Anton Nikiforov <anton(at)nikiforov(dot)ru>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Huge number of raws
Date: 2004-03-18 17:58:39
Message-ID: 4059E34F.2@nikiforov.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Bruno and thanks for your replay.
But how PostgreSQL could deal with 1E11 (billions) records in the table?
Do you know how insers will be processed (slow insert problem)?
I have a database with already 50 millions of records (i just doubled my
25 million database) to check how Postgres will fill itself and it is
just OK with inserts, even updates.
But my database is 1000 times smaler than the one planned.
Maybe someone did test the database with such a huge amount of records,
or somebody from develpers could estimate the situation?
I disciver almost all internet :) To find someone having such an amount
of data in the database, but was not sucsseeded with this.

Regards,
Anton

Bruno Wolff III ?????:

>On Thu, Mar 18, 2004 at 11:59:41 +0300,
> Anton Nikiforov <anton(at)nikiforov(dot)ru> wrote:
>
>
>>And one more question - is there in postgress something like table
>>partitioning in Oracle to store data according to the some rules, like a
>>group of data source (IP network or something)?
>>
>>
>
>There isn't currently a partitioning tool. Some table space features
>are being developed for 7.5.
>
>Depending on what you really are trying to accomplish there are some
>things you can do now. Partial indexes get be used to speed up index
>searches over a subset of rows in a table. You can also use sym links
>to move tables on to different file systems, but you need to be careful
>when doing this.
>
>
>
>
>

--
? ????????? (Best regads),
????? ????????? (Anton Nikiforov)

???.(Tel.): +7 095 7814200
????(Fax) : +7 095 7814201
???.(Cell): +7 905 7245310

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ericson Smith 2004-03-18 18:26:59 Re: Opteron build process question
Previous Message Bruno Wolff III 2004-03-18 17:44:40 Re: Huge number of raws