From: my ho <mthoatbanjo@yahoo.com>
To: Jan Wieck <JanWieck@Yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgresql performance with multimedia
Date: Thu, 26 Aug 2004 23:27:16 -0700 (PDT)
Message-ID: <20040827062716.4092.qmail@web54106.mail.yahoo.com> (raw)
In-Reply-To: <412C71F1.4030902@Yahoo.com>
Hi,
> For your "streaming" purposes I strongly recommend
> you do it in your
> application with the appropriate thread model. A
> relational database
> management system is not a multimedia cache.
That's actually what i plan to do with postgreSQL,
maybe tailor it to suit with a multimedia streaming
database. Well, i could do it in the application level
but i think it's also worth a try with the database
itself.
> They are only stored in that way on initial load and
> if the load is done
> with a single process. And don't you rely on this
> for the future. Right
> now, if you ever update or delete tuples, that order
> changes already.
does the buffer manager have any idea what table that
buf belongs to? (can we add 'rel' variable to sbufdesc
in buf_internals.h and update it everytime we add new
entry to the buffer cahe?) And then we take in to
account which relation the data in the buffer belongs
to in the buf replacement algorithm or in the
read-ahead policy.
> Also keep in mind that large values are not stored
> inline, but in an
> extra "TOAST" relation.
This is how i store my video file: break them in to
small chunks and store each part in a row of a table.
regards,
MThi
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mthoatbanjo@yahoo.com, JanWieck@Yahoo.com
Subject: Re: postgresql performance with multimedia
In-Reply-To: <20040827062716.4092.qmail@web54106.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox