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:
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:
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.