Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13679: Planer chooses not optimal plan - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13679: Planer chooses not optimal plan
Date
Msg-id 27884.1444832738@sss.pgh.pa.us
Whole thread Raw
In response to BUG #13679: Planer chooses not optimal plan  (i.frolkov@postgrespro.ru)
List pgsql-bugs
Tree view 
i.frolkov@postgrespro.ru writes:
> See two explain analyze below:

I see no particular bug here.  Given the speeds you're getting out of that
inner indexscan, you need to increase effective_cache_size and/or reduce
random_page_cost to reflect actual execution costs on your hardware.

            regards, tom lane

pgsql-bugs by date:

Previous
From: John Pruitt
Date:
Subject: Re: BUG #13670: DST discrepancy between age() and subtraction for timestamptz arguments
Next
From: "Aaron C. de Bruyn"
Date:
Subject: Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM