On Aug 7, 2009, at 5:44 PM, Greg Stark wrote:
On Sat, Aug 8, 2009 at 12:27 AM, Bob Gobeille<bob.gobeille@xxxxxx>
wrote:
I gather from rtfm that it is typical to set up partitions so that
the
"master" table has no records. But from my understanding of
partitions and
doing some tests, I don't see any reason that has to be. So I'm
wondering
if I'm missing some subtle (or not so subtle) point about partitions?
It's purely a convenience issue. Any child partition can be removed
later, The parent will be a pain if you ever want to remove it from
the partitioning structure.
Cool. In my case this won't be an issue. My app loads in archives
(.tar, .iso, etc) and stores the contained file hierarchies in the db
(organized by the archive). So if an archive only has a few thousand
files, I'll just save those few thousand records in the master table.
But if the archive has millions of files (some distro iso's have ~7M
files), I want to store them in their own partition.
Many thanks for the confirmation!
Bob Gobeille
bobg@xxxxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
