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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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