I saw a similar project on oracle that was storing (long) messages (clob). Partionning by creation date was in place, as btree indexes to access data per id. It was working fine for inserts, as for sélect, but purges (delete) where not freeing space. In fact rétention was not the same for all records. We changed partitionning key to deletion date ans replaced deletes per partition drops.
Maybe, if all your records have the same rétention , partition per création can help for purge. Local index on création date would Aldo help. PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
