From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
Cc: | Greg Stark <stark(at)mit(dot)edu>, Kevin Grittner <kgrittn(at)ymail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Noah Misch <noah(at)leadboat(dot)com>, "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Remaining beta blockers |
Date: | 2013-05-03 15:56:29 |
Message-ID: | 20130503155629.GI5933@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, May 3, 2013 at 05:24:54PM +0200, Andres Freund wrote:
> On 2013-05-03 16:11:13 +0100, Greg Stark wrote:
> > On Fri, May 3, 2013 at 1:12 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > > I was more thinking of the idea of having some status on the first page
> > > that might need to change in a future release.
> >
> > Incidentally, another option might be to have a <relfilenode>.meta
> > fork that has information like this. It doesn't fundamentally change
> > anything but it does mean that code that doesn't need to know about it
> > doesn't need to know to skip the first page. It also means we could
> > maybe expand it more easily. There have been previous wishlist items
> > to have some meta information so external tools can more easily parse
> > the data without needing access to the full catalog for example.
>
> The problem with an extra metadata fork is that it essentially would
> double the files in a cluster and it would also noticeably increase the
> amount of open files we need.
> There have been quite some complaints about CREATE DATABASE speed, I
> am not sure we want to make it even slower :(
Agreed. We start to get into file system performance issues at that
point. I have often wondered if we need to create hash the files into
subdirectories for databases with many tables. Has anyone profiled
this?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2013-05-03 15:56:53 | Re: [COMMITTERS] pgsql: Revert "pg_ctl: Add idempotent option" |
Previous Message | Greg Stark | 2013-05-03 15:34:48 | Re: high io BUT huge amount of free memory |