ok
On Tue, Mar 25, 2008 at 5:33 PM, Alvaro Herrera <[EMAIL PROTECTED]>
wrote:
> Please stop reposting your questions to multiple groups. Since all your
> questions are about performance, please stick to the pgsql-performance
> list. Posting to pgsql-sql is not really appropriate, and in
> pgsql
Please stop reposting your questions to multiple groups. Since all your
questions are about performance, please stick to the pgsql-performance
list. Posting to pgsql-sql is not really appropriate, and in
pgsql-admin you're totally off-topic.
--
Alvaro Herrerahttp
On 2008-03-25 09:51, sathiya psql wrote:
> Table size is nearly 700 MB,
> and my machine had a 1 GB + 256 MB RAM, i had created the table space in
> RAM, and then created this table in this RAM.
>
> So now everything is in RAM, if i do a count(*) on this table it returns
> 327600 in 3 seconds,
I have a table with 32 lakh record in it. Table size is nearly 700 MB,
and my machine had a 1 GB + 256 MB RAM, i had created the table space in
RAM, and then created this table in this RAM.
So now everything is in RAM, if i do a count(*) on this table it returns
327600 in 3 seconds, why i