From: Jan Wieck <JanWieck@Yahoo.com>
To: my ho <mthoatbanjo@Yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgresql performance with multimedia
Date: Tue, 24 Aug 2004 08:00:39 -0400
Message-ID: <412B2DE7.6000809@Yahoo.com> (raw)
In-Reply-To: <20040824050842.56287.qmail@web54109.mail.yahoo.com>
References: <20040824050842.56287.qmail@web54109.mail.yahoo.com>
On 8/24/2004 1:08 AM, my ho wrote:
> --- 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
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 #
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: JanWieck@Yahoo.com, mthoatbanjo@Yahoo.com
Subject: Re: postgresql performance with multimedia
In-Reply-To: <412B2DE7.6000809@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