Postgres Pro
Downloads
Home   >   mailing lists

Re: is 9.x so much better than 8.x? - Mailing list pgsql-general

From Vick Khera
Subject Re: is 9.x so much better than 8.x?
Date
Msg-id CALd+dcdfJg0CsUebfNy4eXGgP5XnsR-FUhOrCSuD6i21s6VgfQ@mail.gmail.com
Whole thread Raw
In response to is 9.x so much better than 8.x?  (Geert Mak <pobox@verysmall.org>)
List pgsql-general
Tree view
On Fri, Aug 10, 2012 at 11:32 AM, Geert Mak <pobox@verysmall.org> wrote:
do you think this is because 9.x performs better or is it possible that our 8.x installation has been muddled up somehow? (we did totally clean install/upgrade with drop/import)

Part of it will be from having a much more compacted table structure from the dump/reload.  Over time you get fragmentation even with aggressive vacuum runs.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: External Storage of data dir
Next
From: Laszlo Fogas
Date:
Subject: Re: slowness what only full vacuum can solve