MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Sat, 20 Aug 2016 08:27:09 +0000
From: debasis.moharana@ipathsolutions.co.in
To: pgsql-performance@postgresql.org
Subject: pgsql-performance issue
Message-ID: <cf406bd128ace3d719173585dc5b6a79@ipathsolutions.co.in>
User-Agent: Roundcube Webmail/1.0.6
X-Authenticated_sender: debasis.moharana@ipathsolutions.co.in
X-OutGoing-Spam-Status: No, score=-1.0
X-AntiAbuse: This header was added to track abuse,
 please include it with any abuse report
X-AntiAbuse: Primary Hostname - md-in-15.webhostbox.net
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - ipathsolutions.co.in
X-Get-Message-Sender-Via: md-in-15.webhostbox.net: authenticated_id:
 debasis.moharana@ipathsolutions.co.in
X-Authenticated-Sender: md-in-15.webhostbox.net:
 debasis.moharana@ipathsolutions.co.in
X-Source: 
X-Source-Args: 
X-Source-Dir: 
X-Pg-Spam-Score: -0.0 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On 2016-08-20 08:21, pgsql-performance-owner@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 majordomo@postgresql.org:
> 
> approve x8DiA6 unsubscribe pgsql-performance
> debasis.moharana@ipathsolutions.co.in
> 
> This command will work even if your address changes.  For that reason,
> among others, it is important that you keep a copy of this message.
> 
> To post a message to the mailing list, send it to
>   pgsql-performance@postgresql.org
> 
> If you need help or have questions about the mailing list, please
> contact the people who manage the list by sending a message to
>   pgsql-performance-owner@postgresql.org
> 
> You can manage your subscription by visiting the following WWW 
> location:
> 
> <https://lists.postgresql.org/mj/mj_wwwusr/domain=postgresql.org/debasis.moharana%40ipathsolutions.co.in>
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:

max_connections = 100
shared_buffers = 512MB
effective_cache_size = 3GB
work_mem = 12233kB
maintenance_work_mem = 256MB
min_wal_size = 1GB max_wal_size = 2GB
checkpoint_completion_target = 0.7
wal_buffers = 16MB
default_statistics_target = 100

After setting in postgresql.conf. I run the select query to fetch large 
amount of record of 29000 in postgresql but it takes 10.3 seconds but 
the same query takes 2 seconds for execution in MSSQL.

So my query is how to improve the perfermance in postgresql.

Regards,
Debasis Moharana
.NET Software Developer


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance