From: shaiju.ck <shaiju.ck@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Select * is very slow
Date: Sun, 7 Nov 2010 22:16:56 -0800 (PST)
Message-ID: <1289197016462-3254568.post@n5.nabble.com> (raw)
Hi,
I have a table employee with 33 columns.
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.
Why the query is slow if I included all the columns in the table.
As per my understanding , number of columns should not be having a major
impact on the query performance.
I have increased the shared_buffres to 1024MB, but no improvement.
I have noticed that the query "show shared_buffers" always show 8MB.Why is
this? Does it mean that changing the shared_buffers in config file have no
impact?
Can anybody help?
Shaiju
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Select-is-very-slow-tp3254568p3254568.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: shaiju.ck@gmail.com
Subject: Re: Select * is very slow
In-Reply-To: <1289197016462-3254568.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox