Re: varchar vs. text + constraint/triggers was: Help request to improve function performance - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: varchar vs. text + constraint/triggers was: Help request to improve function performance
Date
Msg-id 2f4958ff0904230450pb8cd1a8q32db1d09958ce946@mail.gmail.com
Whole thread Raw
In response to Re: varchar vs. text + constraint/triggers was: Help request to improve function performance  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
essentially you are trying to store a database in a database, and
that's slow for one.
Second, storing things as varchar is space and index (space)
ineffective - and that's another reason to make things slower.
Third - you need to complicate your logic to retrieve data, and that adds up.

text is less of hassle for db, true - but that's just a tip of iceberg.

Just learn to create proper database schema, and make it so it meets
your criteria - otherwise , whatever else you choose - especially
'automatic' 'intelligent' isn't going to be ever as good as proper
schema.

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: varchar vs. text + constraint/triggers was: Help request to improve function performance
Next
From: "Chen, Dongdong (GE Healthcare)"
Date:
Subject: need help for PostgreSQL consistency check mechanism