Re: [PERFORM] postgresql performance with multimedia

2004-08-23 Thread my ho
--- Jan Wieck [EMAIL PROTECTED] 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

Re: [PERFORM] postgresql performance with multimedia

2004-08-25 Thread my ho
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). I tried to put

Re: [PERFORM] postgresql performance with multimedia

2004-08-27 Thread my ho
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

Re: [PERFORM] execute cursor fetch

2004-10-12 Thread my ho
Hi, If anyone can help pls, I have a question abt the execution of cursor create/fetch/move , in particular about disk cost. When a cursor is created, is the whole table (with the required columns) got put into memory? otherwise how does it work? (in term of disk read and transfer?) after user