Re: [HACKERS] Performance gain from reduction of GROUP BY memory

2005-08-30 Thread Tom Lane
Bruce Momjian writes: > Alvaro Herrera wrote: >> On Tue, Aug 30, 2005 at 10:23:49AM -0400, Bruce Momjian wrote: >>> I don't usually document internal API changes in the release notes. >>> Should I? >> >> Doesn't this potentially affect user-defined aggregates? > I read it as something that _cou

Re: [HACKERS] Performance gain from reduction of GROUP BY memory

2005-08-30 Thread Bruce Momjian
Alvaro Herrera wrote: > On Tue, Aug 30, 2005 at 10:23:49AM -0400, Bruce Momjian wrote: > > > > > 2005-03-12 15:25 tgl > > > > > > > > * contrib/intagg/int_aggregate.c, > > > > contrib/intagg/int_aggregate.sql.in, doc/src/sgml/xaggr.sgml, > > > > doc/src/sgml/xfunc.sgml, s

Re: [HACKERS] Performance gain from reduction of GROUP BY memory

2005-08-30 Thread Alvaro Herrera
On Tue, Aug 30, 2005 at 10:23:49AM -0400, Bruce Momjian wrote: > > > 2005-03-12 15:25 tgl > > > > > > * contrib/intagg/int_aggregate.c, > > > contrib/intagg/int_aggregate.sql.in, doc/src/sgml/xaggr.sgml, > > > doc/src/sgml/xfunc.sgml, src/backend/executor/nodeAgg.c, > > > src/backend/uti

Re: [HACKERS] Performance gain from reduction of GROUP BY memory

2005-08-30 Thread Bruce Momjian
Simon Riggs wrote: > On Mon, 2005-08-29 at 20:25 -0400, Tom Lane wrote: > > Simon Riggs <[EMAIL PROTECTED]> writes: > > > I notice that Neil's patch regarding reducing the number of memory > > > allocations during aggregation operations isn't mentioned. It was > > > originally discussed in 8.0beta

Re: [HACKERS] Performance gain from reduction of GROUP BY memory

2005-08-30 Thread Simon Riggs
On Mon, 2005-08-29 at 20:25 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > I notice that Neil's patch regarding reducing the number of memory > > allocations during aggregation operations isn't mentioned. It was > > originally discussed in 8.0beta (2-3?) time. > > > What happ

Re: [HACKERS] Performance gain from reduction of GROUP BY memory allocations

2005-08-29 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > I notice that Neil's patch regarding reducing the number of memory > allocations during aggregation operations isn't mentioned. It was > originally discussed in 8.0beta (2-3?) time. > What happened there? > - patch not committed in the end > - committed bu

[HACKERS] Performance gain from reduction of GROUP BY memory allocations

2005-08-29 Thread Simon Riggs
In PostgreSQL Weekly News, David Fetter wrote: > Please test the new beta. Some of the new features are at > http://developer.postgresql.org/docs/postgres/release.html#RELEASE-8-1 I notice that Neil's patch regarding reducing the number of memory allocations during aggregation operations isn't me