Re: Avoiding Recheck Cond when using Select Distinct

From: Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
To: jackrg <jack(at)groundbreakingsoftware(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Avoiding Recheck Cond when using Select Distinct
Date: 2013-02-22 17:59:40
Message-ID: CABWW-d3-k7jnqm2piipjW7bEUbpxA0PnGn+b42ec_CRGqkROYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2013/2/22 jackrg <jack(at)groundbreakingsoftware(dot)com>

> 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Schulz 2013-02-22 18:10:25 Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds
Previous Message Carlo Stonebanks 2013-02-22 17:50:59 Re: Are bitmap index scans slow to start?