Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-5131

Improved function create_zbx_partitions() to create PostgreSQL partitioned tables

    XMLWordPrintable

    Details

      Description

      This is an proposal for a little improved partitioning function create_zbx_partitions() shown on:
      http://www.zabbix.com/wiki/howto/db/postgres/partition

      The attached function has fewer lines of code and allows to create partitions beyond the next one

      Usage:
      – Create next partition
      SELECT create_zbx_partitions();
      SELECT create_zbx_partitions(1);

      – Create current partition
      SELECT create_zbx_partitions(0);

      – Create the next but one partition
      SELECT create_zbx_partitions(2);

        Attachments

          Activity

            People

            Assignee:
            martins-v Martins Valkovskis
            Reporter:
            okkuv9xh Marc
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: