Re: Performance - Mailing list pgsql-general

From Richard Huxton
Subject Re: Performance
Date
Msg-id 40DA7BE2.4040409@archonet.com
Whole thread Raw
In response to Performance  ("LuisH" <luish@lh.com.br>)
List pgsql-general
LuisH wrote:
> Question about Performance:
>
> What about access sounds (WAV or VOX) from filesystem or from Blob
> Database ????????????
> Whish performance can I expect on each case ??

Filesystem access should always be faster than through the database. If
it isn't you should get a new filesystem.

You need to ask yourself:
1. Do I want transactional control over updates to these sounds?
2. Do I always want to store the files on the same machine as the database?
3. Is it easier/more difficult to read/download files vs access via the
database connection.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: clusters and database instances
Next
From: Carlos Ojea Castro
Date:
Subject: Re: psql