Re: [GENERAL] Postgresql and Athlon64 ?
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (NTPT) transmitted: Will I have some advantages, better performance etc using postgres 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are there asome benchmark available or someone personal experience ? Or should I stay in 32 bit platform for a while ? The ability to have Lots of Memory is a BIG help; the Intel Xeon platform maxxes out at 8GB, and in practice at more like 4GB, whereas AMD64 supports _way_ more than that along with a much faster memory bus than you get with Xeon. We're finding that Opteron is way faster than similarly numbered Xeon systems. The challenge you may find is in what high end disk controllers are supported; many of them only offer 32 bit DMA... -- let name=cbbrowne and tld=gmail.com in String.concat @ [name;tld];; http://www3.sympatico.ca/cbbrowne/advocacy.html If you ever drop your keys into a river of molten lava, let'em go, because, man, they're gone. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Postgresql and Athlon64 ?
Guy Rouillier wrote: NTPT wrote: Will I have some advantages, better performance etc using postgres 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are there asome benchmark available or someone personal experience ? Or should I stay in 32 bit platform for a while ? PG 8 works fine on 64-bit Linux running on AMD64. So I wouldn't stay on a 32-bit platform for that reason. You are aware, of course, that Opteron is better equipped than Athlon64 for memory-intensive tasks: dual channel memory, (usually) more on-chip cache, etc. Don't have any hard benchmark numbers, but AMD claims about a 15% general performance improvement switching from 32-bit to 64-bit. Actually, A64s come in multiple flavors -- single channel, dual channel, 512KB L2, 1MB L2. The fastest A64 FXs are actually faster than their corresponding Opteron cousins because not only do they have the same 2x memory channel and 1MB cache -- but their unbuffered memory has lower latency than registered memory that Opterons must use. Of course, I wouldn't run a server without registered ECC memory so the point is moot anyways. Plus you are limited to much less memory using unbuffered memory. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] Postgresql and Athlon64 ?
It runs fine, and is quite peppy an Fedora Core 2 for AMD 64. I have not run into any problems. NTPT wrote: Will I have some advantages, better performance etc using postgres 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are there asome benchmark available or someone personal experience ? Or should I stay in 32 bit platform for a while ? -- P. J. Josh Rovero Sonalysts, Inc. Email: [EMAIL PROTECTED]www.sonalysts.com215 Parkway North Work: (860)326-3671 or 442-4355 Waterford CT 06385 *** ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] Postgresql and Athlon64 ?
Hi, I have been running a 2Gb database for about 3 months now on my AMD64 bit and have been very happy with the peformance and stability. I am running it under Gentoo. I don't have any particular benchmarks and only my own testing of our company scripts. I have been very impressed with the performance. Regards, Abdul-Wahid On Mon, 31 Jan 2005 12:44:14 +0100, NTPT [EMAIL PROTECTED] wrote: Will I have some advantages, better performance etc using postgres 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are there asome benchmark available or someone personal experience ? Or should I stay in 32 bit platform for a while ? Thanx for help ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Postgresql and Athlon64 ?
So postgresql can have benfit from 64 bit architecture ? - Original Message - From: P.J. Josh Rovero [EMAIL PROTECTED] To: NTPT [EMAIL PROTECTED] Cc: 'PgSql General' pgsql-general@postgresql.org Sent: Monday, January 31, 2005 2:33 PM Subject: Re: [GENERAL] Postgresql and Athlon64 ? It runs fine, and is quite peppy an Fedora Core 2 for AMD 64. I have not run into any problems. NTPT wrote: Will I have some advantages, better performance etc using postgres 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are there asome benchmark available or someone personal experience ? Or should I stay in 32 bit platform for a while ? -- P. J. Josh Rovero Sonalysts, Inc. Email: [EMAIL PROTECTED]www.sonalysts.com215 Parkway North Work: (860)326-3671 or 442-4355 Waterford CT 06385 *** ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Postgresql and Athlon64 ?
NTPT wrote: So postgresql can have benfit from 64 bit architecture ? Yes quite. Sincerely, Joshua D. Drake - Original Message - From: P.J. Josh Rovero [EMAIL PROTECTED] To: NTPT [EMAIL PROTECTED] Cc: 'PgSql General' pgsql-general@postgresql.org Sent: Monday, January 31, 2005 2:33 PM Subject: Re: [GENERAL] Postgresql and Athlon64 ? It runs fine, and is quite peppy an Fedora Core 2 for AMD 64. I have not run into any problems. NTPT wrote: Will I have some advantages, better performance etc using postgres 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are there asome benchmark available or someone personal experience ? Or should I stay in 32 bit platform for a while ? -- P. J. Josh Rovero Sonalysts, Inc. Email: [EMAIL PROTECTED]www.sonalysts.com215 Parkway North Work: (860)326-3671 or 442-4355 Waterford CT 06385 *** ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Command Prompt, Inc., your source for PostgreSQL replication, professional support, programming, managed services, shared and dedicated hosting. Home of the Open Source Projects plPHP, plPerlNG, pgManage, and pgPHPtoolkit. Contact us now at: +1-503-667-4564 - http://www.commandprompt.com begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:[EMAIL PROTECTED] title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Postgresql and Athlon64 ?
NTPT wrote: Will I have some advantages, better performance etc using postgres 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are there asome benchmark available or someone personal experience ? Or should I stay in 32 bit platform for a while ? PG 8 works fine on 64-bit Linux running on AMD64. So I wouldn't stay on a 32-bit platform for that reason. You are aware, of course, that Opteron is better equipped than Athlon64 for memory-intensive tasks: dual channel memory, (usually) more on-chip cache, etc. Don't have any hard benchmark numbers, but AMD claims about a 15% general performance improvement switching from 32-bit to 64-bit. -- Guy Rouillier ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly