Re: [HACKERS] fast count(*) through statistics collector

2008-03-19 Thread Tom Lane
Artem Yazkov [EMAIL PROTECTED] writes: By viewing this list, I see a lot of discussions on the problem of fast count (*), but acceptable decision have not been formulated. Well, I make bold to propose own view on the problem. A number of the things you suggest would be good for

[HACKERS] fast count(*) through statistics collector

2008-03-19 Thread Artem Yazkov
Hi hackers, I'm novice in PostgreSQL codebase (and in English too :-)), but I'd be glad to make a modest contribution to this great project. By viewing this list, I see a lot of discussions on the problem of fast count (*), but acceptable decision have not been formulated. Well, I make

Re: [HACKERS] fast count(*) through statistics collector

2008-03-19 Thread Simon Riggs
On Tue, 2008-03-18 at 21:26 +0700, Artem Yazkov wrote: Restrictions: 1. Uninterrupted supply of statistics collector necessary for efficient use of this algorithm. In my understanding, we do not guarantee this. That leaves the rest of your ideas drifting, I'm sorry to say. Your ideas

[HACKERS] fast count(*) through statistics collector

2008-03-18 Thread Artem Yazkov
Hi hackers, I'm novice in PostgreSQL codebase (and in English too :-)), but I'd be glad to make a modest contribution to this great project. By viewing this list, I see a lot of discussions on the problem of fast count (*), but acceptable decision have not been formulated. Well, I make