I would like to use P* to store files. These files will probably range from 500K to 2 MB in size and there will be thousands upon thousands of them. I was wondering how P* stores blobs,
Either as bytea or a large object.
if it is all
in one file, or if each blob is sored in it's own file. The reason being, I know that windows has a 2 GB limit on files,
PostgreSQL automatically splits its files into 1GB segments also I think the 2GB limit is only on FAT32 not NTFS but I am not sure.
and if they are
not stored as their own files, I'll hit my limit FAST... and it'll do me no good... If this is going to be a problem, does anyone have any suggestions?
bytea works well for small files as long as you are not going to do a :
select * from foo
where foo is going to return 500,000 records all with 500k files. If you are going to do something like that use large objects intead.
Sincerely, Joshua D. Drake Command Prompt, Inc.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
-- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedication Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
