Re: Database storage bloat

Поиск
Список
Период
Сортировка
От Tony and Bryn Reina
Тема Re: Database storage bloat
Дата
Msg-id BAY8-DAV64SOlbpH71y00020ce6@hotmail.com
обсуждение исходный текст
Ответ на Database storage bloat  (reina_ga@hotmail.com (Tony Reina))
Список pgsql-admin
> I don't see orders-of-magnitude bloat here though.  You've got 16 bytes
> of useful data per row (which I suppose was 12 bytes in the flat file?).
> There will be 28 bytes of overhead per table row.  In addition the index
> will require 12 data bytes + 12 overhead bytes per entry; allowing for
> the fact that b-tree only likes to pack pages about 2/3ds full, we could
> estimate index size as about 36 bytes per original row, giving an
> aggregate bloat factor of 6.67X compared to a binary flat file if the
> flat file needed 12 bytes per row.
>
> The only way I could see to get to a 65X bloat factor would be if you'd
> repeatedly updated the table rows without vacuuming.

Thanks Tom (and everyone else). At least I feel more comfortable that
there's not something obvious. I did perform a 'vacuum full', but still no
dice. At least thanks to Stephan I've narrowed my search down to one table
and I have a ballpark theoretical bloat to shoot for (6 .67X). I'm going to
go back and try to determine if I'm correctly interpretting the part of the
flat file that holds this table's data.

-Tony

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: parameter to control cycle detection
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Multiple disks