query optimization
От
Richard Kojedzinszky
Тема
query optimization
Дата
Msg-id
alpine.DEB.2.02.1204241008570.9591@krichy.tvnetwork.hu
Список
Дерево обсуждения
query optimization Richard Kojedzinszky <krichy@tvnetwork.hu>
Re: query optimization Tom Lane <tgl@sss.pgh.pa.us>
Re: query optimization Richard Kojedzinszky <krichy@tvnetwork.hu>
Re: query optimization Thomas Kellerer <spam_eater@gmx.net>
Re: query optimization Tom Lane <tgl@sss.pgh.pa.us>
Re: query optimization Andrew Dunstan <andrew@dunslane.net>
Re: query optimization "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Dear list, We have a database schema, which looks the same as the attached script. When filling the tables with data, and skipping analyze on the table (so pg_stats contains no records for table 'a'), the first select in the script runs fast, but after an analyze the planner decides to sequence scan tables b and c, thus making the query much slower. Can somebody help me solving this issue, or tuning our installation to not to use sequence scans in this case? Thanks in advance, Kojedzinszky Richard Euronet Magyarorszag Informatikai Zrt.
В списке pgsql-performance по дате отправления
