Re: [PERFORM] Query uses incorrect index

2010-12-22 Thread pasman pasmański
Hi. I install auto_explain module for monitoring queries. By the way, is any tool to tune planner automatically ? pasman -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-per

Re: [PERFORM] Query uses incorrect index

2010-12-22 Thread Tom Lane
=?ISO-8859-2?Q?pasman_pasma=F1ski?= writes: > Thanks for reply. > I tested random changes and query runs fastest after: > set seq_page_cost = 0.1; > set random_page_cost = 0.1; > cpu_operator_cost = 0.01 As a general rule, "optimizing" those settings on the basis of testing a single query is a g

Re: [PERFORM] Query uses incorrect index

2010-12-22 Thread Kevin Grittner
Guillaume Cottenceau wrote: > If I'm correct, you're basically telling postgresql that your > disk is unusually fast compared to your CPU. Even if some queries > will run faster from a side-effect of these settings, you're > likely to create other random problems... If this is set globally and

Re: [PERFORM] Query uses incorrect index

2010-12-22 Thread Guillaume Cottenceau
pasman pasmański writes: > Thanks for reply. > I tested random changes and query runs fastest after: > > set seq_page_cost = 0.1; > set random_page_cost = 0.1; > cpu_operator_cost = 0.01 If I'm correct, you're basically telling postgresql that your disk is unusually fast compared to your CPU. Ev

Re: [PERFORM] Query uses incorrect index

2010-12-22 Thread pasman pasmański
Thanks for reply. I tested random changes and query runs fastest after: set seq_page_cost = 0.1; set random_page_cost = 0.1; cpu_operator_cost = 0.01 pasman -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://

Re: [PERFORM] Query uses incorrect index

2010-12-21 Thread Kevin Grittner
pasman pasma*ski wrote: > -> Index Scan using NTA_5" on "NumeryA" a > (cost=0.01..10016.75 rows=24175 width=42) (actual > time=0.132..308.018 rows=33597 loops=1)" > seq_page_cost = 0.3 > random_page_cost = 0.5 Your data is heavily cached (to be able to read 33597 rows ran

[PERFORM] Query uses incorrect index

2010-12-21 Thread pasman pasmański
hello. I ve the table NumeryA with 3 indices. Query below uses incorrect index. SELECT A."NKA", A."NTA", Min("PołączeniaMin") || ',' || Max("PołączeniaMax") AS "Biling", Sum("Ile")::text AS "Ilość CDR", R."LP"::text AS "Sprawa", R."Osoba weryfikująca" AS "Osoba", to_char(min("Warto