Re: [GENERAL] table size/record limit

2004-10-22 Thread Dennis Gearon
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

Re: [GENERAL] table size/record limit

2004-10-22 Thread Gaetano Mendola
-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: |>>

Re: [GENERAL] table size/record limit

2004-10-21 Thread Gaetano Mendola
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'

Re: [GENERAL] table size/record limit

2004-10-21 Thread David Helgason
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

Re: [GENERAL] table size/record limit

2004-10-21 Thread Robby Russell
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

Re: [GENERAL] table size/record limit

2004-10-20 Thread Dennis Gearon
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

Re: [GENERAL] table size/record limit

2004-10-20 Thread Joshua D. Drake
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

Re: [GENERAL] table size/record limit

2004-10-20 Thread Dennis Gearon
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,

Re: [GENERAL] table size/record limit

2004-10-20 Thread Tino Wildenhain
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 >

[GENERAL] table size/record limit

2004-10-20 Thread Dennis Gearon
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