[GENERAL] Re: [PERFORM] Query running slow for only one specific id. (Postgres 9.3) version

en you can also create a partial index with that (unless it is not very selective, then it might not be worthy it). Regards, -- Matheus de Oliveira Analista de Banco de Dados Dextra Sistemas - MPS.Br nível F! www.dextra.com.br/postgres

Re: [GENERAL] [ADMIN] Editable Views

trigger or a rule to make it updatable. [1] http://www.postgresql.org/docs/current/static/sql-createview.html#SQL-CREATEVIEW-UPDATABLE-VIEWS Regards, -- Matheus de Oliveira Analista de Banco de Dados Dextra Sistemas - MPS.Br nível F! www.dextra.com.br/postgres

Re: [GENERAL] [ADMIN] WARNING: database must be vacuumed within 8439472 transactions

epared_xacts, if something old is there you must finish it either with ROLLBACK PREPARED or (less likely) COMMIT PREPARED. Regards, -- Matheus de Oliveira Analista de Banco de Dados Dextra Sistemas - MPS.Br nível F! www.dextra.com.br/postgres

Re: [GENERAL] [ADMIN] Unable to reload postgresql.conf without restarting

conf? If so, the last one will be used. Regards, -- Matheus de Oliveira Analista de Banco de Dados PostgreSQL Dextra Sistemas - MPS.Br nível F! www.dextra.com.br/postgres