Re: Storing Digital Video

От: Matt Davies | Postgresql List
Тема: Re: Storing Digital Video
Дата: ,
(см: обсуждение, исходный текст)
Ответ на: Storing Digital Video  (Rodrigo Madera)
Список: pgsql-performance

Скрыть дерево обсуждения

Storing Digital Video  (Rodrigo Madera, )
 Re: Storing Digital Video  (Matt Davies | Postgresql List, )
 Re: Storing Digital Video  ("Jeffrey W. Baker", )
 Re: Storing Digital Video  (Albert Cervera Areny, )
  Re: Storing Digital Video  (Nate Byrnes, )
   Re: Storing Digital Video  ("Craig A. James", )
    Re: Storing Digital Video  (Nate Byrnes, )
    Re: Storing Digital Video  ("Jim C. Nasby", )
     Re: Storing Digital Video  (Jan Peterson, )
      Re: Storing Digital Video  ("Jim C. Nasby", )

Rodrigo Madera wrote:

>I am concerned with performance issues involving the storage of DV on
>a database.
>I though of some options, which would be the most advised for speed?
>1) Pack N frames inside a "container" and store the container to the db.
>2) Store each frame in a separate record in the table "frames".
>3) (type something here)
>Thanks for the help,

My experience has been that this is a very bad idea. Many people want to
store all sorts of data in a database such as email messages, pictures,
etc... The idea of a relational database is to perform queries against
data. If you are needing to just store data then store it on a disk and
use the database as the indexer of the data.

Keep in mind the larger the database the slower some operations become.

Unless you are operating on the frame data (which you either store as
blobs or hex-encoded data) I'd recommend you store the data on a hard
drive and let the database store meta data about the video such as path
information, run time, author, etc...

We do this on an application storing close to a million images and the
performance is impressive.
    1. we don't have to do any sort of data manipulation storing the
data in or retrieving the data out of the database.
    2. our database is compact and extremely fast  - it is using the
database for what it was designed for - relational queries.

My $0.02

>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match

В списке pgsql-performance по дате сообщения:

От: "Luke Lonergan"
Сообщение: Re: Huge Data sets, simple queries
От: "Jeffrey W. Baker"
Сообщение: Re: Huge Data sets, simple queries