OK - MORE development here. If I bring down shared buffers to the equivalent of 1.7GB, it'll vacuum without a problem. Does anyone know why this might be? Thanks in advance. Cheers -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] Sent: 08 April 2011 08:47 To: French, Martin Cc: Tom Lane; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Out Of Memory 8.1 On Thu, Apr 7, 2011 at 8:56 AM, French, Martin <frenchm@xxxxxxxxxxxxxx> wrote: > Thanks for the info Tom. > > The table has been analyzed (somewhat repeatedly...), with the stats > target set at various limits. > > At the moment default_statistics_target = 50. > > I've had work_mem as low as 1MB and as high as 128MB, with little to no > avail. > > Setting enable_hashagg = off, does allow the query to complete, but > mashes the next query in the batch with it having to be killed at 8 > hours. Setting it off for this query alone causes the next query to do > exactly the same. > > The thing that perplexes me is; that on RHEL 5.0 with all the same > settings and data, the query works fine... so it's confusing as to what > can have changed so much to cause this. I know that we had to move to > RHEL 5.4 because of PERC Raid drivers, but I wouldn't have thought that > would've made too much of a difference. So what's the difference between the query plans on the two machines? Any difference in non-default settings in postgresql.conf between the two machines? ___________________________________________________ This email is intended for the named recipient. The information contained in it is confidential. You should not copy it for any purposes, nor disclose its contents to any other party. If you received this email in error, please notify the sender immediately via email, and delete it from your computer. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. PCI Compliancy: Please note, we do not send or wish to receive banking, credit or debit card information by email or any other form of communication. Cromwell Tools Limited, PO Box 14, 65 Chartwell Drive Wigston, Leicester LE18 1AT. Tel 0116 2888000 Registered in England and Wales, Reg No 00986161 VAT GB 115 5713 87 900 __________________________________________________ -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
