Postgres 8.3.* Tuning Parameters

pawanshirbhate
pawanshirbhate used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015

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

Author

Commented:
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.
Top Expert 2015

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

JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

consider looking at pgfoundry project pg_bulkload
Top Expert 2015
Commented:
Do in parallel, postgresql is not SMP for single SQL session.
Top Expert 2015

Commented:
Not enough input.

Author

Commented:
not enough solutions has been provided.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial