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.022 / U:1.140 seconds]
    ©2003-2016 Jasper Spaans. hosted at Digital OceanAdvertise on this site