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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
