Re: Table spaces again [was Re: [HACKERS] Threaded Sorting]

2002-10-08 Thread Hans-Jürgen Schönig
Jim Buttafuoco wrote: Is this NOT what I have been after for many months now. I dropped the tablespace/location idea before 7.2 because that didn't seem to be any interest. Please see my past email's for the SQL commands and on disk directory layout I have proposed. I have a working 7.2

Re: Table spaces again [was Re: [HACKERS] Threaded Sorting]

2002-10-07 Thread Hans-Jürgen Schönig
Can anybody please tell me in detail.(Not just a pointing towards TODO items) 1) What a table space supposed to offer? They allow you to define a maximum amount of storage for a certain set of data. They help you to define the location of data. They help you to define how much data can be

Re: Table spaces again [was Re: [HACKERS] Threaded Sorting]

2002-10-07 Thread Hans-Jürgen Schönig
2) What a directory structure does not offer that table space does? You need to the command line in order to manage quotas - you might not want that. Mount a directory on a partition. If the data exceeds on that partition, there would be disk error. Like tablespace getting

Re: Table spaces again [was Re: [HACKERS] Threaded Sorting]

2002-10-07 Thread Shridhar Daithankar
On 7 Oct 2002 at 16:49, Hans-Jürgen Schönig wrote: Mount a directory on a partition. If the data exceeds on that partition, there would be disk error. Like tablespace getting overflown. I have seen both the scenarios in action.. Of course it can be done somehow. However, with tablespaces

Re: Table spaces again [was Re: [HACKERS] Threaded Sorting]

2002-10-07 Thread Tom Lane
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= [EMAIL PROTECTED] writes: how would you handle table spaces? The plan that's been discussed simply defines a tablespace as being a directory somewhere; physical storage of individual tables would remain basically the same, one or more files under the

Re: Table spaces again [was Re: [HACKERS] Threaded Sorting]

2002-10-07 Thread Hans-Jürgen Schönig
Quotas are handled differently on ever platform (if available). Yeah. But that's sysadmins responsibility not DBA's. Maybe many people ARE the sysadmins of their PostgreSQL box ... When developing a database with an open mind people should try to see a problem from more than

Re: Table spaces again [was Re: [HACKERS] Threaded Sorting]

2002-10-07 Thread Jim Buttafuoco
Is this NOT what I have been after for many months now. I dropped the tablespace/location idea before 7.2 because that didn't seem to be any interest. Please see my past email's for the SQL commands and on disk directory layout I have proposed. I have a working 7.2 system with