> Could you please explain the reason to do so many > partitions? Because otherwise there would be tons of rows in each partition, and randomly "updating" the index for that many rows 2000 times per second isn't doable (the indexes get so big that it would be like writing a multi-GB file randomly) > In case b) you will face a huge overhead related to necessity > of > checking all the data in the table every time new index is > created I would create the table with all the indexes already in; but only the index related to the "current timestamp of the inserted row" would be updated; the others wouldn't be touched. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
