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. ________________________________________________________________________
