On Fri, Feb 27, 2004 at 01:45:07PM -0500, Joe Maldonado wrote: > Hello all! > > when asking postgres to aggregate totals accross 4.5 or so Million > records. The visible effect is that the postmaster will grow to the > 3GB process limit and die without a core :(. > I have seen this same behaviour discussed back in 6.5 archives in the > thread with subject "[SQL] How to avoid "Out of memory" using aggregate > functions? ". Is this fixed? Why is the postmaster exceeding it's 102MB > sort mem size when doing these queries and not paging out the data?
What version? We aggregate million of value vairly often. What aggregate? Have you run ANALYZE recently? -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > If the Catholic church can survive the printing press, science fiction > will certainly weather the advent of bookwarez. > http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow
pgp0u4Ci7NU8M.pgp
Description: PGP signature
