| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Mark Cave-Ayland <m(dot)cave-ayland(at)webbased(dot)co(dot)uk> |
| Cc: | "'Richard Huxton'" <dev(at)archonet(dot)com>, "'D'Arcy J(dot)M(dot) Cain'" <darcy(at)druid(dot)net>, jdavis-pgsql(at)empires(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Much Ado About COUNT(*) |
| Date: | 2005-01-20 13:44:40 |
| Message-ID: | 20050120134440.GB16939@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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[(at)]dcc(dot)uchile(dot)cl>)
Officer Krupke, what are we to do?
Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-01-20 14:44:29 | Re: Translations at pgfoundry (was Re: [PATCHES] Latest Turkish translation updates) |
| Previous Message | Mark Cave-Ayland | 2005-01-20 13:33:10 | Re: Much Ado About COUNT(*) |