Re: Practical limit on number of tables ina single database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Just Someone" <just(dot)some(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Practical limit on number of tables ina single database
Date: 2006-03-24 23:56:19
Message-ID: 12780.1143244579@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Just Someone" <just(dot)some(at)gmail(dot)com> writes:
> Actually, most table are VERY small. On each schema I would expect 4 -
> 5 tables to go over 1000 records. The rest will be much smaller, with
> most at under 100. And aside from 2-3 tables, the activity will be
> pretty low (few records a day at the most extreme).

> Can I use this to optimize the fsm part in a different way?

Seems like a one-page table hardly needs an FSM entry at all: there's
only one place to look for free space anyway. Maybe we should have a
threshold for the minimum size a table must be before it gets an FSM
entry.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2006-03-25 00:19:48 Re: Between !
Previous Message Just Someone 2006-03-24 23:46:07 Re: Practical limit on number of tables ina single database