> future performance growth, and current system requirements. Trust me it
> isn't easy.
>
>
> Juan
>
> -Original Message-
> From: Josh Berkus [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 06, 2006 2:57 AM
> To: pgsql-performance@postgresq
: Thursday, April 06, 2006 2:57 AM
To: pgsql-performance@postgresql.org
Cc: Juan Casero (FL FLC); Luke Lonergan
Subject: Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3
Juan,
Ok that is beginning to become clear to me. Now I need to determine
if this server is worth the investment for us. M
Hi Leigh
inline comments
Leigh Dyer wrote:
Luke Lonergan wrote:
Juan,
We've got a Sun Fire V40z and it's quite a nice machine -- 6x 15krpm
drives, 4GB RAM, and a pair of Opteron 850s. This gives us more than
enough power now for what we need, but it's nice to know that we can
shoehorn
Juan,
On 4/6/06 7:01 AM, "Matthew Nuzum" <[EMAIL PROTECTED]> wrote:
>> Apart from that since I will only get this one chance to
>> buy a new server for data processing I need to make sure that I buy
>> something that can grow over time as our needs change. I don't want to
>> buy a server only to
On Apr 6, 2006, at 12:47 AM, Leigh Dyer wrote:
I'm sure those little SAS drives would be great for web servers and
other non-IO-intensive tasks though -- I'd love to get some X4100s
in to replace our Poweredge 1750s for that. It's a smart move
overall IMHO,
For this purpose, bang for the
On Apr 5, 2006, at 9:11 PM, Marcelo Tada wrote:
What are you think about the Sun Fire X64 X4200 Server?
I use the X4100 and like it a lot. I'm about to buy another. I see
no advantage to the X4200 unless you want the extra internal disks.
I use an external array.
---
On Apr 5, 2006, at 5:58 PM, August Zajonc wrote:
Most involve some AMD Opertons, lots of spindles with a good raid
controller preferred to one or two large disks and a good helping of
ram. Be interesting to get some numbers on the sunfire machine.
I can highly recommend the SunFire X4100, how
On 4/6/06, Juan Casero (FL FLC) <[EMAIL PROTECTED]> wrote:
> Because I plan to develop a rather large (for us anyway) data warehouse
> with PostgreSQL. I am looking for the right hardware that can handle
> queries on a database that might grow to over a 100 gigabytes.
You need to look for a serve
uan Casero (FL FLC); Luke Lonergan
Subject: Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3
Juan,
> Ok that is beginning to become clear to me. Now I need to determine
> if this server is worth the investment for us. Maybe it is not a
> speed daemon but to be honest the licensing co
Hi, Juan,
Juan Casero (FL FLC) wrote:
> Ok that is beginning to become clear to me. Now I need to determine if
> this server is worth the investment for us. Maybe it is not a speed
> daemon but to be honest the licensing costs of an SMP aware RDBMS is
> outside our budget. When postgresql start
Miguel wrote:
Excuse me for this off topic, but i notice that you are very excited
about the sun's hardware, what os do you install on them , slowlaris?,
has that os improved in some espectacular way that i should take a look
again?, i used it until solaris 9 and the performance was horrible
Mark Kirkwood wrote:
The newer Sun Opteron systems look nice too, but unless you're using
external storage, their little 2.5" hard drives may not be ideal.
Yes - but they end-of-lifed the V20z and V40z!
That's quite disappointing to hear -- our V40z isn't even six months
old! We're not a
Juan,
> Ok that is beginning to become clear to me. Now I need to determine if
> this server is worth the investment for us. Maybe it is not a speed
> daemon but to be honest the licensing costs of an SMP aware RDBMS is
> outside our budget.
You still haven't explained why you want multi-threa
Leigh Dyer wrote:
Luke Lonergan wrote:
Leigh,
On 4/5/06 9:23 PM, "Leigh Dyer" <[EMAIL PROTECTED]> wrote:
We've got a Sun Fire V40z and it's quite a nice machine -- 6x 15krpm
drives, 4GB RAM, and a pair of Opteron 850s. This gives us more than
enough power now for what we need, but it's nice
L FLC); pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3
Juan,
On 4/5/06 1:54 PM, "Juan Casero (FL FLC)" <[EMAIL PROTECTED]>
wrote:
> I am not sure about this. I mean I have postgresql 8.1.3 running on
> my Windows XP P4 HT lapto
Luke Lonergan wrote:
Leigh,
On 4/5/06 9:23 PM, "Leigh Dyer" <[EMAIL PROTECTED]> wrote:
We've got a Sun Fire V40z and it's quite a nice machine -- 6x 15krpm
drives, 4GB RAM, and a pair of Opteron 850s. This gives us more than
enough power now for what we need, but it's nice to know that we can
Leigh,
On 4/5/06 9:23 PM, "Leigh Dyer" <[EMAIL PROTECTED]> wrote:
> We've got a Sun Fire V40z and it's quite a nice machine -- 6x 15krpm
> drives, 4GB RAM, and a pair of Opteron 850s. This gives us more than
> enough power now for what we need, but it's nice to know that we can
> shoehorn a lot m
Luke Lonergan wrote:
Juan,
On 4/5/06 5:33 PM, "Juan Casero (FL FLC)" <[EMAIL PROTECTED]>
wrote:
... but I am looking to see if the performance
benefit we can get from this server is worth the price tag right now.
While many people here will look forward to performance results on the
T2000, I
Juan Casero (FL FLC) wrote:
I can't fully realize
the performance benefits of the T2000 server unless and until I start
getting lots of people hitting the database server with requests. This
doesn't happen right now. It may happen later on as I write more
applications for the server but I am l
Juan,
On 4/5/06 5:33 PM, "Juan Casero (FL FLC)" <[EMAIL PROTECTED]>
wrote:
> ... but I am looking to see if the performance
> benefit we can get from this server is worth the price tag right now.
While many people here will look forward to performance results on the
T2000, I can guarantee that y
To: pgsql-performance@postgresql.org
Cc: Juan Casero (FL FLC); Luke Lonergan
Subject: Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3
Juan,
> When I hit
> this pgsql on this laptop with a large query I can see the load spike
> up really high on both of my virtual processors. Whatever, p
Tom is right. Unless your workload can generate lots of simultaneous
queries, you will not reap the full benefit of the Sun Fire T2000
system. I have tested 8.1.3 with an OLTP workload on an 8 cores system.
With 1500-2000 client connections, the CPU was only about 30% utilized.
The UltraSPARC T
Hi Juan Casero,
I've found that serial query clients are best served by PostgreSQL
running on fast single or dual core processors, ( such as the Athlon
FX60 ) rather than expensive n-way systems. I was orginally using an
8-way Xeon computer for a similar serial throughput problem. and i
wasn't
On Wed, 2006-04-05 at 15:54, Juan Casero (FL FLC) wrote:
> I am not sure about this. I mean I have postgresql 8.1.3 running on my
> Windows XP P4 HT laptop that I use for testing my webapps. When I hit
> this pgsql on this laptop with a large query I can see the load spike up
> really high on bot
Juan Casero (FL FLC) wrote:
> When I hit
> this pgsql on this laptop with a large query I can see the load spike up
> really high on both of my virtual processors. Whatever, pgsql is doing
> it looks like both cpu's are being used indepently.
Intel HT was partly a marketing thing, you don't real
[EMAIL PROTECTED] ("Juan Casero \(FL FLC\)") writes:
> I am not sure about this. I mean I have postgresql 8.1.3 running on
> my Windows XP P4 HT laptop that I use for testing my webapps. When
> I hit this pgsql on this laptop with a large query I can see the
> load spike up really high on both of
the code.
Thanks,
Juan
-Original Message-
From: Luke Lonergan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 5:37 PM
To: Juan Casero (FL FLC); pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3
Juan,
On 4/5/06 1:54 PM, "Juan C
ge-
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 6:02 PM
To: pgsql-performance@postgresql.org
Cc: Juan Casero (FL FLC); Luke Lonergan
Subject: Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3
Juan,
When I hit
this pgsql on this laptop with a large query I can
josh@agliodbs.com (Josh Berkus) writes:
> Juan,
>
>> When I hit
>> this pgsql on this laptop with a large query I can see the load spike up
>> really high on both of my virtual processors. Whatever, pgsql is doing
>> it looks like both cpu's are being used indepently.
>
> Nope, sorry, you're bein
Josh Berkus writes:
> Juan,
>> When I hit
>> this pgsql on this laptop with a large query I can see the load spike up
>> really high on both of my virtual processors. Whatever, pgsql is doing
>> it looks like both cpu's are being used indepently.
> Nope, sorry, you're being decieved. Postgres
Juan,
> When I hit
> this pgsql on this laptop with a large query I can see the load spike up
> really high on both of my virtual processors. Whatever, pgsql is doing
> it looks like both cpu's are being used indepently.
Nope, sorry, you're being decieved. Postgres is strictly one process, on
Juan,
On 4/5/06 2:45 PM, "Juan Casero (FL FLC)" <[EMAIL PROTECTED]>
wrote:
> Do you think bizgres might be a good choice of database server for the
> Ultrasparc T1 based T2000? I have downloaded the source code but I was
> hoping to find out if the potential performance gains were worth the
> e
Juan,
On 4/5/06 1:54 PM, "Juan Casero (FL FLC)" <[EMAIL PROTECTED]>
wrote:
> I am not sure about this. I mean I have postgresql 8.1.3 running on my
> Windows XP P4 HT laptop that I use for testing my webapps. When I hit
> this pgsql on this laptop with a large query I can see the load spike up
this question.
Thanks,
Juan
-Original Message-
From: Luke Lonergan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 4:43 PM
To: Juan Casero (FL FLC); pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3
Juan,
On 4/5/06 11:12 AM, "J
Juan,
On 4/5/06 11:12 AM, "Juan Casero (FL FLC)" <[EMAIL PROTECTED]>
wrote:
> I know the postgresql server is not smp aware but I believe
> parts of it are. In particular the buffer manager is supposed to scale the
> performance almost linearly with the number of cpu's (including virtual ones).
"Juan Casero \(FL FLC\)" <[EMAIL PROTECTED]> writes:
> ... This box has a single Ultrasparc T1 cpu with six execution
> piplelines that can each handle 4 threads. With the Unix top utility
> the postgresql server appears to bounce around between the available
> threads on the system.
Try sending
Greetings -
I am testing a Sun
Microsystems Sun Fire T2000 demo server at our company. I want to
know if anyone here has any experience with this hardware and postgresql
8.1.3. I installed the copy of postgresql 8.1.3 from blastwave.org onto
this demo box and loaded our production datab
37 matches
Mail list logo
