Re: Much Ado About COUNT(*) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Much Ado About COUNT(*)
Date
Msg-id 20050120134440.GB16939@dcc.uchile.cl
Whole thread Raw
In response to Re: Much Ado About COUNT(*)  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
List 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 by date:

Previous
From: "Mark Cave-Ayland"
Date:
Subject: Re: Much Ado About COUNT(*)
Next
From: Alvaro Herrera
Date:
Subject: Re: Translations at pgfoundry (was Re: [PATCHES] Latest Turkish translation updates)