Regarding Raid5 at all, you might want to look at http://www.baarf.com
Stephane Tessier [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I think with your help guys I'll do it!
I'm working on it!
I'll work on theses issues:
we have space for more ram(we use 2 gigs on possibility
:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: 29 juillet, 2004 23:00
To: Stephane Tessier
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] my boss want to migrate to ORACLE
A furthur thought or two:
- you are *sure* that it is Postgres that is slow? (could be Php...or your
machine
Stephane Tessier wrote:
I checked and we have a 128 megs battery backed cache on the raid
controller...
we have space for more ram(we use 2 gigs on possibility of 3 gigs)
iowait is very high 98% -- look like postgresql wait for io access
raid5 --raid0 if i'm right raid5 use 4 writes(parity,data,
oups,
i changed for RAID 10(strip and mirror)
-Original Message-
From: James Thornton [mailto:[EMAIL PROTECTED]
Sent: 2 aout, 2004 17:32
To: Stephane Tessier
Cc: 'Scott Marlowe'; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [PERFORM] my boss want to migrate to ORACLE
Stephane
It may be worth pricing up expansion options e.g. 256M or more.
The other path to consider is changing RAID5 - RAID10 if your card supports it.
However, I would recommend reducing that shared_buffers setting and doing your
performance measurements *again* - before changing anything else. This is
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: 29 juillet, 2004 23:00
To: Stephane Tessier
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] my boss want to migrate to ORACLE
A furthur thought or two:
- you are *sure
On Jul 28, 2004, at 1:08 PM, Stephane Tessier wrote:
we have a BIG problem of performance,it's slow
Can you isolate which part is slow? (log_min_duration is useful for
finding your slow running queries)
we use postgres 7.3 for php security application with approximately 4
millions of
day
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: 29 juillet, 2004 23:00
To: Stephane Tessier
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] my boss want to migrate to ORACLE
A furthur thought or two:
- you are *sure
Stephane wrote:
Hi everyone,
somebody can help me??? my boss want to migrate to ORACLE
#fsync = true
[snip]
Are you using battery baked RAID?
Your problem is probably due to the database syncing all the time. With fsync one,
you get 1 sync per transaction that
]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: 29 juillet, 2004 23:00
To: Stephane Tessier
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] my boss want to migrate to ORACLE
A furthur thought or two:
- you are *sure* that it is Postgres that is slow? (could be Php...or your
Stephane Tessier wrote:
I think with your help guys I'll do it!
I'm working on it!
I'll work on theses issues:
we have space for more ram(we use 2 gigs on possibility of 3 gigs)
iowait is very high 98% -- look like postgresql wait for io access
raid5 --raid0 if i'm right raid5 use 4
On Fri, 30 Jul 2004, Matthew T. O'Connor wrote:
Stephane Tessier wrote:
I think with your help guys I'll do it!
I'm working on it!
I'll work on theses issues:
we have space for more ram(we use 2 gigs on possibility of 3 gigs)
iowait is very high 98% -- look like postgresql wait for
pg_autovacuum is a daemon, not something that get's run twice a day.
I think that's what the question Matthew was getting @. I'm not sure
what would happen to performance if pg_autovacuum was launched twice a
day from cron, but you could end up in an ugly situation if it starts
up.
--brian
After a long battle with technology, [EMAIL PROTECTED] (Stephane Tessier), an
earthling, wrote:
I think with your help guys I'll do it!
I'm working on it!
I'll work on theses issues:
we have space for more ram(we use 2 gigs on possibility of 3 gigs)
That _may_ help; not completely clear.
On Fri, 2004-07-30 at 19:22, Christopher Browne wrote:
After a long battle with technology, [EMAIL PROTECTED] (Stephane Tessier), an
earthling, wrote:
I think with your help guys I'll do it!
I'm working on it!
I'll work on theses issues:
we have space for more ram(we use 2 gigs on
On Thu, 29 Jul 2004 03:08 am, Stephane Tessier wrote:
Hi everyone,
somebody can help me??? my boss want to migrate to
ORACLE
we have a BIG problem of performance,it's slow
we use postgres 7.3 for php security application with approximately 4
millions of insertion by
Quoting Stephane Tessier [EMAIL PROTECTED]:
General parameter suggestions:
shared_buffers = 128000 # min max_connections*2 or 16, 8KB each
effective_cache_size = 196608 # typically 8KB each
Try reducing shared_buffers (say 3). There has been much discussion regards
setting this
A furthur thought or two:
- you are *sure* that it is Postgres that is slow? (could be Php...or your
machine could be out of some resource - see next 2 points)
- is your machine running out of cpu or memory?
- is your machine seeing huge io transfers or long io waits?
- are you running Php on
18 matches
Mail list logo
