PDA

View Full Version : file size can cause problems ?



piapancudo
08-03-2010, 02:16 PM
Hello,

I just wanna know if u try to import a huge .txt file(e-mailed HHs), will the size of the file cause problems or errors on importing ?

If yes, whats a good size for a file to be imported without problems ?

Patvs
08-03-2010, 06:20 PM
It's partly memory related: how much RAM you have and how much RAM you assign to SQL in postgresql.conf

But .txt files larger than 50 MB will cause problems.
If you edit the postgresql.conf I'm sure you can import 200-300 MB .txt files.

It shouldn't cause import errors. It should just cause you computer to crash as your computer eventually runs out of memory.

The smaller the file the better. <1 MB.
Though 10 MB .txt shouldn't give any problems.