Re: Performance problems with DISTINCT ON

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Sgarbossa Domenico <domenico(dot)sgarbossa(at)eniac(dot)it>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problems with DISTINCT ON
Date: 2009-09-29 12:53:13
Message-ID: 20090929125313.GA18281@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Should I try a different approach to solve this issue?

Yes. Ask yourself if you *really* need 180k rows.

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-09-29 14:19:10 Re: Using OProfile
Previous Message Sgarbossa Domenico 2009-09-29 12:44:49 Re: Performance problems with DISTINCT ON