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" value
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 usag
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 goi
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 problems
