From: debasis.moharana@ipathsolutions.co.in
To: pgsql-performance@postgresql.org
Subject: pgsql-performance issue
Date: Sat, 20 Aug 2016 08:38:43 +0000
Message-ID: <fb03078a83259284debd919dc7a3d6dd@ipathsolutions.co.in> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: debasis.moharana@ipathsolutions.co.in
Subject: Re: pgsql-performance issue
In-Reply-To: <fb03078a83259284debd919dc7a3d6dd@ipathsolutions.co.in>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox