partitions,LBA and PT - basic questions

General discussion of PokerTracker 3.

Moderator: Moderators

partitions,LBA and PT - basic questions

Postby lucas7 » Sat Jul 16, 2011 5:42 am

Hi again

I've read on some forum an intresting discussion which I'll summarize below :

The beginning of a hdd disk is closer to an outside edge of a platter where read speed is/should be faster cause more sectors will 'fly' under head, as we have constant rotation speed rpm. So the system partition should be first, at the beginning, and possibly PT and postgre should be on C, but!:
On average hdd there's no 100% guarantee as to where in reality is the physical/actual beginning of it on a platter. Since LBA replaced CHS everything depends on tracks numeration and how the head moves on the platter surface depending on used algorithm(FCFS, SSTF etc.), in addition OS doesn't know how the logic structure of a disk transates to it's physical structure. Summing up - phisycal/actual placement of a data doesn't influence the time needed to acces this data ?

- Maybe you could tell me whether it's true or not
- and does it matter whether PT and postgre are on C or D
- and another question if we put PT,postgre on D is it important to put them on the begininng of an empty partition, before we add any other data to D?
lucas7
 
Posts: 14
Joined: Sun Jun 20, 2010 6:12 am
Location: Warsaw

Re: partitions,LBA and PT - basic questions

Postby kraada » Sat Jul 16, 2011 8:18 am

It's not a particularly big issue - if anything, get an SSD - that will be much, much faster - and that doesn't have the physical limitations of a spinning disk that you are describing. The main benefit to putting the database on a separate physical disk is that the seeks going on when your operating system does things will not slow down PostgreSQL (as it can do its own seeking simultaneously for data).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: partitions,LBA and PT - basic questions

Postby lucas7 » Thu Jul 21, 2011 7:00 am

Actually I'm leaning towards a gaming laptop with two disks in RAID and external monitor and keyboard (I'll write separate post/question about that and SSD).
If we have 2disks in RAID and two partitions does it matter whether PT and Postgre are on C partition with the OS or on D?

_________
as to my previous questions I meant two partitions in one physical disk not two separate drives, but if I understand You correctly if we have one physical disk it doesn't matter whether we put the database on C or on D partition, it won't speed up or slow things perceptibly right?
lucas7
 
Posts: 14
Joined: Sun Jun 20, 2010 6:12 am
Location: Warsaw

Re: partitions,LBA and PT - basic questions

Postby kraada » Thu Jul 21, 2011 9:50 am

If you're using the same physical disk it won't make a difference what partition you're on in terms of performance. If you are using RAID then there should only be one partition to use and you should use it, at least as I normally understand RAID usage.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: partitions,LBA and PT - basic questions

Postby lucas7 » Mon Jul 25, 2011 6:53 am

Don't know much about RAID yet, but you say that when we have two disks with the same capacity and RAID 0 ,then we can't have more then one partition or we should have only one? why?
lucas7
 
Posts: 14
Joined: Sun Jun 20, 2010 6:12 am
Location: Warsaw

Re: partitions,LBA and PT - basic questions

Postby tarix » Mon Jul 25, 2011 9:16 am

You will only get speed improvements if you have postgres on a separate physical disk. Since RAID combines several disks into one unit you can think of any RAID volume as a single physical disk. Thus, creating a second partition on the same disk or same RAID volume will not help.
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Re: partitions,LBA and PT - basic questions

Postby lucas7 » Wed Jul 27, 2011 10:24 am

Ok thanks, but one last, crucially important question in this thread - In terms of postgre and speeding up our database if we have two separate physical disks do you recommend striping them in RAID 0?? (cause I thought it was obvious since the read/write operations would be much faster)
or maybe you don't ? what will be faster - database on a separate disk or RAID 0 ?
lucas7
 
Posts: 14
Joined: Sun Jun 20, 2010 6:12 am
Location: Warsaw

Re: partitions,LBA and PT - basic questions

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

Will you be running anything else off of those disks if you put them in RAID?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: partitions,LBA and PT - basic questions

Postby lucas7 » Wed Jul 27, 2011 1:05 pm

Not exactly sure what you mean, I'm thinking to buy some of the gaming laptops with 2 or more drives whether SSD or hybrid HDD(like seagate momentus XT) and RAID 0 - mainly for poker so there will be windows 7, some of my data, and of course other programs except PT3 and postgre, but nothing as demanding as PT. Not planning to run anything else while playing except that what is needed.
I thought that RAID 0 will always be better and faster for PT, now you got me confused a bit
lucas7
 
Posts: 14
Joined: Sun Jun 20, 2010 6:12 am
Location: Warsaw

Re: partitions,LBA and PT - basic questions

Postby kraada » Wed Jul 27, 2011 1:15 pm

IT depends how many hard drives you're putting in the machine.

If you have a primary hard drive that runs the OS and a secondary hard drive that runs PostgreSQL that will do better (for just PostgreSQL performance) than a RAID with those two hard drives, and the main OS using it - because the main OS is taking time away from the hard drives.

But if you have a hard drive for the main OS (say a dedicated SSD) and were putting in other hard drives just for PostgreSQL - then putting them in RAID would yield more of a performance boost.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests