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 ide

[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 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

[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