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