|
|
 | | From: | Magnus Hagander | | Subject: | Re: Technical question for a journalist | | Date: | Fri, 7 Jan 2005 16:46:34 +0100 |
|
|
 | > Hi list,
>
> No need to send out the press release :-), I was alreday
> grilled half an hour by a French journalist about v8. He had
> apparently read an interview of Marc Fournier somewhere.
>
> Anyway, the journalist had a question about tablespaces. I
> told him it enabled clustering on individual disks or arrays
> of disks. The journalist then said that this seemed like a
> rather basic feature and was surprised that PostgreSQL wasn't
> already able to do that in the previous versions. Is that
> indeed the case or was there another clustering mechanism before?
You could do it pre-8.0 but it required manual hacking with symlinks.
Which also required you to do extra symlinks if/when yuor table grew
into several files etc. And you had to shut down the server to do it.
(If you wanted individual items in the same db that is. You could put
entire databases on a separate disk and not nede to do the extra linking
when it grew)
//Magnus
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
|
| | From: | Robert Treat | | Subject: | Re: Technical question for a journalist | | Date: | 07 Jan 2005 12:05:56 -0500 |
|
|
| On Fri, 2005-01-07 at 10:46, Magnus Hagander wrote:
> > Hi list,
> >
> > No need to send out the press release :-), I was alreday
> > grilled half an hour by a French journalist about v8. He had
> > apparently read an interview of Marc Fournier somewhere.
> >
> > Anyway, the journalist had a question about tablespaces. I
> > told him it enabled clustering on individual disks or arrays
> > of disks. The journalist then said that this seemed like a
> > rather basic feature and was surprised that PostgreSQL wasn't
> > already able to do that in the previous versions. Is that
> > indeed the case or was there another clustering mechanism before?
>
> You could do it pre-8.0 but it required manual hacking with symlinks.
> Which also required you to do extra symlinks if/when yuor table grew
> into several files etc. And you had to shut down the server to do it.
> (If you wanted individual items in the same db that is. You could put
> entire databases on a separate disk and not nede to do the extra linking
> when it grew)
>
Anyone know a list of common databases that have or don't have this
feature? I'm thinking of the main players like oracle, m$, db2, sybase,
informix, my$ql, firebird, etc...
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|
|
| | From: | Jean-Christophe Arnu | | Subject: | Re: Technical question for a journalist | | Date: | Fri, 07 Jan 2005 18:38:51 +0100 |
|
|
| Robert Treat m'expliquait (le 07.01.2005 18:05):
>Anyone know a list of common databases that have or don't have this
>feature? I'm thinking of the main players like oracle, m$, db2, sybase,
>informix, my$ql, firebird, etc...
>
>
While googleling a little,
Tablespace functionnality
================
Oracle Yes (really need an url?)
Informix Yes (http://www.oreilly.com/catalog/unixbr/chapter/ch14.html)
DB2 Yes
(http://www-306.ibm.com/software/webservers/appserv/doc/v40/ae/infocenter/was/040401010708.html)
M$$ql Yes
(http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro.mspx)
My$SQL Yes (http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html
since InnoDB)
Firebird does not seem
--
Jean-Christophe
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
|
|
| | From: | Gavin Sherry | | Subject: | Re: Technical question for a journalist | | Date: | Sun, 9 Jan 2005 13:36:32 +1100 (EST) |
|
|
| On Fri, 7 Jan 2005, Jean-Christophe Arnu wrote:
> Robert Treat m'expliquait (le 07.01.2005 18:05):
>
> >Anyone know a list of common databases that have or don't have this
> >feature? I'm thinking of the main players like oracle, m$, db2, sybase,
> >informix, my$ql, firebird, etc...
> >
> >
> While googleling a little,
>
> Tablespace functionnality
> ================
> Oracle Yes (really need an url?)
> Informix Yes (http://www.oreilly.com/catalog/unixbr/chapter/ch14.html)
> DB2 Yes
> (http://www-306.ibm.com/software/webservers/appserv/doc/v40/ae/infocenter/was/040401010708.html)
> M$$ql Yes
> (http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro.mspx)
> My$SQL Yes (http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html
I don't think MySQL's implementation is really at all like ours. It just
means that there is a file per table -- you cannot determine where that
file is, from memory.
> Firebird does not seem
Gavin
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
|
