On Wednesday 14 April 2010, Jan Krcmar <honza...@gmail.com> wrote: > > > You might consider partitioning this table by date, either by day or by > > week, and instead of deleting old rows, drop entire old partitions > > this is not really good workaround...
Actually it's a very good workaround, that a lot of people use for exactly this purpose. It's a lot less disk I/O than delete+vacuum even when you're not experiencing bloat. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
