lkml.org 
[lkml]   [2000]   [Jan]   [27]   [last100]   RSS Feed
Views: [wrap][no wrap]   [headers]  [forward] 
 
Messages in this thread
/
From
Date
SubjectRe: 2GB limit (more info)?
In <Pine.LNX.4.20.0001271309430.19661-100000@marte.Deuroconsult.ro> Catalin BOIE (util@deuroconsult.ro) wrote:
> Hi!

> Thanks for your answers!

> I want to use mysql or postgresql for this task.
> If I understand corectly, on a i386 machine, there is a limit of 2GB for a
> file on ext2 (at least).

Ext2 is not relevant here. Since VFS in 2.2.x does not support files with
more then 2GiB size you can not have such files with ANY filesystem.

> So, to accomplish the task I must use more tables with maximum size of
> 2GB.

Exactly. Each table should be under 2GiB in size but full database can be much
bigger. About mysql/postgresql... MySQL is VERY fast on small and medium sized
databases but it's not very suited to handle REALLY large ones: I've seen
big performance drop after 500'000-1'000'000 records in table (sometimes even
100'000 was enough). Not know about postgresql...




-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
the body of a message to majordomo@vger.rutgers.edu
Please read the FAQ at http://www.tux.org/lkml/

\
 
 \ /
  Last update: 2005-03-22 13:56    [W:0.454 / U:0.364 seconds]
©2003-2020 Jasper Spaans|hosted at Digital Ocean and TransIP|Read the blog|Advertise on this site