<div>
Thanks adrpo. No, I am not using cygwin to run PostgreSQL. Why would I need it?<br />
I have just downloaded the windows installer for postgreSQL and used it. It worked fine and the database works well too.
</div>


Thanks adrpo. No, I am not using cygwin to run PostgreSQL. Why would I need it?
I have just downloaded the windows installer for postgreSQL and used it. It worked fine and the database works well too.

<div>
<br />
My bad. I sow now that they made a MinGW-based version.<br />
Sorry about that. However, you can still play with points 2 and 3 from my last post.<br />
<br />
Cheers,<br />
za-k/
</div>



My bad. I sow now that they made a MinGW-based version.
Sorry about that. However, you can still play with points 2 and 3 from my last post.

Cheers,
za-k/

<div>
Ok thanks adrpo, will have a look at those links and see if it makes things any better.
</div>


Ok thanks adrpo, will have a look at those links and see if it makes things any better.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I would like to optimize postgres for the best possible performance for a single query. I am not going to use it in a multi-user environment, but performance of a single query is most important.<br />
Could someone suggest correct config settings for PostgreSQL 8.2 for the following hardware:<br />
Dell PowerEdge 2900, 1 Xeon 2.6GHz Quad-Core processor, 16GB memory, 4 RAID0 15000RPM SAS hard-disks, Windows 2003 R2 64Bit Server Edition (default configuration).<br />
When I just use the default config file, I have a feeling postgres is not even using a 0.1% of the given resources, especially in terms of memory. 
</div>
</div>


Hi,
I would like to optimize postgres for the best possible performance for a single query. I am not going to use it in a multi-user environment, but performance of a single query is most important.
Could someone suggest correct config settings for PostgreSQL 8.2 for the following hardware:
Dell PowerEdge 2900, 1 Xeon 2.6GHz Quad-Core processor, 16GB memory, 4 RAID0 15000RPM SAS hard-disks, Windows 2003 R2 64Bit Server Edition (default configuration).
When I just use the default config file, I have a feeling postgres is not even using a 0.1% of the given resources, especially in terms of memory. 

How to optimize PostgreSQL for a 16GB RAM Quad-Core machine?

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.