My set-up:
Postgres 8.2.5 on AMD x86_64 compiled with GCC 3.4.4 on Gentoo Linux 2.6.17
4 GB of RAM,
shared_buffers = 1000
work_mem = 1024
This is regarding performance of set-returning functions in queries. I
use generate_series() in the following as an example. The true
motivation is a need fo
> > Interestingly though, when the range in the generate_series() was
> > small enough to fit in 4 bytes of memory (e.g.
> > generate_series(1,10) ), the above query completed consuming
> > only negligible amount of memory. So, it looked like the aggregate
> > computation was being pipeline
are being freed too early? Any other
ideas as to what's going on here?
Thanks,
John
On Tue, Jan 8, 2008 at 8:51 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "John Smith" <[EMAIL PROTECTED]> writes:
>>> It's pipelined either way. But int8 is a pass-by-refer
