Re: Avoiding Recheck Cond when using Select Distinct - Mailing list pgsql-performance

From Maciek Sakrejda
Subject Re: Avoiding Recheck Cond when using Select Distinct
Date
Msg-id CAOtHd0DPv3rc2_bUqsBWQM3-n6FcYZXnNp4aZif-R6Rc+8G7ig@mail.gmail.com
Whole thread Raw
In response to Re: Avoiding Recheck Cond when using Select Distinct  (Vitalii Tymchyshyn <tivv00@gmail.com>)
List pgsql-performance
On Fri, Feb 22, 2013 at 9:59 AM, Vitalii Tymchyshyn <tivv00@gmail.com> wrote:
>> Tuning Postgre is not an option, as the instance
>> is provided by Heroku and as far as I know cannot be tuned by me.
>>
> Most tuning parameters can be set at per-query basis, so you can issue
> alter database set param=value
> to have same effect as if it was set through postgresql.conf.

Jack,

Jeff brought up some great points and What Vitalii suggested should
let you tweak most knobs, but if you're running into limitations of
the platform or you find default settings which seem outright
incorrect, please file a support ticket and we'll be happy to work
with you.

Thanks,
Maciek
Heroku Postgres


pgsql-performance by date:

Previous
From: Nikolas Everett
Date:
Subject: Re: Are bitmap index scans slow to start?
Next
From: "Carlo Stonebanks"
Date:
Subject: Re: Are bitmap index scans slow to start?