Do you really need a DBA?
Let me say at the getgo: Every organization needs full-time database management. Delaying the hiring of a full time DBA could lead to a bunch of problems that are festering and growing to the point where easy, non-intrusive fixes may not be possible anymore. Unfortunately, some organizations either have never had a DBA or do […]
Is there a limit on number of partitions handled by Postgres?
PostgreSQL is continuously improving partitions support but there is limitations on number of partitions handled by each release. Based on our experience , if you are using a lot more partitions than its practical limit for a PostgreSQL release, you will experience performance degradation during the planning phase of the query. When you approach the […]