AMD or Intel?

[Palle Girgensohn]

--On torsdag, torsdag 13 sep 2007 15.07.17 -0400 Francisco Reyes 
<lists at stringsutils.com> wrote:

> Palle Girgensohn writes:
>
>> Now, I hear rumors that AMD is to be preferred over Intel for
>> performance
>
> From what I have read in the past, specially in the postgresql list, it
> seems the AMD64 cpus do better with Postgresql. Possibly because of
> better bus architecture.

I think this is not current information; the new woodcrest architecture 
performs mucg better, although this is deduced from this thread's 
discussion...

> Personally I think having lots of memory and a good disk subsystem is
> going to make a bigger difference.

true

> What sizes are you expecting for your data?
> What type of growth? How many concurrent connections?

Presently ~pgsql/data has a 16 GB footprint. The growth is rather slow, 
around a percent per week, sometimes much more due to batch updates. Even 
with a high system load, we seldom see more than a 30-40 concurrent 
postgresql connections.

/Palle