On Sun, Dec 18, 2005 at 11:35:15AM -0500, Juan Casero wrote:
> Can anyone tell me how well PostgreSQL 8.x performs on the new Sun Ultrasparc
> T1 processor and architecture on Solaris 10? I have a custom built retail
> sales reporting that I developed using PostgreSQL 7.48 and PHP on a Fedora
Pe
On Tue, Dec 20, 2005 at 12:20:55PM -0500, Jignesh K. Shah wrote:
> Is pgbench the workload that you prefer? (It already has issues with
> pg_xlog so my guess is it probably won't scale much)
> If you have other workload informations let me know.
>From what the user described, dbt3 would probably
formance cc
[EMAIL PROTECTED] pgsql-performance@postgresql.org
.org Subject
Re: [PERFORM] PostgreSQL and
[EMAIL PROTECTED] pgsql-performance@postgresql.org
.org Subject
Re: [PERFORM] PostgreSQL and
Ultrasparc T1
On Tue, 20 Dec 2005, Alan Stange wrote:
David Lang wrote:
On Tue, 20 Dec 2005, Alan Stange wrote:
Jignesh K. Shah wrote:
I guess it depends on what you term as your metric for measurement.
If it is just one query execution time .. It may not be the best on
UltraSPARC T1.
But if you have mor
David Lang wrote:
On Tue, 20 Dec 2005, Alan Stange wrote:
Jignesh K. Shah wrote:
I guess it depends on what you term as your metric for measurement.
If it is just one query execution time .. It may not be the best on
UltraSPARC T1.
But if you have more than 8 complex queries running simultane
On Tue, 20 Dec 2005, Alan Stange wrote:
Jignesh K. Shah wrote:
I guess it depends on what you term as your metric for measurement.
If it is just one query execution time .. It may not be the best on
UltraSPARC T1.
But if you have more than 8 complex queries running simultaneously,
UltraSPARC
Jignesh K. Shah wrote:
I guess it depends on what you term as your metric for measurement.
If it is just one query execution time .. It may not be the best on
UltraSPARC T1.
But if you have more than 8 complex queries running simultaneously,
UltraSPARC T1 can do well compared comparatively prov
I guess it depends on what you term as your metric for measurement.
If it is just one query execution time .. It may not be the best on
UltraSPARC T1.
But if you have more than 8 complex queries running simultaneously,
UltraSPARC T1 can do well compared comparatively provided the
application ca
Jignesh,
On 12/19/05 12:21 PM, "Jignesh Shah" <[EMAIL PROTECTED]> wrote:
> extended device statistics
> r/sw/s Mr/s Mw/s wait actv wsvc_t asvc_t %w %b device
> 0.8 14.00.00.0 0.0 0.30.0 17.8 0 4 c3t0d0
>91.40.0 91.40.0 0.0
Jignesh,
On 12/19/05 12:21 PM, "Jignesh Shah" <[EMAIL PROTECTED]> wrote:
> I got about 720 MB/sec to 730 MB/sec with plain dd tests on my current
> storage configuration (8 LUNS on 4 fibers) which slowed me down (10K rpm 146
> GB disks FC) with 4 LUNS going through a longer pass to the disks (
Ok. That is what I wanted to know. Right now this database is a PostgreSQL
7.4.8 system. I am using it in a sort of DSS role. I have weekly summaries
of the sales for our division going back three years. I have a PHP based
webapp that I wrote to give the managers access to this data. The
,
Jignesh
- Original Message -
From: Luke Lonergan <[EMAIL PROTECTED]>
Date: Monday, December 19, 2005 2:38 pm
Subject: Re: [PERFORM] PostgreSQL and Ultrasparc T1
To: Jignesh Shah <[EMAIL PROTECTED]>
Cc: Juan Casero <[EMAIL PROTECTED]>, pgsql-performance@postgresql.org
> J
Jignesh,
On 12/19/05 11:29 AM, "Jignesh Shah" <[EMAIL PROTECTED]> wrote:
> I have gone to the max with 4 fibers on Sun Fire T2000. But I am not sure
> about the answers that you asked. Let me see if I can get answers for them. I
> am going to try to max out the IO on these systems with 8 fibers a
PostgreSQL, do let me know also with your
experience.
Regards,
Jignesh
- Original Message -
From: Luke Lonergan <[EMAIL PROTECTED]>
Date: Monday, December 19, 2005 12:31 pm
Subject: Re: [PERFORM] PostgreSQL and Ultrasparc T1
To: Jignesh Shah <[EMAIL PROTECTED]>
Cc: Ju
Jignesh,
On 12/19/05 6:27 AM, "Jignesh K. Shah" <[EMAIL PROTECTED]> wrote:
> Sun Fire T2000 has 3 PCI-E and 1PCI-X slot free when shipped. Using
> dual fiber channel 2G adapters you can get about 200MB x 8 = 1600MB/sec
> IO bandwidth. Plus when 4G HBAs are supported that will double up. Now I
>
ginal Message-
From: Jignesh K. Shah [mailto:[EMAIL PROTECTED]
Sent: Monday, December 19, 2005 9:27 AM
To: Luke Lonergan
Cc: Juan Casero; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] PostgreSQL and Ultrasparc T1
Sun Fire T2000 has 3 PCI-E and 1PCI-X slot free when shipped. Using
dual
Sun Fire T2000 has 3 PCI-E and 1PCI-X slot free when shipped. Using
dual fiber channel 2G adapters you can get about 200MB x 8 = 1600MB/sec
IO bandwidth. Plus when 4G HBAs are supported that will double up. Now I
think generally that's good enough for 1TB raw data or 2-3 TB Database
size. Of c
Juan,
On 12/18/05 8:35 AM, "Juan Casero" <[EMAIL PROTECTED]> wrote:
> Can anyone tell me how well PostgreSQL 8.x performs on the new Sun Ultrasparc
> T1 processor and architecture on Solaris 10? I have a custom built retail
> sales reporting that I developed using PostgreSQL 7.48 and PHP on a F
Title: RE: [PERFORM] PostgreSQL and Ultrasparc T1
From: [EMAIL PROTECTED] on behalf of Juan Casero
QUOTE:
Hi -
Can anyone tell me how well PostgreSQL 8.x performs on the new Sun Ultrasparc
T1 processor and architecture on Solaris 10? I have a custom built retail
sales reporting that I
On 12/18/05, Juan Casero <[EMAIL PROTECTED]> wrote:
> Can anyone tell me how well PostgreSQL 8.x performs on the new Sun Ultrasparc
> T1 processor and architecture on Solaris 10? I have a custom built retail
> sales reporting that I developed using PostgreSQL 7.48 and PHP on a Fedora
> Core 3 int
21 matches
Mail list logo
