I am in the process of speccing out a new box for a highly utilized
(updates, inserts, selects) 40GB+ database. I'm trying to maximize
performance on a budget, and I would appreciate any feedback on any
of the following.
Hardware:
2 - Intel Xeon 5160 3.0 GHz 4MB 1333MHz
8 - Kingston 4GB DDR
Brian,
I like all of the HW - I just thoroughly reviewed this and came to the same
HW choices you did. The new SuperMicro chassis is an improvement on one we
have used for 21 servers like this.
One modification: we implemented two internal 60GB laptop hard drives with
an additional 3Ware 8006-2L
Hi,
I have a customer who wants a database solution for a 7 TB database.
Insert will be the main action in the database.
There are some case studies with detail information about performance
and hardware solution on this database size?
What are the minimum hardware requirements for this kind o
Hi, Arjen,
On 8-Sep-06, at 1:51 AM, Arjen van der Meijden wrote:
Hi,
We've been running our "webapp database"-benchmark again on mysql
and postgresql. This time using a Fujitsu-Siemens RX300 S3 machine
equipped with a 2.66Ghz Woodcrest (5150) and a 3.73Ghz Dempsey
(5080). And compared t
Dave Cramer wrote:
Hi, Arjen,
The Woodcrest is quite a bit faster than the Opterons. Actually...
With Hyperthreading *enabled* the older Dempsey-processor is also
faster than the Opterons with PostgreSQL. But then again, it is the
top-model Dempsey and not a top-model Opteron so that isn't a
Hi
i have a severe performance problem with one of my
views which has 6 to 8 joins .. any help will be
appreciated..
the view is:
CREATE OR REPLACE VIEW thsn.trade_view AS
SELECT tra.tra_id, tra.per_id, tra.fir_id,
tra.tra_dcn, tra.tra_startdate::date AS tra_startdate,
tra.tra_enddate::date AS
On 8-Sep-06, at 8:44 AM, Arjen van der Meijden wrote:
Dave Cramer wrote:
Hi, Arjen,
The Woodcrest is quite a bit faster than the Opterons.
Actually... With Hyperthreading *enabled* the older Dempsey-
processor is also faster than the Opterons with PostgreSQL. But
then again, it is the top
Brian Wipf wrote:
I am in the process of speccing out a new box for a highly utilized
(updates, inserts, selects) 40GB+ database. I'm trying to maximize
performance on a budget, and I would appreciate any feedback on any of
the following.
Perhaps this is off topic, but here is bit from my exp
fardeen memon <[EMAIL PROTECTED]> writes:
> What is it that i am doing wrong?
I think the forced coercion to date type in the view case is preventing
the planner from making a good guess about the selectivity of the
condition on tra_date. It has stats about tra_date's distribution,
but none about
hi
plz unsubscribe me..
i am sending mail to this id.. for unsubscribing.. is it correct..
my mail box is gettin flooded..
"Phadnis" writes:
> plz unsubscribe me..
>
> i am sending mail to this id.. for unsubscribing.. is it correct..
> my mail box is gettin flooded..
you managed to subscribe, you'll probably manage to unsubcribe.
hint: the email headers contain the information for unsubscribing.
--
Guillaume C
On 8-9-2006 15:01 Dave Cramer wrote:
But then again, systems with the Woodcrest 5150 (the subtop one) and
Opteron 280 (also the subtop one) are about equal in price, so its not
a bad comparison in a bang-for-bucks point of view. The Dempsey was
added to show how both the Opteron and the newer
Arjen van der Meijden wrote:
> On 8-9-2006 15:01 Dave Cramer wrote:
>>
>>> But then again, systems with the Woodcrest 5150 (the subtop one) and
>>> Opteron 280 (also the subtop one) are about equal in price, so its
>>> not a bad comparison in a bang-for-bucks point of view. The Dempsey
>>> was adde
On Fri, 2006-09-08 at 10:30 +0100, Nuno Alexandre Alves wrote:
> Hi,
>
> I have a customer who wants a database solution for a 7 TB database.
> Insert will be the main action in the database.
>
> There are some case studies with detail information about performance
> and hardware solution on thi
On 8-9-2006 18:18 Stefan Kaltenbrunner wrote:
interesting - so this is a mostly CPU-bound benchmark ?
Out of curiousity have you done any profiling on the databases under
test to see where they are spending their time ?
Yeah, it is.
We didn't do any profiling.
We had a Sun-engineer visit us t
15 matches
Mail list logo
