Re: [PERFORM] Optimizing PostgreSQL for Windows

2007-10-31 Thread Christian Rengstl
gets faster again. Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Tue, Oct 30, 2007 at 8:21 PM, in message <[EMAIL PROTE

[PERFORM] Optimizing PostgreSQL for Windows

2007-10-30 Thread Christian Rengstl
2500MB, but nevertheless the query takes about 38 seconds to finish. The table "table1" contains approx. 3 million tuples and table2 approx. 500.000 tuples. If anyone could give an advice on either how to optimize the settings in postgresql.conf or anything else to make this query r