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 iss

Re: [PERFORM] postgresql performance with multimedia

2004-08-26 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 stream

Re: [PERFORM] postgresql performance with multimedia

2004-08-24 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 t

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 > > im