"madhtr" <madhtr@xxxxxxxxx> writes: > From: "Tom Lane" <tgl@xxxxxxxxxxxxx> >> ... although it takes a good long while (several seconds) because of the >> "sleep(1)" in the interaction with the postmaster. > Sleep(1) should be only 1/1000 of a second. I do that so I don't hammer the > processor with my while loop when i am not using a select(). Ah. I was interpreting it in Unix terms, where sleep() measures in seconds. With a wait of a few msec it might not be too intolerable. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match