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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
