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 p
MAIL PROTECTED]
> Subject: Re: [PERFORM] my boss want to migrate to ORACLE
>
>
> On Fri, 2004-07-30 at 07:56, Stephane Tessier wrote:
> > I think with your help guys I'll do it!
> >
> > I'm working on it!
> >
> > I'll work on theses issues:
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
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 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,
running at 12 and 24 hour each 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 w
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
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
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
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 pos
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 writes(parity
nning at 12 and 24 hour each 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
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 updates,
ing at 12 and 24 hour each 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:
-
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 inserti
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 th
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 t
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 inser
18 matches
Mail list logo
