All releases of pgDynamicPartitions

  •  23 Jan 2012 11:52
Avatar

    Release Notes: This release is not a code change, but a change in the example table definitions. The way the example was doing the constraints before was causing query pruning not to work as expected. If your tables are partitioned with these new constraints, you can now do queries like "select * from foo where date(starttime) = ’2012-01-19?", and it will work as expected and only scan the partitions for the day 01-19. That assumes that ‘starttime’ is a timestamp column.

    Screenshot

    Project Spotlight

    episoder

    A tool to tell you about new episodes of your favourite TV shows.

    Screenshot

    Project Spotlight

    BalanceNG

    A modern software IP load balancer.