| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)qwest(dot)net> |
| Cc: | Bill <bill(at)math(dot)uchicago(dot)edu>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Basic Postgresql Performance Question |
| Date: | 2004-06-16 20:49:18 |
| Message-ID: | 20040616204917.GC11196@ns.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
* Scott Marlowe (smarlowe(at)qwest(dot)net) wrote:
> On Wed, 2004-06-16 at 13:15, Bill wrote:
> > 2. It is advantageous to buy AMD 64 rather than the Pentium IV?
>
> Yes and no. If having more than 2 gigs of ram is important, 64 bit
> architecures run faster than 32 bit, where having over 2 gigs usually
> results in a slow down due to the memory switching they use.
This is truer on more traditional 64bit platforms than on amd64 which
has more differences than just the ability to handle 64bit size things.
amd64 also gives you access to more registers than were on the
register-starved i386 platforms which increases the speed for most
applications where it usually wouldn't when recompiled for 64bit.
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-06-17 00:33:37 | Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED |
| Previous Message | Scott Marlowe | 2004-06-16 20:18:45 | Re: Basic Postgresql Performance Question |