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

Re: Performance issue - 2 linux machines, identical configs, different performance

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Mark Steben <msteben(at)autorevenue(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, Rich Garabedian <richg(at)autorevenue(dot)com>
Subject: Re: Performance issue - 2 linux machines, identical configs, different performance
Date: 2009-06-17 17:31:56
Message-ID: 603c8f070906171031n7210a22q635384ebd30bbf1f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
2009/6/17 Mark Steben <msteben(at)autorevenue(dot)com>:
> A few details – I can always provide more

Could you send:

1. Exact text of query.

2. EXPLAIN ANALYZE output on each machine.

3. VACUUM VERBOSE output on each machine, or at least the last 10 lines.

...Robert

In response to

pgsql-performance by date

Next:From: Dave DutcherDate: 2009-06-17 17:39:22
Subject: Re: Performance issue - 2 linux machines, identical configs, different performance
Previous:From: Mark StebenDate: 2009-06-17 17:12:51
Subject: Performance issue - 2 linux machines, identical configs, different performance

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