Search Postgresql Archives

Re: Vacuuming strategy

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Elanchezhiyan Elango <elanelango@xxxxxxxxx>
Subject: Re: Vacuuming strategy
From: Jeff Janes <jeff.janes@xxxxxxxxx>
Date: Fri, 2 May 2014 12:16:15 -0700
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CALqA5kgVmBwGHvsaB9SH28nZwzgqhwzP=gmCWvNA+gCkUDYnog@mail.gmail.com>

On Wed, Apr 30, 2014 at 10:45 AM, Elanchezhiyan Elango <elanelango@xxxxxxxxx> wrote:

Missed to answer this one:
Is the 5GB for the table plus indexes, or just the table itself?

No it's not including the the indices. Including indices it's actually 17GB!!

Is it one particular index that is bloated?

Cheers,

Jeff

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Vacuuming strategy
  - From: Elanchezhiyan Elango
- Re: Vacuuming strategy
  - From: Jeff Janes
- Re: Vacuuming strategy
  - From: Elanchezhiyan Elango
- Re: Vacuuming strategy
  - From: Elanchezhiyan Elango

Prev by Date: Re: Vacuuming strategy
Next by Date: Re: Manipulating jsonb
Previous by thread: Re: Vacuuming strategy
Next by thread: Re: Vacuuming strategy
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux