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
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
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
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
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
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
10 matches
Mail list logo