Date: Mon, 29 Aug 2016 13:14:03 -0700
From: Andres Freund <andres@anarazel.de>
To: debasis.moharana@ipathsolutions.co.in
Cc: pgsql-performance@postgresql.org
Subject: Re: pgsql-performance issue
Message-ID: <20160829201403.gijea6hlcaceejby@alap3.anarazel.de>
References: <fb03078a83259284debd919dc7a3d6dd@ipathsolutions.co.in>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <fb03078a83259284debd919dc7a3d6dd@ipathsolutions.co.in>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hi,

On 2016-08-20 08:38:43 +0000, debasis.moharana@ipathsolutions.co.in wrote:
> 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.

Please provide the output EXPLAIN (ANALYZE, BUFFERS) yourquery; and your
query. Then we'll possibly be able to help you - atm we don't have
enough information.

Regards,

Andres


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