Re: [HACKERS] Postgres delays function returning large set of data

2009-06-05 Thread Tom Lane
flippo00110001 writes: > tupstore = tuplestore_begin_heap(true, false, SortMem); SortMem? What are you testing, 7.4? But anyway, the question I was going to ask is whether you made sure the data set you're trying to return fits in memory. If the tuplestore spills to disk then it's certai

Re: [HACKERS] Postgres delays function returning large set of data

2009-06-05 Thread flippo00110001
Pavel Stehule wrote: > > Hello > > can you send source code? There are two types of C SRF functions. One > returns row ro by row, second store returned rows and returns block. > What did you use? > I had originally used the style that returns row by row, but after reading the page i created a

Re: [HACKERS] Postgres delays function returning large set of data

2009-06-03 Thread Pavel Stehule
Hello can you send source code? There are two types of C SRF functions. One returns row ro by row, second store returned rows and returns block. What did you use? ignore comments (in czech please) and look on code - http://www.postgres.cz/index.php/Iter%C3%A1tor_pole regards Pavel Stehule 2009/

[HACKERS] Postgres delays function returning large set of data

2009-06-03 Thread flippo00110001
Hello, First some background: For my application I need to collect and retrieve data at a very fast rate, faster than postgres can produce, but I also have the need to store and access a large range of metadata about the large sets of data I am storing. I am therefore attempting to use postgres