Re: [PERFORM] Quick question about top...

2006-06-21 Thread Steinar H. Gunderson
On Wed, Jun 21, 2006 at 04:46:15PM -0400, Alex Turner wrote: > I have a really stupid question about top, what exactly is iowait CPU time? Time while the CPU is idle, but at least one I/O request is outstanding. In other words, if you're at 100% I/O-wait, you're heavily I/O-bound and your process

[PERFORM] Quick question about top...

2006-06-21 Thread Alex Turner
I have a really stupid question about top, what exactly is iowait CPU time?Alex

Re: [PERFORM] Quick question

2003-09-08 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > Back in the 7.0 days, > WHERE EXISTS (SELECT * FROM a WHERE condition) > was significantly slower on broad tables than > WHERE EXISTS (SELECT small_col FROM a WHERE condition) > Is this still true, or something that's been fixed in the last 3 versions?

[PERFORM] Quick question

2003-09-08 Thread Josh Berkus
Tom, Back in the 7.0 days, WHERE EXISTS (SELECT * FROM a WHERE condition) was significantly slower on broad tables than WHERE EXISTS (SELECT small_col FROM a WHERE condition) Is this still true, or something that's been fixed in the last 3 versions? Joe Celko is making fun of me because Ora