No Performance Increase with SSD

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

No Performance Increase with SSD

Postby RiverOfJustice » Mon Jul 25, 2011 8:54 pm

I have a brand new HP Laptop w/ AMD3500 quad core processor and 6gig RAM. Today I installed an Intel 320 series 120gig SSD drive. Originally, my HH imports started at 170h/s, then gradually worked down to about 15h/s. After the SSD install, it still started at only 170h/s. I didn't complete the import because I knew something had to be wrong here. Everyone using SSD on here seems to be getting a minimum of 400h/s, some reporting up to 1k. My postgres settings as follows:

Version- 8.3.9(pretty sure, installed it with PT3 installer after downloading PT3 to my new computer)
Shared Buffers- 32mb
Temp Buffers- 30mb
Work Mem- 96mb
MaintWorkMem- 384mb
WalBuffers- 12mb

I have played with these number prior to my SSD install and could not get any difference in speed one way or the other. Can someone please tell me what to do to achieve the numbers everyone is getting?

**Hand Histories are from HandHQ.com, not sure if they are the better written types of file or not, because I have no idea how to tell**

PS. My SSD is not an auxillary drive. It is my laptop, so it was a replacement for my HDD. All hands are for 6max cash.
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: No Performance Increase with SSD

Postby RiverOfJustice » Tue Jul 26, 2011 2:26 am

-----------------------------------------------------------------------
CrystalDiskMark 3.0.1 x64 (C) 2007-2010 hiyohiyo
Crystal Dew World : http://crystalmark.info/

Here are my numbers from the CrystalDiskMark. Maybe this can help some of you find my problem?
-----------------------------------------------------------------------
* MB/s = 1,000,000 byte/s [SATA/300 = 300,000,000 byte/s]

Sequential Read : 257.067 MB/s
Sequential Write : 135.230 MB/s
Random Read 512KB : 166.303 MB/s
Random Write 512KB : 136.336 MB/s
Random Read 4KB (QD=1) : 15.243 MB/s [ 3721.5 IOPS]
Random Write 4KB (QD=1) : 22.313 MB/s [ 5447.6 IOPS]
Random Read 4KB (QD=32) : 139.552 MB/s [ 34070.2 IOPS]
Random Write 4KB (QD=32) : 67.607 MB/s [ 16505.7 IOPS]

Test : 1000 MB [C: 29.4% (28.9/98.2 GB)] (x5)
Date : 2011/07/26 2:24:52
OS : Windows 7 Home Premium Edition SP1 [6.1 Build 7601] (x64)
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: No Performance Increase with SSD

Postby tarix » Tue Jul 26, 2011 3:17 am

RiverOfJustice wrote:Version- 8.3.9(pretty sure, installed it with PT3 installer after downloading PT3 to my new computer)


If you want to get the best performance you'll need to upgrade to the 64-bit version of Postgres 9.0.

RiverOfJustice wrote:Shared Buffers- 32mb


This is going to be a huge performance bottleneck. You should set it to 512MB and try again.
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Re: No Performance Increase with SSD

Postby RiverOfJustice » Tue Jul 26, 2011 12:17 pm

Ok I'll try to up the shared buffers to 512mb and see how it goes. I couldn't find anything on how to upgrade postgres---can u tell me how I can do this, or point in the correct direction? From what I could find, upgrading from one major version to another is quite difficult. Thanks for your response. Do my crystaldisk numbers look decent?
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: No Performance Increase with SSD

Postby RiverOfJustice » Tue Jul 26, 2011 1:23 pm

One other thing- does postgres9.0 still come with some kind of .confg file...I see people are having trouble optimizing it. If not, how do I set the temp buffers and all the other stuff?
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: No Performance Increase with SSD

Postby WhiteRider » Tue Jul 26, 2011 2:46 pm

To upgrade you will need to make a Backup of your database(s) in 8.3 and then restore them in 9.0.
The process really isn't that complicated.

The config files exist in 9.0 just as they do in other versions.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: No Performance Increase with SSD

Postby RiverOfJustice » Tue Jul 26, 2011 4:25 pm

I understand about making the backup. I dowloaded the 64bit 9.0 from the postgres website. Now I have both 8.3.9 and 9.0 on my computer. Pokertracker still only sees 8.3.9. I can't find anything telling me what to do from here. The postgres website requires a degree to understand, or maybe I'm just computer stupid, idk. Either way, not sure where to go from here. I don't have an existing DB, so I don't need to reload anything into 9.0.
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: No Performance Increase with SSD

Postby RiverOfJustice » Tue Jul 26, 2011 5:01 pm

Ok I finally figured out how to upgrade. I found the config file in my program files, but it says windows can't open it. How do I edit it for tuning purposes? I also received an error when trying to install the stack builder-which most ppl say not to use anyway.
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: No Performance Increase with SSD

Postby RiverOfJustice » Tue Jul 26, 2011 6:45 pm

Ok I figured out how to use the back end config tool to update the file. Did that, ran an import and....no speed improvement whatsoever. Now what?
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: No Performance Increase with SSD

Postby kraada » Wed Jul 27, 2011 9:02 am

You'll need to change the postgres.conf settings again after upgrading (as it writes a new default postgres.conf file) - for the recommendations, see this tutorial. But that still sounds weird even without tuning - are there other hard drives installed on this machine?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 3 guests

cron