Praveen Kumar N wrote:
> one more 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                      
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to