Re: Indices for select count(*)?
От
Tom Lane
Тема
Re: Indices for select count(*)?
Дата
Msg-id
21985.1135363109@sss.pgh.pa.us
Ответ на
Re: Indices for select count(*)? (Martijn van Oosterhout)
Список
Дерево обсуждения
Newbie Question: FAQ for database optimization? Alexander Scholz <alexander.scholz1@freenet.de>
Re: Newbie Question: FAQ for database optimization? "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Indices for select count(*)? Alexander Scholz <alexander.scholz1@freenet.de>
Re: Indices for select count(*)? Peter Eisentraut <peter_e@gmx.net>
Re: Indices for select count(*)? Greg Stark <gsstark@mit.edu>
Re: Indices for select count(*)? "Jim C. Nasby" <jnasby@pervasive.com>
Re: Indices for select count(*)? Martijn van Oosterhout <kleptog@svana.org>
Re: Indices for select count(*)? "Jim C. Nasby" <jnasby@pervasive.com>
Re: Indices for select count(*)? Scott Marlowe <smarlowe@g2switchworks.com>
Re: Indices for select count(*)? Jaime Casanova <systemguards@gmail.com>
Re: Indices for select count(*)? Peter Eisentraut <peter_e@gmx.net>
Re: Indices for select count(*)? Tom Lane <tgl@sss.pgh.pa.us>
Re: Indices for select count(*)? Martijn van Oosterhout <kleptog@svana.org>
Re: Indices for select count(*)? Bruce Momjian <pgman@candle.pha.pa.us>
Re: Indices for select count(*)? Tom Lane <tgl@sss.pgh.pa.us>
Re: Indices for select count(*)? Tom Lane <tgl@sss.pgh.pa.us>
Re: Indices for select count(*)? Greg Stark <gsstark@mit.edu>
Re: Indices for select count(*)? Marcus Engene <mengpg@engene.se>
Re: Indices for select count(*)? Jaime Casanova <systemguards@gmail.com>
Re: Indices for select count(*)? Nicolas Barbier <nicolas.barbier@gmail.com>
Re: Newbie Question: FAQ for database optimization? David Fetter <david@fetter.org>
Martijn van Oosterhout writes: > AFAICS two big problems with using an index type: > 1. The index isn't told when the tuple is deleted. Hm, good point ... we could make it do so but for ordinary deletes it'd be a waste of cycles to open indexes at all. > 2. The server expects to be able to lookup an index. Only if there is a WHERE operator that matches the index's opclass. This hypothetical index type would probably have one dummy opclass containing no operators. regards, tom lane
В списке pgsql-general по дате отправления
