Best way to partition for postgresql

[Fany]

Hi, I am trying to optimize the benefits of partitioning.

I am using a 1TB samsung spinpoint F1 HD and paragon partition manager trial. My current HD has ONE partition for Windows 7 RC 64-bit.

What kind of partition should I create: last primary, primary, logical, etc??
(I heard the read/write speed is faster near the center of the HD? How could I find to way to set that part of the HD up for the postgres?)

Dave said something about the Master table partition that is supported by postgres. How is this partitioning different from a normal partitioning software?

Thanks for looking, I am really trying to make the best of what I have.

Fany

PS would it be better to use my 8-years-old 40GB ATA HD from my old pc and set that up as a dedicated postgres HD?

[kraada]

Honestly you aren't going to get any significant performance gain out of making different partitions to keep the data in when it's all on the same drive. Just keep it as one large partition.

If you want to use that second drive, I think the best thing to do would be to have it as the location for PostgreSQL to write the pg_log directory; that will take some of the burden off of the primary hard drive but the data there isn't going to be retrieved for much so the performance on the secondary drive doesn't really matter, it's just somewhere else to put the data. This thread will walk you through what you need to do to set that up.

[Fany]

thanks for your suggestions, I guess i'll just stick with 1 HD then. The ATA cable is going to block airflow and make the interior of my case look ugly :/