Creating partitions automatically in PostgreSQL

Thanks for your really interesting article. What about reading from the tables? Doesn’t this make it much much harder to query? I will not be able to query for things that span on several days as the “global” table `testing_partition` doesn’t exist. Maybe implementing a VIEW that does a UNION of all the partitions? (I guess it would be slooooooooooooooooooooooow :-(

Show your support

Clapping shows how much you appreciated Luc Stepniewski’s story.