"Joshua D. Drake" <jd@commandprompt.com> writes:
>> "MySQL does, however, support the advanced feature of data partitioning
>> within a database. PostgreSQL does not."
> Well there is table partitioning and then there is tablespaces.
> PostgreSQL 8 supports table spaces but not table partitioning.
Note that it's possible to roll-your-own table partitioning in PG, using
either views of table unions or inheritance. It's not going to be as
simple to use as a hard-wired implementation, but on the other hand you
might have more flexibility to tune it to your needs. You can find
reports in the archives from people doing exactly this sort of thing.
The above quote is undoubtedly copied straight from some MySQL marketing
materials, rather than being the result of any serious investigation.
regards, tom lane