Re: Reduce the size of PageFreeSpaceInfo on 64bit platform

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Reduce the size of PageFreeSpaceInfo on 64bit platform
Дата
Msg-id 200709140337.l8E3bUG15045@momjian.us
обсуждение исходный текст
Ответ на Re: Reduce the size of PageFreeSpaceInfo on 64bit platform  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Список pgsql-patches
This has been saved for the 8.4 release:

    http://momjian.postgresql.org/cgi-bin/pgpatches_hold

---------------------------------------------------------------------------

ITAGAKI Takahiro wrote:
> I wrote:
>
> > I'll rewrite my patch to use
> > FSMPageData in both places so that users can always estimate the memory
> > to 6 bytes per page.
>
> Here is a revised patch to reduce memory usage during VACUUM,
> using FSMPageData (6 byte) instead of PageFreeSpaceInfo (8 or 16 bytes).
> The keepable pages with freespace will extended to 21GB from 8GB with
> 16MB of default maintenance_work_mem.
>
> Regards,
> ---
> ITAGAKI Takahiro
> NTT Open Source Software Center
>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: WIP: rewrite numeric division
Следующее
От: "Pavan Deolasee"
Дата:
Сообщение: Re: HOT patch - version 15