Hello, I am new to PSQL 10 and don't know how to define its configuration for optimization.
The server has an Intel Xeon CPU - 3.40 GHz, 1 GB of RAM and runs Windows Server 2003 SP2. My database is small - about 4 MB.
In PCC, I use an SQL query that takes 2 minutes to perform. The Windows Performance utility shows that the processor use is about 50% and the memory and disk accesses are minimal.
How can I speed up this process? What PSQL definitions should I alter? Do I need to optimize the SQL query?
Thank you very much for any advice.
Pedro

Pedro, read the section on the "Sql Engine Reference" manual that has to do with the Query Plan Viewer.  The Query Plan Viewer will help you analyze your query.  For example, is your query making use of an index, how many records is it bringing back, etc.

Jose. 

Thanks for your hint Jose. I'll try to analyse the query as you say.

Pedro