X-Original-To: pgsql-performance@postgresql.org Received: from smtp016.mail.yahoo.com (smtp016.mail.yahoo.com [216.136.174.113]) by svr1.postgresql.org (Postfix) with SMTP id 3CBEE5E480D for ; Tue, 24 Aug 2004 08:59:49 -0300 (ADT) Received: from unknown (HELO jupiter.black-lion.info) (janwieck@68.80.245.191 with login) by smtp016.mail.yahoo.com with SMTP; 24 Aug 2004 11:59:37 -0000 Received: from [172.21.8.18] ([192.168.192.101]) (authenticated bits=0) by jupiter.black-lion.info (8.12.10/8.12.9) with ESMTP id i7OBxWT7074907; Tue, 24 Aug 2004 07:59:32 -0400 (EDT) (envelope-from JanWieck@Yahoo.com) Message-ID: <412B2DE7.6000809@Yahoo.com> Date: Tue, 24 Aug 2004 08:00:39 -0400 From: Jan Wieck User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: my ho Cc: pgsql-performance@postgresql.org Subject: Re: postgresql performance with multimedia References: <20040824050842.56287.qmail@web54109.mail.yahoo.com> In-Reply-To: <20040824050842.56287.qmail@web54109.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200408/322 X-Sequence-Number: 7958 On 8/24/2004 1:08 AM, my ho wrote: > --- 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 Tom Lane answered to that question. The code in question does resolve "localhost" with getaddrinfo() and then tries to create and bind a UDP socket to all returned addresses. For some reason "localhost" on your system resolves to an address that is not available for bind(2). > > 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. Since there is no mechanism to control that data is stored contiguously in the tables, what would that be good for? Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #