pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 



view thread (8+ messages)

Message-ID: <20040827062716.4092.qmail@web54106.mail.yahoo.com>
Permalink:  ../20040827062716.4092.qmail@web54106.mail.yahoo.com/
Also on:    postgresql.org/message-id/20040827062716.4092.qmail@web54106.mail.yahoo.com

 · 

reply

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