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 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 tablespaces/loc

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

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 c

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 tablesp

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 table

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

2002-10-07 Thread Shridhar Daithankar
On 7 Oct 2002 at 15:52, Hans-Jürgen Schönig wrote: > >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. Use quota > They help you to defin

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