From: | Jim Nasby <jim(at)nasby(dot)net> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Removing special case OID generation |
Date: | 2012-02-10 22:38:41 |
Message-ID: | 4F359C71.6060206@nasby.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2/7/12 8:14 AM, Alvaro Herrera wrote:
> Having one sequence for each toast table could be wasteful though. I
> mean, sequences are not the best use of shared buffer cache currently.
> If we could have more than one sequence data in a shared buffer page,
> things would be different. Not sure how serious this really is.
This would actually be an argument for supporting multiple page sizes... too bad that's such a beast.
FWIW, from our most complex production database:
cnuapp_prod(at)postgres08(dot)obr=# select relkind, count(*) from pg_class group by 1;
relkind | count
---------+-------
S | 522
r | 1058
t | 698
i | 2894
v | 221
c | 12
(6 rows)
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2012-02-10 23:54:07 | bitfield and gcc |
Previous Message | Peter Eisentraut | 2012-02-10 20:57:52 | Re: initdb and fsync |