Greetings list. I have a Postgresql 9.0.8 cluster with one master and a few slaves, in a hot standby and streaming replication setup. The setup has a single database with a single table. The table has a column "updated" of type "timestamp".
For maintenance reasons I'd like to create a B-tree (or at least some kind of index allowing fast comparisons, "<" and ">" at least). However, I'd, if possible, like to create this index on a single machine in the cluster and not have it replicated everywhere. When the maintenance is done the index should be removed. Hash indices will not work in this case - it's non-replicated but does not work for comparisons. Ideas? Best regards Björn -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
