Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 326E0176E183 for ; Sat, 17 Mar 2012 10:21:09 -0300 (ADT) Received: from li339-205.members.linode.com ([96.126.114.205] helo=squeakycode.net) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S8tZF-00040X-0d for pgsql-performance@postgresql.org; Sat, 17 Mar 2012 13:21:09 +0000 Received: from [192.168.1.116] (50-83-220-125.client.mchsi.com [50.83.220.125]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: andy) by squeakycode.net (Postfix) with ESMTPSA id 09F25178C2; Sat, 17 Mar 2012 09:20:55 -0400 (EDT) Message-ID: <4F648FB6.6080709@squeakycode.net> Date: Sat, 17 Mar 2012 08:20:54 -0500 From: Andy Colson User-Agent: Mozilla/5.0 (X11; Linux i686; rv:10.0) Gecko/20120131 Thunderbird/10.0 MIME-Version: 1.0 To: Kevin Grittner CC: Brian Hamlin , pgsql-performance@postgresql.org Subject: Re: Shared memory for large PostGIS operations References: <20120314212924.h7sjvzeoococwso0@webmail.light42.com> <4F63465B.1020508@squeakycode.net> <4F63052B0200002500046344@gw.wicourts.gov> <35AEFCF6-B6A7-42AD-A7B3-C73B6E9ABA09@light42.com> <4F63789E020000250004639D@gw.wicourts.gov> In-Reply-To: <4F63789E020000250004639D@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/117 X-Sequence-Number: 46567 On 03/16/2012 05:30 PM, Kevin Grittner wrote: > Brian Hamlin wrote: >> On Mar 16, 2012, at 7:17 AM, Kevin Grittner wrote: >>> Andy Colson wrote: >>> >>>> I tried shared_buffers at both 2400M and 18000M, and it took 4.5 >>>> hours both times. ... (weak attempts at humor omitted) .... > > Ah, I didn't pick up on the attempts at humor; perhaps that's why > you mistook something I said as an attempt at an insult. It wasn't you Kevin, it was me that insulted him. (Although I was trying to be funny, and not mean). Sorry again Brian. -Andy