Naresh Soni <jmnaresh@gmail.com> wrote:
> So you mean postgres can handle such huge records without any
> fine tuning required on postgres
For any non-trivial database you will certainly need to make
adjustments to the configuration files, and probably to the OS,
too. You may want to pay for some advice from one of the companies
with people experienced in tuning PostgreSQL, but you can get a
good start on things with the advice on this Wiki page:
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
You should also familiarize yourself with the PostgreSQL
documentation on the topic:
http://www.postgresql.org/docs/current/interactive/runtime-config.html
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company