Re: [GENERAL] TOAST, large objects, and ACIDity

2007-07-13 Thread Jim Nasby
On Jul 10, 2007, at 3:47 AM, Benoit Mathieu wrote: I want to use postgres to store data and large files, typically audio files from 100ko to 20Mo. For those files, I just need to store et retrieve them, in an ACID way. (I don't need search, or substring, or others functionnalities) I saw pos

[GENERAL] TOAST, large objects, and ACIDity

2007-07-12 Thread Benoit Mathieu
Hi all, I want to use postgres to store data and large files, typically audio files from 100ko to 20Mo. For those files, I just need to store et retrieve them, in an ACID way. (I don't need search, or substring, or others functionnalities) I saw postgres offers at least 2 method : bytea column

Re: [GENERAL] TOAST, large objects and ACIDity

2007-07-10 Thread Tomasz Ostrowski
On Tue, 10 Jul 2007, Alexander Staubo wrote: > My take: Stick with TOAST unless you need fast random access. TOAST > is faster, more consistently supported (eg., in Slony) and easier > to work with. Toasted bytea columns have some other disadvantages also: 1. It is impossible to create its valu

Re: [GENERAL] TOAST, large objects and ACIDity

2007-07-10 Thread Alexander Staubo
On 7/10/07, Benoit Mathieu <[EMAIL PROTECTED]> wrote: I saw postgres offers at least 2 method : bytea column with TOAST, or large objects API. From the documentation: All large objects are placed in a single system table called pg_largeobject. PostgreSQL also supports a storage system calle

[GENERAL] TOAST, large objects and ACIDity

2007-07-10 Thread Benoit Mathieu
Hi all, I want to use postgres to store data and large files, typically audio files from 100ko to 20Mo. For those files, I just need to store et retrieve them, in an ACID way. (I don't need search, or substring, or others functionnalities) I saw postgres offers at least 2 method : bytea column