Merlin Moncure writes:
> On Mon, Feb 29, 2016 at 12:47 PM, Tom Lane wrote:
>> FWIW, PG >= 9.5 will ignore a LIMIT 1 inside an EXISTS, so that you get
>> the same plan with or without it. But that does act as an optimization
>> fence in earlier releases.
On Mon, Feb 29, 2016 at 12:47 PM, Tom Lane wrote:
> FWIW, PG >= 9.5 will ignore a LIMIT 1 inside an EXISTS, so that you get
> the same plan with or without it. But that does act as an optimization
> fence in earlier releases.
Does 'offset 0' still work as it did?
merlin
Matheus de Oliveira writes:
> Em 26 de fev de 2016 4:44 PM, "joe meiring"
> escreveu:
>> The same query for parameters is rather slow and does NOT use the index:
>>
>> EXPLAIN ANALYZE
>> select *
>> from parameter
>> where exists (
>> select 1
Em 26 de fev de 2016 4:44 PM, "joe meiring"
escreveu:
>
> The same query for parameters is rather slow and does NOT use the index:
>
> EXPLAIN ANALYZE
> select *
> from parameter
> where exists (
> select 1 from datavalue
> where datavalue.parameter_id =
On Fri, Feb 26, 2016 at 1:38 PM, joe meiring
wrote:
> Here's the distribution of parameter_id's
>
> select count(parameter_id), parameter_id from datavalue group by parameter_id
> 88169 142889171 815805 178570124257262 213947049 151225902 24091090
> 3103877
Here's the distribution of parameter_id's
select count(parameter_id), parameter_id from datavalue group by parameter_id
88169 142889171 815805 178570124257262 213947049 151225902
24091090 3103877 10633764 11994442 1849232 2014935 4563638
132955919 7
On Fri, Feb 26, 2016 at 2:02
On Fri, Feb 26, 2016 at 12:43 PM, joe meiring
wrote:
> Also available on S.O.:
>
>
> http://stackoverflow.com/questions/35658238/postgres-odd-behavior-with-indices
>
> I've got a datavalue table with ~200M rows or so, with indices on both
> site_id and parameter_id. I