Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread Pavel Stehule
2016-08-20 14:17 GMT+02:00 : > On 2016-08-20 12:05, Pavel Stehule wrote: > >> 2016-08-20 13:59 GMT+02:00 : >> >> On 2016-08-20 11:42, Pavel Stehule wrote: >>> >>> 2016-08-20 13:31 GMT+02:00 : >>> >>> On 2016-08-20 08:58, Pavel Stehule wrote: >>> 2016-08-20 10:27 GMT+02:00 : >>> >>> On 2016-08-20 0

Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
On 2016-08-20 12:05, Pavel Stehule wrote: 2016-08-20 13:59 GMT+02:00 : On 2016-08-20 11:42, Pavel Stehule wrote: 2016-08-20 13:31 GMT+02:00 : On 2016-08-20 08:58, Pavel Stehule wrote: 2016-08-20 10:27 GMT+02:00 : On 2016-08-20 08:21, pgsql-performance-ow...@postgresql.org wrote: Welcome to

Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread Pavel Stehule
2016-08-20 13:59 GMT+02:00 : > On 2016-08-20 11:42, Pavel Stehule wrote: > >> 2016-08-20 13:31 GMT+02:00 : >> >> On 2016-08-20 08:58, Pavel Stehule wrote: >>> 2016-08-20 10:27 GMT+02:00 : >>> >>> On 2016-08-20 08:21, pgsql-performance-ow...@postgresql.org wrote: >>> >>> Welcome to the pgsql-perfor

Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
On 2016-08-20 11:42, Pavel Stehule wrote: 2016-08-20 13:31 GMT+02:00 : On 2016-08-20 08:58, Pavel Stehule wrote: 2016-08-20 10:27 GMT+02:00 : On 2016-08-20 08:21, pgsql-performance-ow...@postgresql.org wrote: Welcome to the pgsql-performance mailing list! Your password at PostgreSQL Mailing L

Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread Pavel Stehule
2016-08-20 13:31 GMT+02:00 : > On 2016-08-20 08:58, Pavel Stehule wrote: > >> 2016-08-20 10:27 GMT+02:00 : >> >> On 2016-08-20 08:21, pgsql-performance-ow...@postgresql.org wrote: >>> >>> Welcome to the pgsql-performance mailing list! Your password at PostgreSQL Mailing Lists is x8D

Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
On 2016-08-20 08:58, Pavel Stehule wrote: 2016-08-20 10:27 GMT+02:00 : On 2016-08-20 08:21, pgsql-performance-ow...@postgresql.org wrote: Welcome to the pgsql-performance mailing list! Your password at PostgreSQL Mailing Lists is x8DiA6 To leave this mailing list, send the following command

Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread Pavel Stehule
2016-08-20 10:27 GMT+02:00 : > On 2016-08-20 08:21, pgsql-performance-ow...@postgresql.org wrote: > >> Welcome to the pgsql-performance mailing list! >> Your password at PostgreSQL Mailing Lists is >> >> x8DiA6 >> >> To leave this mailing list, send the following command in the body >> of a messag

[PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
Dear Sir/Mam, I have a PostgreSQL 9.5 instance running on Windows 8 machine with 4GB of RAM.This server is mainly used for inserting/updating large amounts of data via copy/insert/update commands, and seldom for running select queries. Here are the relevant configuration parameters I changed

[PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
On 2016-08-20 08:21, pgsql-performance-ow...@postgresql.org wrote: Welcome to the pgsql-performance mailing list! Your password at PostgreSQL Mailing Lists is x8DiA6 To leave this mailing list, send the following command in the body of a message to majord...@postgresql.org: approve x8DiA6 unsu