>> 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 ?

How long is a piece of string?

It depends what you are doing, whether you have indexes, how the tables
are arranged, and how good the statistics are. Postgres has available to
it almost all of the best data handling algorithms, and generally it uses
them sensibly. Use the EXPLAIN tool to get Postgres to tell you how it
will execute a query. Read the manual.

We have people running databases with an arawb (thousand million) or more
rows without any significant performance problems. However, if you tell
Postgres to read the entire table (like doing SELECT COUNT(*) FROM table),
it will obviously take time.

Matthew

--
In the beginning was the word, and the word was unsigned,
and the main() {} was without form and void...

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance