Hello,
we have a PostgreSQL for datawarehousing. As we heard of so many
enhancements
for 8.0 and 8.1 versions we dicided to upgrade from 7.4 to 8.1. I must say
that the COPY FROM processes are much faster now from 27 to 17 minutes. Some
queries where slower, but the performance
On Tue, Dec 27, 2005 at 05:09:28PM +0100, Albert Cervera Areny wrote:
However, now we have a query that is much slower with 8.1 compared to
7.4.
The query lasts 7minutes (all the times we try) with 8.1, keeping CPU usage
at 93~97% while it lasts 25 seconds in 7.4 the first time going
A Dimarts 27 Desembre 2005 18:13, Michael Fuhr va escriure:
On Tue, Dec 27, 2005 at 05:09:28PM +0100, Albert Cervera Areny wrote:
However, now we have a query that is much slower with 8.1 compared to
7.4. The query lasts 7minutes (all the times we try) with 8.1, keeping
CPU usage at
On Tue, 27 Dec 2005 19:02:17 +0100
Albert Cervera Areny [EMAIL PROTECTED] wrote:
Are there any rules of thumb to let a begginer give reasonable
values to these parameters? Not only work_mem, but also
random_page_cost, and so on. Are there any tests one can run to
determine good values?