Re: Specifying attribute slot for storing/reading statistics

2019-09-12 Thread Esteban Zimanyi
> > So these are 4 different data types (or classes of data types) that you > introduce in your extension? Or is that just a conceptual view and it's > stored in some other way (e.g. normalized in some way)? > At the SQL level these 4 durations are not distinguishable. For example for a tfloat (te

Re: Specifying attribute slot for storing/reading statistics

2019-09-10 Thread Tomas Vondra
Hi, Please don't top-post. If you're not responding to parts of the e-mail, then don't quote it. On Fri, Sep 06, 2019 at 12:50:33PM +0200, Esteban Zimanyi wrote: Dear Tom Many thanks for your quick reply. Indeed both solutions you proposed can be combined together in order to solve all the pro

Re: Specifying attribute slot for storing/reading statistics

2019-09-06 Thread Esteban Zimanyi
Dear Tom Many thanks for your quick reply. Indeed both solutions you proposed can be combined together in order to solve all the problems. However changes in the code are needed. Let me now elaborate on the solution concerning the combination of stakind/staop first and I will elaborate on adding a

Re: Specifying attribute slot for storing/reading statistics

2019-09-05 Thread Tom Lane
Esteban Zimanyi writes: > We are developing the analyze/selectivity functions for those types. Our > approach is to use the standard PostgreSQL/PostGIS functions for the value > and the time dimensions where the slots starting from 0 will be used for > the value dimension, and the slots starting f