Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword

2022-08-31 Thread Torge
uld love to see this become a supported feature so it is easier to use and most likely far more performant. Greetings, Torge. PS: Here my current SQL level statement to achieve this. Due to limitations I couldn't work around, it works slightly different. Instead of the row count

Re: Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword

2022-08-31 Thread Torge
I am not aware of this, sounds like what I want. Will look into it. Thanks! Am 01.09.22 um 03:47 schrieb Tom Lane: Torge writes: Now I would like to humbly propose a feature that gives an easy way to get a quick count estimate for any condition - index based or not - based on a random sample