Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bb1ns-0008GE-Og for pgsql-performance@arkaria.postgresql.org; Sat, 20 Aug 2016 08:38:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bb1nr-0003sc-EH for pgsql-performance@arkaria.postgresql.org; Sat, 20 Aug 2016 08:38:55 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bb1np-0003rw-6S for pgsql-performance@postgresql.org; Sat, 20 Aug 2016 08:38:53 +0000 Received: from md-in-15.webhostbox.net ([103.21.59.21]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bb1nl-0007Y7-EE for pgsql-performance@postgresql.org; Sat, 20 Aug 2016 08:38:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=ipathsolutions.co.in; s=default; h=Message-ID:Subject:To:From:Date: Content-Transfer-Encoding:Content-Type:MIME-Version; bh=K08gM2HnbWQVQTsFOBIIsFuF0lzqY/wViexy+CSwmIw=; b=S7ogZ0jiOQgD5Wm7w+1VIU496N yTjzeaFIt0hyYqkg20wgyngy6FZ4iA6dUtfrf52cqCoVBseuCeIufPoiv1RigrLHA9t29F/GhnohT 0XHKkf11vtPelGb0K8gsOxkhl2V2Q3UHffCHyXqkizpFDbuL+EDfszl9Ebymm8sXd3pTOa+BWW3pS f38GZ0vHAkho6Q8PiNYNr/s03Gctsogwn7kT8GsfYvZ0ILqaghb4pTbZ+WqTY9RYtDJ6bqxl4y3W2 ygSBjOK+5b15icnJDGG1FoVKvFIPpeXK0Uoas5jxSf8m1TXgoFNscXjxtqyH+XSfA78EzPBiXsZyB 74hORnSA==; Received: from [127.0.0.1] (port=35291 helo=ipathsolutions.co.in) by md-in-15.webhostbox.net with esmtpa (Exim 4.86_1) (envelope-from ) id 1bb1nf-000brE-MU for pgsql-performance@postgresql.org; Sat, 20 Aug 2016 08:38:44 +0000 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Sat, 20 Aug 2016 08:38:43 +0000 From: debasis.moharana@ipathsolutions.co.in To: pgsql-performance@postgresql.org Subject: pgsql-performance issue Message-ID: X-Sender: debasis.moharana@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: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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