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

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 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

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 raid5

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? Depends

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

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 postgresql wait for

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 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 clear.

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(we use 2 gigs on