Re: Custom Operator for citext LIKE predicates question

migration dba team determined citext was the way to go to maintain MSSQL existing usage of the data in the columns. Thanks,Efrain J. Berdecia On Thursday, January 13, 2022, 10:10:38 AM EST, Tom Lane wrote: "Efrain J. Berdecia" writes: > In our setup it has actually worked per

Re: Custom Operator for citext LIKE predicates question

Thank you for the feedback. In our setup it has actually worked per the explains provided making the query run in milliseconds instead of seconds. We weren't sure if this should be something that could be added natively with future Postgres deployments. Thanks,Efrain J. Berdecia

Custom Operator for citext LIKE predicates question

After attempting to use gin and gist indexes for our queries that run against citext columns, our team has come up with the following to make our queries run from 2 mins to 25ms;CREATE EXTENSION pg_trgmCREATE EXTENSION btree_gin --may not be needed, checking CREATE OPERATOR CLASS gin_trgm_ops_ci

Add create and update timestamp to all objects

Are there any plans to add a create and last updated time stamp field to any and all objects in postgres? Possibly even adding a updated_by documenting which role created and last updated the object. All done natively and without the need for extra extensions. Thanks in advance.