Messages in this thread | | | From | "Khimenko Victor" <> | Date | Thu, 27 Jan 2000 15:11:36 +0300 (MSK) | Subject | Re: 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/
| |