"shaiju.ck" <shaiju.ck@xxxxxxxxx> wrote: > The table have 200 records now. > Select * from employee takes 15 seconds to fetch the data!!! > Which seems to be very slow. > But when I say select id,name from empoyee it executes in 30ms. > Same pefromance if I say select count(*) from emloyee. You haven't given nearly enough information for anyone to diagnose the issues with any certainty. Earlier responses have asked for some particularly important information, and I would add a request to see the output from `VACUUM VERBOSE employee;`. Beyond that, you might want to review this page for checks you can make yourself, and information which you could provide to allow people to give more informed advice: http://wiki.postgresql.org/wiki/SlowQueryQuestions -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance