Re: Technical question for a journalist

Francois Suter m'expliquait  (le 07.01.2005 16:41):

> 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?
>
Hi François,

    I think it was(is) possible by linking (file system link) different
filenodes on different arrays/disks. This was a manual method and
difficult (or at least not possible with only the official PG utilities)
to dump/restore the spreadness of tables along the disks. This is quite
laborious to implement as  you need to scriptshell this (dump/restore).
So to be clear, it was technically possible, but not included really as
a out-of-the-package (out of the box) PG feature.

    That's only a heard/though of. Maybe there are other ways to do such
a thing?

--
Jean-Christophe