Re: [HACKERS] Tablespaces

2004-02-26 Thread Greg Stark
I am expecting to hear some bleating about this from people whose preferred platforms don't support symlinks ;-). However, if we don't Well, one option would be to have the low level filesystem storage (md.c?) routines implement a kind of symlink themselves. Just a file with a special magic

Re: [HACKERS] Tablespaces

2004-02-26 Thread Alex J. Avriette
On Fri, Feb 27, 2004 at 08:22:25AM +1100, Gavin Sherry wrote: interested if anyone could provide some real world benchmarking of file system vs. raw disk. Postgres benefits a lot from kernel file system cache at the moment. Also, I believe that database designers have traditionally made bad

Re: [HACKERS] Tablespaces

2004-02-26 Thread Gavin Sherry
On Thu, 26 Feb 2004, Tom Lane wrote: Gavin Sherry [EMAIL PROTECTED] writes: A table space is a directory structure. The directory structure is as follows: [EMAIL PROTECTED] /path/to/tblspc]$ ls OID1/ OID2/ OID1 and OID2 are the OIDs of databases which have created a table space

Re: [HACKERS] Tablespaces

2004-02-26 Thread Tom Lane
Gavin Sherry [EMAIL PROTECTED] writes: A table space is a directory structure. The directory structure is as follows: [EMAIL PROTECTED] /path/to/tblspc]$ ls OID1/ OID2/ OID1 and OID2 are the OIDs of databases which have created a table space against this file system location. In this

Re: [HACKERS] Tablespaces

2004-02-26 Thread Hans-Jürgen Schönig
Gavin Sherry wrote: Is it possible to put WALs and CLOGs into different tablespaces? (maybe different RAID systems). Some companies want that ... I wasn't going to look at that just yet. There is of course the temporary hack of symlinking WAL else where. that's what we do now. we symlink

Re: [HACKERS] Tablespaces

2004-02-26 Thread Gavin Sherry
On Thu, 26 Feb 2004, Dennis Bjorklund wrote: On Thu, 26 Feb 2004, Gavin Sherry wrote: Comments? Questions? Suggestions? Is that plan that in the future one can split a single table into different table spaces? Like storing all rows with year 1999 in one tablespace and the rest in

Re: [HACKERS] tablespaces?

2003-12-09 Thread Shridhar Daithankar
Bruce Momjian wrote: Guys, where are we on tablespaces? Should I set up a project page or does it need organization? I think we need to define the command syntax and then implementation details. I don't think it is that hard and certainly is possible for 7.5. There was a offlist group

[HACKERS] tablespaces?

2003-12-06 Thread Bruce Momjian
Guys, where are we on tablespaces? Should I set up a project page or does it need organization? I think we need to define the command syntax and then implementation details. I don't think it is that hard and certainly is possible for 7.5. -- Bruce Momjian|

<    1   2   3