-Original Message-
From: Patrick Donlin [mailto:pdon...@oaisd.org]
Sent: Thursday, July 15, 2010 11:13 AM
To: Kevin Grittner; pgsql-performance@postgresql.org
Subject: Re: Identical query slower on 8.4 vs 8.3
I'll read over that wiki entry, but for now here is the
EXPLAIN
I'd suggest to increase the value up to ~80MB, if not for the system,
may be just for the session running this query.
Then see if performance improved.
Don't forget you can do this for the given query without affecting the
other queries - just do something like
SET work_mem = 128M
and then
I have two servers with equal specs, one of them running 8.3.7 and the new
server running 8.4.4. The only tweak I have made from the default install (from
Ubuntu repositories) is increasing shared_buffers to 768MB. Both servers are
running 64-bit, but are different releases of Ubuntu.
This is
On 15 July 2010 15:41, Patrick Donlin pdon...@oaisd.org wrote:
I have two servers with equal specs, one of them running 8.3.7 and the new
server running 8.4.4. The only tweak I have made from the default install
(from Ubuntu repositories) is increasing shared_buffers to 768MB. Both
servers are
Patrick Donlin pdon...@oaisd.org wrote:
Anyone have any ideas on where I should start looking to figure
this out?
You're going to want to run EXPLAIN ANALYZE for the slow query on
both servers. If you want the rest of us to be able to contribute
ideas, we'll need a little more information
: [PERFORM] Identical query slower on 8.4 vs 8.3
Patrick Donlin pdon...@oaisd.org wrote:
Anyone have any ideas on where I should start looking to figure
this out?
You're going to want to run EXPLAIN ANALYZE for the slow query on
both servers. If you want the rest of us to be able to contribute
Excerpts from Patrick Donlin's message of jue jul 15 11:12:53 -0400 2010:
I'll read over that wiki entry, but for now here is the EXPLAIN ANALYZE
output assuming I did it correctly. I have run vacuumdb --full --analyze, it
actually runs as a nightly cron job.
These plans seem identical
To: Patrick Donlin pdon...@oaisd.org, pgsql-performance@postgresql.org
Sent: Thursday, July 15, 2010 10:55:19 AM GMT -05:00 US/Canada Eastern
Subject: Re: [PERFORM] Identical query slower on 8.4 vs 8.3
Patrick Donlin pdon...@oaisd.org wrote:
Anyone have any ideas on where I should start looking
On Thu, Jul 15, 2010 at 9:41 AM, Patrick Donlin pdon...@oaisd.org wrote:
I have two servers with equal specs, one of them running 8.3.7 and the new
server running 8.4.4. The only tweak I have made from the default install
(from Ubuntu repositories) is increasing shared_buffers to 768MB. Both
Patrick Donlin pdon...@oaisd.org wrote:
I have run vacuumdb --full --analyze, it
actually runs as a nightly cron job.
That's usually not wise -- VACUUM FULL can cause index bloat, and is
not normally necessary. If you have autovacuum turned on and run a
database vacuum each night, you can
On Thu, Jul 15, 2010 at 11:12 AM, Patrick Donlin pdon...@oaisd.org wrote:
I'll read over that wiki entry, but for now here is the EXPLAIN ANALYZE
output assuming I did it correctly. I have run vacuumdb --full --analyze,
it actually runs as a nightly cron job.
8.4.4 Sever:
UniqueÂ
On Thu, 2010-07-15 at 10:41 -0400, Patrick Donlin wrote:
Results when running on the v8.3.7 server
Total query runtime: 32185 ms.
700536 rows retrieved.
Results when running on the v8.4.4 server
Total query runtime: 164227 ms.
700536 rows retrieved.
Anyone have any ideas on
To: Patrick Donlin pdon...@oaisd.org
Cc: Kevin Grittner kevin.gritt...@wicourts.gov,
pgsql-performance@postgresql.org
Sent: Thursday, July 15, 2010 12:04:13 PM GMT -05:00 US/Canada Eastern
Subject: Re: [PERFORM] Identical query slower on 8.4 vs 8.3
your plans are identical as is the runtime
13 matches
Mail list logo