Re: [PERFORM] Slow UPADTE, compared to INSERT

2003-12-06 Thread Neil Conway
Shridhar Daithankar <[EMAIL PROTECTED]> writes: > This is not a bug. It is just that people find it confusing when > postgresql planner consider seemingly same type as different. It certainly is a bug, or at least a deficiency: PostgreSQL planner *could* use the index to process the query, but the

Re: [PERFORM] query using cpu nearly 100%, why?

2003-12-06 Thread Neil Conway
LIANHE SHAO <[EMAIL PROTECTED]> writes: > Hello, I use php as front-end to query our database. When I use > System Monitor to check the usage of cpu and memory, I noticed that > the cpu very easily gets up to 100%. Is that normal? if not, could > someone points out possible reason? You haven't giv

Re: [PERFORM] query using cpu nearly 100%, why?

2003-12-06 Thread Richard Huxton
On Friday 05 December 2003 21:03, LIANHE SHAO wrote: > Hello, > I use php as front-end to query our database. When I use System Monitor to > check the usage of cpu and memory, I noticed that the cpu very easily gets > up to 100%. Is that normal? if not, could someone points out possible > reason?

[PERFORM] Pgbench results

2003-12-06 Thread Rob Sell
Greetings all, I'm wondering is there a website where people can submit their pgbench results along with their hardware and configuration's? If so where are they at? I have yet to find any. I think this could be a very useful tool not only for people looking at setting up a new server but for peo

Re: [PERFORM] Has anyone run on the new G5 yet

2003-12-06 Thread Bruce Momjian
Paul Tuckfield wrote: > Biggest problem I've had in the past w. linux in general is that it > seems to make poor VM choices under heavy filesystem IO. I don't really > get exactly where it's going wrong , but I've had numerous experiences > on older systems where bursty IO would seem to cause pagi