X-Original-To: pgsql-performance@postgresql.org Received: from web54109.mail.yahoo.com (web54109.mail.yahoo.com [206.190.37.244]) by svr1.postgresql.org (Postfix) with SMTP id 82DB95E46FB for ; Tue, 24 Aug 2004 02:15:52 -0300 (ADT) Message-ID: <20040824050842.56287.qmail@web54109.mail.yahoo.com> Received: from [129.94.6.30] by web54109.mail.yahoo.com via HTTP; Mon, 23 Aug 2004 22:08:42 PDT Date: Mon, 23 Aug 2004 22:08:42 -0700 (PDT) From: my ho Subject: Re: postgresql performance with multimedia To: Jan Wieck , my thi ho Cc: pgsql-performance@postgresql.org In-Reply-To: <41235543.7070303@Yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200408/319 X-Sequence-Number: 7955 --- Jan Wieck 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