Re: Performance problem with a table with 38928077 record

From: Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
To: Guillaume Cottenceau <gc(at)mnc(dot)ch>
Cc: Giovanni Mancuso <gmancuso(at)babel(dot)it>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problem with a table with 38928077 record
Date: 2011-10-07 10:29:22
Message-ID: CAJY59_h6DoTG0MpSwLbhBR1uWECUBV0cdfgrA6-xF383rQ-Pew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Do you need left join ?
Can you further normalize the tables? (to lower the I/O)
Can you upgrade to at least 8.3 ? It has huuge performance
improvements over 8.3.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Cédric Villemain 2011-10-07 12:59:26 Re: Performance problem with a table with 38928077 record
Previous Message Guillaume Cottenceau 2011-10-07 10:24:17 Re: Performance problem with a table with 38928077 record