Praveen Kumar N wrote: > > one more doubt.in the following example we dont need sort right.But in > this case also relations were scanned sequentially one by one.
In this case it's because the result from one seqscan was materialized. > So is it the > case that any relation is accessed only once from database while executing > a given query? Not in general -- you'll see that behavior only in particular cases. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings