Hi Osman
See postgresql_anonymizer
https://gitlab.com/dalibo/postgresql_anonymizer/ and pg_anonymize
https://github.com/rjuju/pg_anonymize , where the former has more
functionality, like synthetic data generation (if you need that).
Yours, Stefan
Am Di., 29. Okt. 2024 um 10:01 Uhr schrieb Hosney
Am Di., 23. Jan. 2024 um 15:15 Uhr schrieb Laurenz Albe
:
> I understand the motivation, but I bet it's not what will make users
> happy.
>
> If you need to disambiguate between SQL NULL and JSON null, my
> preferred solution would be to omit SQL NULL columns from the output
> altogether.
I fully
Dear Tom, Andres, Andrew, all
Any update on this interesting topic?
--Stefan
P.S. TIL Databricks SQL lambda functions: "A parameterized expression
that can be passed to a function to control its behavior. For example,
array_sort function (Databricks SQL) accepts a lambda function as an
argument
Dear all
Just for my understanding - and perhaps as input for the documentation of this:
Are Foreign Key Arrays a means to implement "Generic Foreign Keys" as
in Oracle [1] and Django [2], and of "Polymorphic Associations" as
they call this in Ruby on Rails?
Yours, Stefan
[1] Steven Feuerstein a
oncurrent performance. This means that some indexes perform very
> well for a single user but poorly for multiple users.
I see now. That looks to me like a second step of an experiment to
implement a possible new index.
~Stefan
Am Mi., 21. Apr. 2021 um 15:46 Uhr schrieb Bruce Momjian :
>
2021 um 23:51 Uhr schrieb Peter Geoghegan :
>
> On Tue, Apr 20, 2021 at 2:29 PM Stefan Keller wrote:
> > Just for the records: A learned index as no more foreknowledge about
> > the dataset as other indices.
>
> Maybe. ML models are famously prone to over-interpreting training
Just for the records: A learned index as no more foreknowledge about
the dataset as other indices.
I'd give learned indexes at least a change to provide a
proof-of-concept. And I want to learn more about the requirements to
be accepted as a new index (before undergoing month's of code
sprints).
A
Dear Olegs, dear Nikolay, dear all
Allow me to revive this thread:
Are there any advances in a learned index for PostgreSQL?
Background: I'm trying to benchmark those experimental indices. For
this I did some bibliography work (see below). Fun fact: Not only
Postgres people love high-proof drink
Dear all,
I'm following this list since years - especially PostGIS related - and
you and PG are just awesome!
Pls. let me chime in as a university teacher, therefore used to
explain every year the same things :-).
My 2 cents here are:
Pls. try to give DUAL a better name, since it's IMHO neither
s
Hi,
2017-12-15 4:14 GMT+01:00 Stephen Frost :
> Unsurprisingly, we'll need to have an Ideas page again, so I've gone
> ahead and created one (copying last year's):
What about adding "Learned Index" as project task [*]?
This type of index looks promising for certain properties.
:Stefan
[*] "The
t not having searched before this list - in fact I did but inaccurately.
:Stefan
2017-12-12 21:26 GMT+01:00 Robert Haas :
> On Tue, Dec 12, 2017 at 6:38 AM, Stefan Keller wrote:
>> This is an awesome paper about a new index called "Learned Index".
>> it's aka den
Hi,
This is an awesome paper about a new index called "Learned Index".
it's aka dense hash structure derived ("learned") from actual data.
Looks very promising for certain properties [*].
Anyone already working on this in Postgres?
How could this be implemented in Postgres?
:Stefan
[*] "The Cas
12 matches
Mail list logo
