Hi
All,
Thank you all in
advance for your answers.
My application does bulk inserts on a table (50,000 rows
concurrently by 10 threads), There are 3 indexes on the table whose update takes
a lot of time. (Deleting those indexes speeds up inserts).
One thing I have
noticed in my task manager is paging. I have got enough of memory available on
the system. The system cache is high. However I still see a lot of paging going
on. (PF Delta column for postgres processes in the windows task
manager).
I tried to
tweak various postgres settings without any results. Could any one suggest me
how can I force postgres to use up the available memory?
I have changed
following settings already
shared_buffers
effective_cache_size
work_mem
wal_buffers
commit_delay
checkpoint_segments
Thanks,
rangde.
________________________________________________________________________
This email has been scanned for all known viruses by the MessageLabs Email Security Service and the Macro 4 plc internal virus protection system.
________________________________________________________________________
