On Fri, May 23, 2008 at 3:41 AM, Andrzej Zawadzki <[EMAIL PROTECTED]> wrote:
> Hello,
>
> We're planning new production server for PostgreSQL and I'm wondering
> which processor (or even platform) will be better: Quad Xeon or Quad
> Opteron (for example SUN now has a new offer Sun Fire X4440 x64)
On May 18, 2008, at 1:28 AM, Greg Smith wrote:
I just collected all the good internals information included in
this thread and popped it onto http://wiki.postgresql.org/wiki/
Hint_Bits where I'll continue to hack away at the text until it's
readable. Thanks to everyone who answered my questi
On May 18, 2008, at 1:28 AM, Greg Smith wrote:
I just collected all the good internals information included in
this thread and popped it onto http://wiki.postgresql.org/wiki/
Hint_Bits where I'll continue to hack away at the text until it's
readable. Thanks to everyone who answered my questi
Moving to -hackers...
On May 21, 2008, at 9:09 AM, Richard Huxton wrote:
Luke Lonergan wrote:
The problem is that the implied join predicate is not being
propagated. This is definitely a planner deficiency.
IIRC only equality conditions are propagated and gt, lt, between
aren't. I seem to
On Apr 14, 2008, at 3:31 PM, Tom Lane wrote:
Gregory Stark <[EMAIL PROTECTED]> writes:
The transition domain where performance drops dramatically as the
database
starts to not fit in shared buffers but does still fit in
filesystem cache.
It looks to me like the knee comes where the DB no lo
On Apr 11, 2008, at 10:25 AM, Alvaro Herrera wrote:
Sorry, yes, I'm behind on email... :(
If MD5 values will be your primary data and you'll be storing millions
of them, it would be wise to create your own datatype and operators
with
the most compact and efficient representation possible.
Knight, Doug wrote:
> Hi,
> As a gauge, we recently purchased several servers as our systems get
> close to going operational. We bought Dell 2900s, with the cheapest quad
> core processors (dual) and put most of the expense into lots of drives
> (8 15K 146GB SAS drives in a RAID 10 set), and the P
Craig Ringer wrote:
> Andrzej Zawadzki wrote:
>
>> Hello,
>>
>> We're planning new production server for PostgreSQL and I'm wondering
>> which processor (or even platform) will be better: Quad Xeon or Quad
>> Opteron (for example SUN now has a new offer Sun Fire X4440 x64).
>>
>
> [snip]
>
