From: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Single-file DBs WAS: Need concrete 'Why Postgres |
Date: | 2003-08-24 19:15:25 |
Message-ID: | 1587.24.162.240.126.1061766925.squirrel@www.dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers |
This makes sense to me. I sense a TODO item :-)
(My dim and possibly incorrect memory of administering Ingres around 10
years ago was that it supported both raw devices and file system based
databases. We opted for a file system base, for reasons others have
mentioned here, but I seem to recall we used a raw device for the
transaction log for performance reasons. But, as the saying goes, that was
a long time ago, and in another country.)
andrew
Tom wrote
> "Andrew Dunstan" <andrew(at)dunslane(dot)net> writes:
>> Is anyone seriously suggesting that postgres should support either raw
>> devices or use some sort of virtual file system? If not, this whole
>> discussion is way off topic.
>
> I have zero interest in actually doing it. However, it'd be nice if
> the existing "storage manager" API were clean enough that our response
> to this type of question could be "sure, go implement it, and when
> you're done let us know what performance improvement you see". We've
> allowed the smgr API to degenerate over the years. CREATE/DROP
> DATABASE both bypass it, and the support for alternate database
> locations messes up the API pretty thoroughly (not that there's
> anything clean about that feature at all), and I think there are some
> other issues with specific commands bypassing the smgr abstractions.
>
> I think it would be reasonable to fix this as part of the "tablespaces"
> work that people keep wanting to do.
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-24 22:39:18 | Re: Single-file DBs WAS: Need concrete 'Why Postgres |
Previous Message | Josh Berkus | 2003-08-24 05:53:34 | PR Page for 7.4 Release |
From | Date | Subject | |
---|---|---|---|
Next Message | ruben20@superguai.com | 2003-08-24 21:25:24 | Upgrading PostgreSQL 7.1.3 |
Previous Message | CoL | 2003-08-24 17:17:03 | Re: merge multiple records into 1 |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-24 20:19:35 | Re: Collation rules and multi-lingual databases |
Previous Message | Jenny - | 2003-08-24 18:30:41 | Re: table-level and row-level locks. |