ROHIT SACHDEVA <sachdeva.rohit648@xxxxxxxxx> writes: > While using hash partition i am facing the problem that the data is not > going into the proper partition table . Define "proper". It's generally best to assume that the hash function is a black box --- if you assume you know which partition a given key value will be mapped to, you are doing something very fragile, and people will have no sympathy for you when it breaks. If you want a predictable mapping, use list or range partitioning, not hash. regards, tom lane
