On 1/23/2016 12:35 AM, Vik Fearing wrote:
>ok, but it doesn't deal with our use case of needing to bulk delete a 6
I can't really parse the end of that sentence, but you are correct that
BRIN does not help at all with partition dropping. Think of it more as
a Seq Scan optimization.
yeah, it was supposed to say, bulk delete 6 month old data once a week,
while the database is still under a full production load of new data.
anyways, yeah, BRIN sounds very cool for very large tables with
relatively stable data.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
