Hi Kevin, List, others...
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)
All else being the same, adjusting shared_buffers affects how much
o
Andy Colson wrote:
On 03/16/2012 05:30 PM, Kevin Grittner wrote:
>> 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 me
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
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 w
Andy Colson wrote:
> I tried shared_buffers at both 2400M and 18000M, and it took 4.5
> hours both times. I dont know if I am CPU bound or IO bound, but
> since giving PG more ram didnt help much, I'll assume I'm CPU
> bound.
All else being the same, adjusting shared_buffers affects how much
So let me clean that up for you:
> On 3/14/2012 11:29 PM, mapl...@light42.com wrote:
Hello list, my name is Brian Hamlin, but I prefer to go by darkblue, its
mysterious and dangerous!
I run PG 9.1, PostGIS 1.5.3, Linux 64 on Dual Xeons, OS on a single
drive, and db is on 3-disk raid 5. I'
(from #postgresql IRC on freenode)
darkblue_b I did an interesting experiment the other day davidfetter_vmw ..
davidfetter_vmw do tell
darkblue_b well you know I do these huge monolithic postGIS queries on an
otherwise idle linux machine.. and there was a persistant thought in my head
that Post
