It is difficult to read your e-mails.
Ramesh T wrote:
>> When this thread started you said you where selecting 20 rows.
>
> Yes.
>> Which is correct 20 rows or columns and if columns how many rows?
>
> Yes,I did selected 20 columns from two tables.
>> Where are you measuring this time?
>
> Here is the query plan,
> http://explain.depesz.com/s/EeYT
This explain output says that you selected 699560 rows.
But 11 seconds seems long for that.
How fast is your I/O system and your CPU?
Yours,
Laurenz Albe