Re: Gurjeet Singh Index Adviser User Interface

Thank you very much for the answer. I will be trying to understand and test the indicated. Best regards, Yessica Brinkmann. Libre de virus. www.avg.com

Re: Gurjeet Singh Index Adviser User Interface

On Fri, Oct 9, 2020 at 5:20 PM Yessica Brinkmann < brinkmann.yess...@gmail.com> wrote: > I am using Postgresql 8.3.23, I really use this version because the Index > Adviser only works with this version of Postgresql. > I suggest first figuring out whether you are able to successfully install the

Re: Gurjeet Singh Index Adviser User Interface

I will greatly appreciate a help please with this topic. I really need a lot to be able to use this interface to be able to test my thesis well. I really don't quite understand what installing postgresql-server-dev-X.Y refers to. And I really don't really know how to install it too. If you can giv

Re: Any interest in adding match_recognize?

Rob Sargent schrieb am 09.10.2020 um 18:33: On Oct 9, 2020, at 10:25 AM, Guyren Howe wrote: I just became aware of the SQL 2016 standard match_recognize feature, which allows for rich pattern matching across groups of rows. It’s a great feature, currently only supported in Oracle. I can find n

Re: Any interest in adding match_recognize?

> On Oct 9, 2020, at 10:25 AM, Guyren Howe wrote: > > I just became aware of the SQL 2016 standard match_recognize feature, which > allows for rich pattern matching across groups of rows. It’s a great feature, > currently only supported in Oracle. > > I can find no evidence it’s ever been di

Any interest in adding match_recognize?

I just became aware of the SQL 2016 standard match_recognize feature, which allows for rich pattern matching across groups of rows. It’s a great feature, currently only supported in Oracle. I can find no evidence it’s ever been discussed here and there’s no mention of it on the PG website. So:

Re: Does the work made by vaccum in the current pass is lost when interrupted?

On Thu, Oct 8, 2020, 1:16 PM Jean-Marc Lessard < jean-marc.less...@ultra-ft.com> wrote: > I have a large table (billions of records) which has not been vacuum and > bloated. > > Vacuum scale factor was left at the default. > > > > I ran a vacuum on a DEV system and it makes several passes (scannin

Re: Does the work made by vaccum in the current pass is lost when interrupted?

On Thu, Oct 8, 2020 at 10:16 PM Jean-Marc Lessard < jean-marc.less...@ultra-ft.com> wrote: > I have a large table (billions of records) which has not been vacuum and > bloated. > > Vacuum scale factor was left at the default. > > > > I ran a vacuum on a DEV system and it makes several passes (scan

Re: What's your experience with using Postgres in IoT-contexts?

Everything is sent tot he cloud from the vehicle. The trackers we currently run don't have the power to be able to do much. There are a few vehicle devices we have access to (hub systems with a central computer / cpu / storage) which could handle a database, but in terms of our business requiremen

Re: Handling time series data with PostgreSQL

Thank you Stephen, Mark for your inputs. I will go through the documentation for time series data best practices in PGSQL. Regards, Jayaram S. On Thu, Oct 8, 2020 at 1:57 AM Stephen Frost wrote: > Greetings, > > * Mark Johnson (remi9...@gmail.com) wrote: > > I think the OP may be referring to O