Great Idea! When I get that far, I will try it.
Gaetano Mendola wrote:
For partion in some way I don't mean only split it in more tables. You
can use some available tools in postgres and continue to see this table
as one but implemented behind the scenes with more tables.
One usefull and impressiv
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dennis Gearon wrote:
| Gaetano Mendola wrote:
|
|> Dennis Gearon wrote:
|>
|>> I am designing something that may be the size of yahoo, google, ebay,
|>> etc.
|>>
|>> Just ONE many to many table could possibly have the following
|>> characteristics:
|>>
Dennis Gearon wrote:
I am designing something that may be the size of yahoo, google, ebay, etc.
Just ONE many to many table could possibly have the following
characteristics:
3,600,000,000 records
This is a really huge monster one, and if you don't partition that
table in some way I think you'
On 21. okt 2004, at 01:30, Dennis Gearon wrote:
I am designing something that may be the size of yahoo, google, ebay,
etc.
Grrr. Geek wet-dream.
Just ONE many to many table could possibly have the following
characteristics:
3,600,000,000 records
each record is 9 fields of INT4/DATE
I don't
On Wed, 2004-10-20 at 23:01 -0700, Joshua D. Drake wrote:
> Dennis Gearon wrote:
>
> > Google probably is much bigger, and on mainframes, and probably Oracle
> > or DB2.
>
> Google uses a Linux cluster and there database is HUGE. I do not know
> which database
> they use. I bet they built their
Actually, now that I think about it, they use a special table type that the INDEX is
also the DATUM. It is possible to recover the data, out of the index listing. So go
down the index, then decode the indexing value - voila, a whole step saved. I have no
idea what engine these table types are in
Dennis Gearon wrote:
Google probably is much bigger, and on mainframes, and probably Oracle
or DB2.
Google uses a Linux cluster and there database is HUGE. I do not know
which database
they use. I bet they built their own specifically for what they do.
Sincerely,
Joshua D. Drake
But the table I
Google probably is much bigger, and on mainframes, and probably Oracle or DB2.
But the table I am worried about is the one sized >= 3.6 GIGA records.
Tino Wildenhain wrote:
Hi,
Am Do, den 21.10.2004 schrieb Dennis Gearon um 1:30:
I am designing something that may be the size of yahoo, google, ebay,
Hi,
Am Do, den 21.10.2004 schrieb Dennis Gearon um 1:30:
> I am designing something that may be the size of yahoo, google, ebay, etc.
>
> Just ONE many to many table could possibly have the following
> characteristics:
>
> 3,600,000,000 records
> each record is 9 fields of INT4/DATE
>
I am designing something that may be the size of yahoo, google, ebay, etc.
Just ONE many to many table could possibly have the following
characteristics:
3,600,000,000 records
each record is 9 fields of INT4/DATE
Other tables will have about 5 million records of about the same size.
There a
10 matches
Mail list logo