Thread: Database structure
I have had a number of years experience with Oracle. I am considering using Postgresql but while there is an enourmous amount of documentation available, none of it seems to answer some questions which I have to resolve if I am to use it.
1. Does postgresql have the concept of table spaces as used in Oracle?
2. Is it possible to construct the data base so that the index for a table can reside on a different disk to the data for the table?
3. Is there an interface for postgresql which can be used to link the data base to web pages?
Regards
Peter Goggin----
Peter, > I have had a number of years experience with Oracle. I am > considering using Postgresql but while there is an enourmous amount > of documentation available, none of it seems to answer some questions > which I have to resolve if I am to use it. Make sure you've looked at http://techdocs.postgresql.org/ There are several Oracle porting guides there. > 1. Does postgresql have the concept of table spaces as used in > Oracle? If you mean Schema, not yet. If you mean temporary tables, yes. Otherwise, no. As far as I know, Oracle's "table space" construction is not part of the SQL 92 or 99 standard. > 2. Is it possible to construct the data base so that the index for a > table can reside on a different disk to the data for the table? Not practically. It can be done, but it would be an annoyance to maintain. I'm curious about why someone would need this. > 3. Is there an interface for postgresql which can be used to link the > data base to web pages? I'm sorry, you'll have to be more specific. -Josh Berkus
For 1 & 2 I believe you have to use symbolic links (the names of the files are the OIDs, there's a contrib module called something like oid2name). If you mean for Administring it, I believe there is phppgadmin, and I've also heard that webmin supports it. regards, - Stuart -----Original Message----- From: Peter Goggin [mailto:pgoggin@smartchat.net.au] Sent: 09 May 2002 15:11 To: pgsql-novice@postgresql.org Subject: [NOVICE] Database structure I have had a number of years experience with Oracle. I am considering using Postgresql but while there is an enourmous amount of documentation available, none of it seems to answer some questions which I have to resolve if I am to use it. 1. Does postgresql have the concept of table spaces as used in Oracle? 2. Is it possible to construct the data base so that the index for a table can reside on a different disk to the data for the table? 3. Is there an interface for postgresql which can be used to link the data base to web pages? Regards Peter Goggin----
Keep in mind that at least in the docs that I've read, symlinks are quoted as being the most expensive object to work with. This is probably only an issue for when the lookup isn't already cached by your operating system. Joshua b. Jore http://www.greentechnologist.org On Thu, 9 May 2002, Henshall, Stuart - WCP wrote: > For 1 & 2 I believe you have to use symbolic links > (the names of the files are the OIDs, there's a > contrib module called something like oid2name). > If you mean for Administring it, I believe there is > phppgadmin, and I've also heard that webmin supports it. > regards, > - Stuart > > -----Original Message----- > From: Peter Goggin [mailto:pgoggin@smartchat.net.au] > Sent: 09 May 2002 15:11 > To: pgsql-novice@postgresql.org > Subject: [NOVICE] Database structure > > > I have had a number of years experience with Oracle. I am considering using > Postgresql but while there is an enourmous amount of documentation > available, none of it seems to answer some questions which I have to resolve > if I am to use it. > > 1. Does postgresql have the concept of table spaces as used in Oracle? > 2. Is it possible to construct the data base so that the index for a table > can reside on a different disk to the data for the table? > 3. Is there an interface for postgresql which can be used to link the data > base to web pages? > > > > Regards > > > > Peter Goggin---- > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >