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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
