Re: Much Ado About COUNT(*)

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Much Ado About COUNT(*)
Дата
Msg-id 20050120134440.GB16939@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: Much Ado About COUNT(*)  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
Список pgsql-hackers
On Thu, Jan 20, 2005 at 01:33:10PM -0000, Mark Cave-Ayland wrote:

> I am sure that Jeff's approach will work, however it just seems like writing
> out one table entry per row is going to slow large bulk inserts right down.

I don't see how it is any slower than the approach of inserting one
entry per row in the narrow table the OP wanted to use.  And it will be
faster for the scans.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
Officer Krupke, what are we to do?
Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")


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

Предыдущее
От: "Mark Cave-Ayland"
Дата:
Сообщение: Re: Much Ado About COUNT(*)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Translations at pgfoundry (was Re: [PATCHES] Latest Turkish translation updates)