[EMAIL PROTECTED] writes: > On 22 Sep, Greg Stark wrote: > > Are those response times in the right unit? 7-10s? > > The plans (http://developer.osdl.org/markw/74/db/plan0.out) don't show > any table scans. They appears to be mostly index scans. There aren't > any batch updates.
Would it be easy to generate this file doing "explain analyze" instead? It would give me a better idea what you're doing since I don't know much about the data. Just looking at the plans I don't see how any of these queries could possibly take 7s. There are two that could possibly take a few hundred milliseconds, the others I would expect to be under 100ms. Obviously this is all just a gut reaction, not having looked at the data, and it would depend on the hardware. But none of the queries look like they should measuring reaction times in seconds. > Right, and when this thing is tuned better, I expect the transactions to > be down in the 20-200ms range. I do have about 70 drives for the > database, so it really shouldn't be i/o bound at with the size of the > database I'm using now, which is about 20 or 30 GB. 70 drives for 20-30G? That's pretty extreme. -- greg ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match