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>
To: my thi ho <mthoatbanjo@Yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgresql performance with multimedia
Date: Mon, 23 Aug 2004 22:08:42 -0700 (PDT)
Message-ID: <20040824050842.56287.qmail@web54109.mail.yahoo.com> (raw)
In-Reply-To: <41235543.7070303@Yahoo.com>


--- Jan Wieck <JanWieck@Yahoo.com> wrote:

> On 8/17/2004 8:44 PM, my thi ho wrote:
> 
> > Hi,
> > I am working on a project which explore postgresql
> to
> > store multimedia data.
> > In details,  i am trying to work with the buffer
> > management part of postgres source code. And try
> to
> > improve the performance. I had search on the web
> but
> > could not find much usefull information. 
> 
> What version of PostgreSQL are you looking at? Note
> that the buffer 
> cache replacement strategy was completely changed
> for version 8.0, which 
> is currently in BETA test. A description of the
> algorithm can be found 
> in the README file in src/backend/storage/bufmgr.

oki, Thanks for the information. I have a look at 8.0
beta, but cannot start the statistic collector. (I had
post this err message before for help, but havent
really got any clue to fix it)
> LOG:  could not create IPv6 socket: Address family
not
> supported by protocol
> LOG:  could not bind socket for statistics
collector:
> Cannot assign requested address
> LOG:  disabling statistics collector for lack of
> working socket

btw, what i want to ask here is does postgreSQL have
any kind of read-ahead buffer implemented? 'cos it
would be useful in multimedia case when we always scan
the large table for continous data.
Thanks 
Ho




	
		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail 



view thread (8+ messages)  latest in thread

Message-ID: <20040824050842.56287.qmail@web54109.mail.yahoo.com>
Permalink:  ../20040824050842.56287.qmail@web54109.mail.yahoo.com/
Also on:    postgresql.org/message-id/20040824050842.56287.qmail@web54109.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: <20040824050842.56287.qmail@web54109.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