[GENERAL] Out of shared memory (locks per process) using table-inheritance style partitioning

2007-08-30 Thread John Prevost
straint. Are there plans in the works for a new partitioning system (either based on inheritance, or based on something else)? If there are, has any thought been put into how to avoid locking massive numbers of partitions? Thanks very much, John Prevost. ---(end of broadcast

Re: [GENERAL] Out of shared memory (locks per process) using table-inheritance style partitioning

2007-08-31 Thread John Prevost
> So what's the problem? Increase max_locks_per_transaction. The reason > we have that as a tunable is mainly to support systems with very large > numbers of tables. So increasing this value into the thousands is a reasonable approach? If it is reasonable, that's fine. I'll certainly be increas