<div>
increase wal segment count and disable disk synch-ing.<br />
you can remove and recreate indexes for batch insertion.<br />
indexes slow down insert and update, but are of help with retrieval. yes - A vs B and you cannot fix it.<br />
<br />
Have you done any runing or you go with default?<br />
<br />

</div>


increase wal segment count and disable disk synch-ing.
you can remove and recreate indexes for batch insertion.
indexes slow down insert and update, but are of help with retrieval. yes - A vs B and you cannot fix it.

Have you done any runing or you go with default?



<div>
i have already did some tuning and with that i am getting 30K per seconds. i read various blogs for that.<br />
<br />
if you know any recommended tuning to achieve higher insertion rate then please let me know.
</div>


i have already did some tuning and with that i am getting 30K per seconds. i read various blogs for that.

if you know any recommended tuning to achieve higher insertion rate then please let me know.

<div>
what is your filesystem (mount -v) and your postgresql.conf ?<br />
<br />

</div>


what is your filesystem (mount -v) and your postgresql.conf ?



<div>
not enough solutions has been provided.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Can anybody help in tuning postgres 8.3.* version on Solaris 10 (sparc) to achieve higher insertion &amp;&nbsp;retrieval speed?<br />
<br />
Currently, i can insert 30K records/sec, whereas, i want to achieve ~2 Million records/sec.<br />
<br />
I would really appreciate your help in this regard.<br />
<br />
-Pawan
</div>
</div>


Hello,

Can anybody help in tuning postgres 8.3.* version on Solaris 10 (sparc) to achieve higher insertion & retrieval speed?

Currently, i can insert 30K records/sec, whereas, i want to achieve ~2 Million records/sec.

I would really appreciate your help in this regard.

-Pawan

Postgres 8.3.* Tuning Parameters

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.