salah jubeh wrote:
> Well my question was not very precise, the postgresql version is
> 8.3 which is not supported, so I wanted to migrate to a newer
> version which is 9.1.
>
> I have used pg_dump with -Fc option and I was monitoring the
> pg_restore activity. Normally, the dump and restore ta
: [GENERAL] bloating index, pg_restore
Sergey Konoplev writes:
> On Wed, Mar 27, 2013 at 9:56 AM, salah jubeh wrote:
>> I have a database which is bloated because of vacuum full, so you find
>> indexes bigger than the table itself.
> Table can not be bloated because of vacuum full
Sergey Konoplev writes:
> On Wed, Mar 27, 2013 at 9:56 AM, salah jubeh wrote:
>> I have a database which is bloated because of vacuum full, so you find
>> indexes bigger than the table itself.
> Table can not be bloated because of vacuum full, it removes bloat from
> the table and its indexes.
Hello,
On Wed, Mar 27, 2013 at 9:56 AM, salah jubeh wrote:
> I have a database which is bloated because of vacuum full, so you find
> indexes bigger than the table itself.
Table can not be bloated because of vacuum full, it removes bloat from
the table and its indexes. The fact that an index is
Hello,
I have a database which is bloated because of vacuum full, so you find indexes
bigger than the table itself.
I have dumped this database and restored it without reindixing and it was
extremely slow. So, my question what is the relation between bloated database
and pg_restore.
Rega
