Ühel kenal päeval, K, 2006-01-18 kell 22:35, kirjutas uwcssa: > I am testing the performance of postgresql on a set of workloads. > However, > the output significantly affects the performance evaluation. Is there > a way > to by-pass all output of select statements so the timing reflects only > the > query evaluation process?
If you do EXPLAIN ANALYSE QUERY instead of just QUERY, then the backend discards all rows returned and just gives back performance data ------------------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings