Dieser Artikel auf Deutsch Alongside various strategies for handling large amounts of data with indexes, PostgreSQL provides another feature: splitting the table with inheritance. This separation of a table's data into different child tables is called “partitioning” in PostgreSQL. Because it does require a bit of effort to implement, and because there are also limitations…
If you plan to partition a continually growing table to parts of a limited size, you'll have to find a suitable way to create new partitions. It's not advisable to do that manually (at least on a production system), it's much better to do that automatically. ...