[lkml]   [2000]   [Jan]   [27]   [last100]   RSS Feed
Views: [wrap][no wrap]   [headers]  [forward] 
Messages in this thread
SubjectRe: 2GB limit (more info)?
In <> Catalin BOIE ( 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
Please read the FAQ at

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