On Wed, 2007-05-02 at 10:52, Martin Gainty wrote:
> Good Morning Scott-
>
> The following URL contains the directive to Move Partition in a Partitioned
> Tables
> http://www.csee.umbc.edu/help/oracle8/server.815/a67772/partiti.htm
> you will then need to rebuild the indices to point to the new partition
Yeah, I've seen that, and used it even.
> Is there some manner of automatically rebuilding the indices when moving
> partition tables under Postgres?
You don't need to move partition tables / rebuild indexes in postgresql
generally, that was my main point. If you need to reclaim space because
you forgot to regularly vacuum, then you can do a vacuumdb -fz and a
reindexdb... And no mucked up indexes like you get when you move a
table in oracle and forget to rebuild its indexes. Why automatic index
rebuilding wasn't a part of oracle 9 I'll never know.
It just seems that all the things someone decided to write a script /
program for in postgresql that got included into the pgsql/bin directory
or at least contrib or pgfoundy are spread across various web pages for
oracle. Which seems almost backwards. I'd kind of expect the open
source project to have things all over the web, mildly disorganized, and
the commercial project to have it all come with the package.
Keep in mind, I'm not slagging Oracle, really. It's an impressive
database. It just feels krufty, like there are tons of things you just
"have to know" to make it work. More than I'd expected when I first
started using it.