Hi Kevin, List, others...
On Mar 16, 2012, at 7:17 AM, Kevin Grittner wrote:
Andy Colson a...@squeakycode.net 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
On 03/16/2012 05:30 PM, Kevin Grittner wrote:
Brian Hamlinmapl...@light42.com wrote:
On Mar 16, 2012, at 7:17 AM, Kevin Grittner wrote:
Andy Colsona...@squeakycode.net wrote:
I tried shared_buffers at both 2400M and 18000M, and it took 4.5
hours both times. ... (weak attempts at humor
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 mean).
(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
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.
Andy Colson a...@squeakycode.net 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
Brian Hamlin mapl...@light42.com wrote:
On Mar 16, 2012, at 7:17 AM, Kevin Grittner wrote:
Andy Colson a...@squeakycode.net 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