Skip site navigation (1) Skip section navigation (2)

Re: tuning questions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jack Coates <jack(at)lyris(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: tuning questions
Date: 2003-12-08 19:19:58
Message-ID: 22185.1070911198@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Jack Coates <jack(at)lyris(dot)com> writes:
> Theories at this point, in no particular order:

> a) major differences between my 7.3.4 from source (compiled with no
> options) and dev's 7.3.2-1PGDG RPMs. Looking at the spec file doesn't
> reveal anything glaring to me, but is there something I'm missing?

There are quite a few performance-related patches between 7.3.2 and
7.3.4.  Most of them should be in 7.3.4's favor but there are some
places where we had to take a performance hit in order to have a
suitably low-risk fix for a bug.  You haven't told us enough about
the problem to know if any of those cases apply, though.  AFAIR
you have not actually showed either the slow query or EXPLAIN ANALYZE
results for it on the two boxes ...

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Neil ConwayDate: 2003-12-09 08:32:24
Subject: Re: Problem with insert into select...
Previous:From: Vivek KheraDate: 2003-12-08 18:41:12
Subject: Re: autovacuum daemon stops doing work after about an hour

pgsql-hackers by date

Next:From: Kurt RoeckxDate: 2003-12-08 19:28:30
Subject: Re: CVS HEAD compile failure
Previous:From: Jan WieckDate: 2003-12-08 19:17:24
Subject: Re: CVS HEAD compile failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group