sathiya psql escribió:
> I have 1 GB RAM with Pentium Celeron.
> 50 lakh records and postgres performance is not good....
>
> It takes 30 sec for simple queries....
Shows us the explain analyze. There is no problem with a large number
of records, as long as you're not expecting to process all of them all
the time.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.