Re: Row estimates for empty tables

2020-08-30 Thread Pavel Stehule
ne 30. 8. 2020 v 18:23 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > I'll mark this patch as ready for commit > > Pushed, thanks for looking. > Thank you Pavel > > regards, tom lane >

Re: Row estimates for empty tables

2020-08-30 Thread Tom Lane
Pavel Stehule writes: > I'll mark this patch as ready for commit Pushed, thanks for looking. regards, tom lane

Re: Row estimates for empty tables

2020-08-25 Thread Pavel Stehule
út 25. 8. 2020 v 9:32 odesílatel Pavel Stehule napsal: > > > po 24. 8. 2020 v 21:43 odesílatel Pavel Stehule > napsal: > >> >> >> ne 23. 8. 2020 v 23:08 odesílatel Tom Lane napsal: >> >>> Pavel Stehule writes: >>> > I am sending a patch that is years used in GoodData. >>> >>> I'm quite unexcit

Re: Row estimates for empty tables

2020-08-25 Thread Pavel Stehule
po 24. 8. 2020 v 21:43 odesílatel Pavel Stehule napsal: > > > ne 23. 8. 2020 v 23:08 odesílatel Tom Lane napsal: > >> Pavel Stehule writes: >> > I am sending a patch that is years used in GoodData. >> >> I'm quite unexcited about that. I'd be the first to agree that the >> ten-pages estimate i

Re: Row estimates for empty tables

2020-08-24 Thread Pavel Stehule
ne 23. 8. 2020 v 23:08 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > I am sending a patch that is years used in GoodData. > > I'm quite unexcited about that. I'd be the first to agree that the > ten-pages estimate is a hack, but it's not an improvement to ask users > to think of a bet

Re: Row estimates for empty tables

2020-08-23 Thread Tom Lane
Pavel Stehule writes: > I am sending a patch that is years used in GoodData. I'm quite unexcited about that. I'd be the first to agree that the ten-pages estimate is a hack, but it's not an improvement to ask users to think of a better value ... especially not as a one-size-fits- all-relations G

Re: Row estimates for empty tables

2020-07-24 Thread Pavel Stehule
so 25. 7. 2020 v 0:34 odesílatel Tom Lane napsal: > [ redirecting to -hackers ] > > I wrote: > > The core issue here is "how do we know whether the table is likely to > stay > > empty?". I can think of a couple of more or less klugy solutions: > For these special cases is probably possible to e

Re: Row estimates for empty tables

2020-07-24 Thread David Rowley
On Sat, 25 Jul 2020 at 10:34, Tom Lane wrote: > I wrote: > > 1. Arrange to send out a relcache inval when adding the first page to > > a table, and then remove the planner hack for disbelieving relpages = 0. > > I fear this'd be a mess from a system structural standpoint, but it might > > work fai

Re: Row estimates for empty tables

2020-07-24 Thread Tom Lane
[ redirecting to -hackers ] I wrote: > The core issue here is "how do we know whether the table is likely to stay > empty?". I can think of a couple of more or less klugy solutions: > 1. Arrange to send out a relcache inval when adding the first page to > a table, and then remove the planner hac