Re: [PERFORM] my boss want to migrate to ORACLE

2004-07-30 Thread Scott Marlowe
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

Re: [PERFORM] my boss want to migrate to ORACLE

2004-07-30 Thread Christopher Browne
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

Re: [PERFORM] my boss want to migrate to ORACLE

2004-07-30 Thread Brian Hirt
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

Re: [PERFORM] my boss want to migrate to ORACLE

2004-07-30 Thread Dan Langille
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

Re: [PERFORM] my boss want to migrate to ORACLE

2004-07-30 Thread Matthew T. O'Connor
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

Re: [PERFORM] Optimizer refuses to hash join

2004-07-30 Thread Tom Lane
Stan Bielski <[EMAIL PROTECTED]> writes: > On Thu, 29 Jul 2004, Tom Lane wrote: >> Are you sure the join condition is hashjoinable? You didn't say >> anything about the datatypes involved ... > My apologies. The columns that I want to join are both type 'inet'. > Shouldn't that be hashjoinable?

Re: [PERFORM] my boss want to migrate to ORACLE

2004-07-30 Thread Scott Marlowe
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: > > 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 > rai

Re: [PERFORM] my boss want to migrate to ORACLE

2004-07-30 Thread Merlin Moncure
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,

Re: [PERFORM] my boss want to migrate to ORACLE

2004-07-30 Thread Stephane Tessier
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,data, etc) for each

Re: [PERFORM] my boss want to migrate to ORACLE

2004-07-30 Thread Jeff
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