Re: Anyone got time to review an article?
От | Tom Copeland |
---|---|
Тема | Re: Anyone got time to review an article? |
Дата | |
Msg-id | 1101306923.8976.7.camel@hal обсуждение исходный текст |
Ответ на | Re: Anyone got time to review an article? ("Josh Berkus" <josh@agliodbs.com>) |
Список | pgsql-advocacy |
On Tue, 2004-11-23 at 23:39, Josh Berkus wrote: > I'm on vacation, so I don't have the ability to test the actual SQL. > The > article text is fine. You might want to, in future articles, suggest > that > people run EXPLAIN ANALYZE and not just EXPLAIN in order to see when > the > query planner is estimating wrong. Ah, good idea, thanks. > BTW, the queries that GForge uses to generate the category counts for > the > trove map are egregiously bad and generate wrong counts to boot. > They're > basically a loop of queries, one *per category*, when the whole thing > could > be done in a single query. Heh... I bet that's not the only set of hideous queries in there. Ah well... onwards and upwards... > I've been meaning to fix this for some > time, > but I got hung up on getting GForge installed on my dev machine. Maybe > later ... Maybe I can catch up with you on #postgresql sometime and we can sort of some of those problems... Yours, Tom
В списке pgsql-advocacy по дате отправления: