th maximum number of records in one PostreSQL table ist unlimited:
am asking for good performance, not just limitation..
If i have half a crore record, how the performance will be ?
If i have half a crore record, how the performance will be ?
http://www.postgresql.org/about/
[for some values of unlimited]
Some further help:
googling for:
postgresql limits site:postgresql.org
but i need some experimentation result...
I have 1 GB RAM with Pentium Celeron.
50 lakh records and postgres performance is not good....
It takes 30 sec for simple queries....
I have 1 GB RAM with Pentium Celeron.
50 lakh records and postgres performance is not good....
It takes 30 sec for simple queries....