We could notice your processor is an Intel Celeron. They have a small cache, as you can see for yourself in your output.
But, what about postgresql.conf ? How many memory resources are being assigned in your configuration?
If you only have 1.25 GB of RAM and you're creating a tablespace in RAM which holds a table about 0.8 GB in size, and have created indexes in the same tablespace in RAM, you could be getting out of RAM. vmstat says you're not using swap, but if you leave the postgresql process only ~100 MB of RAM, it surely will have a bad performance.
Once the server is up and running, which is the output of free ?
Which tool are you using to retrieve data ? psql is pretty much faster than phpPgAdmin and this one is faster than pgAdmin.
Elvis E. Henríquez A.
On Wed, Mar 26, 2008 at 4:18 AM, sathiya psql <sathiya.psql@xxxxxxxxx> wrote:
yes, i have both the index and primary key on a column "id",On Tue, Mar 25, 2008 at 2:11 PM, CZUCZY Gergely <gergely.czuczy@xxxxxxxxxxx> wrote:May I ask, do you have any indeces or a primary key on that table?
and am doing the
SELECT count(id) from TABLE;
this is taking 3 seconds
