Re: Best way to get the latest revision from a table

Поиск
Список
Период
Сортировка
От Nikolas Everett
Тема Re: Best way to get the latest revision from a table
Дата
Msg-id AANLkTikgQ8y4=5Ly_x+U0mQ7RRHprPGDd-rR8z1NOPWS@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Best way to get the latest revision from a table  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Best way to get the latest revision from a table  (Shaun Thomas <sthomas@peak6.com>)
Re: Best way to get the latest revision from a table  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-performance
Дерево обсуждения


On Fri, Jan 14, 2011 at 7:59 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Shaun's example is a bit off

> As for speed, either one might be faster in a particular
> situation.

After fixing a mistake in my testing and learning from Tom's example
I generated queries against the OP's test data which produce
identical results, and I'm finding no significant difference between
run times for the two versions.  The OP should definitely try both
against the real tables.

<snip> 
-Kevin

After trying both against the real tables DISTINCT ON seems to be about two orders of magnitude faster than the other options.

Thanks so much!

Nik Everett

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Best way to get the latest revision from a table
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: The good, old times