On May 16, 2013, at 5:56 PM, Ramsey Gurley wrote:Hi All,I tried bumping my read ahead up to 4096. Instead of having faster reads, it seems it actually slowed things down. In fact, most of the tuning suggestions I've tried have made little to no difference in the results I get from bonnie++
Hi All,
I tried bumping my read ahead up to 4096. Instead of having faster reads, it
seems it actually slowed things down. In fact, most of the tuning suggestions
I've tried have made little to no difference in the results I get from
bonnie++. I'll include a table of values in html. I'm wonderi
On May 16, 2013, at 6:01 AM, Shaun Thomas wrote:
> On 05/15/2013 08:04 PM, Ramsey Gurley wrote:
>
>> My question: Is that advice just for the database drive, or should I
>> increase read ahead on the OS/WAL disk as well?
>
> Definitely the database drive, but it doe
Hi all,
I've just gotten into my new database server yesterday and I've started doing
database setup and tuning.
I'm on a Rackspace Linux server with two raid arrays. Both are ext3. One is a
two disk RAID1 I plan on using for WAL and OS, the other is a four disk RAID10
I will use for the data.
Okay, I saw that, but I just wanted to double check. It seemed odd that there
were builds going all the way back to 8.2 if the 9.2 version should work for
everything.
Thanks for the reassurance :-)
Ramsey
On Apr 16, 2013, at 1:36 PM, Adrian Klaver wrote:
> On 04/16/2013 01:13 PM, Ram
Hi all,
I'm migrating from postgres 8.3 to 9.2. Included in my application is an old
jar for the JDBC driver for the 8.3 database. Do I need a separate build with
an up to date JDBC jar for 9.2 while I am testing out a new database or is it
safe to use the latest JDBC jar with a very old versio
On Apr 8, 2013, at 8:46 PM, Jeff Janes wrote:
> On Monday, April 8, 2013, Ramsey Gurley wrote:
> Hi all,
>
> I'm having issues with slow queries using postgres, and I'm finding some of
> the issues difficult to reproduce. My application logs slow queries for me,
>
On Apr 8, 2013, at 7:09 PM, Kevin Grittner wrote:
> Ramsey Gurley wrote:
>
>> I'm having issues with slow queries using postgres, and I'm
>> finding some of the issues difficult to reproduce. My application
>> logs slow queries for me, but often, when I go bac
I forgot to mention. I'm currently using postgres 8.3.x
On Apr 8, 2013, at 3:08 PM, Ramsey Gurley wrote:
> Hi all,
>
> I'm having issues with slow queries using postgres, and I'm finding some of
> the issues difficult to reproduce. My application logs slow queries f
Hi all,
I'm having issues with slow queries using postgres, and I'm finding some of the
issues difficult to reproduce. My application logs slow queries for me, but
often, when I go back to run explain analyze on the query it is very fast. I
assume this is due to some sort of caching. Here is an
10 matches
Mail list logo
