Re: [PERFORM] Partitions and max_locks_per_transaction

2009-11-20 Thread Hrishikesh Mehendale
It was Thursday 19 November 2009 11:08:10 pm that the wise Tom Lane thus wrote: hashincl...@gmail.com writes: To make make the retrieval faster, I'm using a partitioning scheme as follows: stats_300: data gathered at 5 mins, child tables named stats_300_t1_t2 (where t2 - t1 = 2 hrs),

Re: [PERFORM] Partitions and max_locks_per_transaction

2009-11-19 Thread Tom Lane
=?UTF-8?B?SHJpc2hpa2VzaCAo4KS54KWD4KS34KWA4KSV4KWH4KS2IOCkruClh+CkueClh+CkguCkpuCksw==?= =?UTF-8?B?4KWHKQ==?= hashincl...@gmail.com writes: To make make the retrieval faster, I'm using a partitioning scheme as follows: stats_300: data gathered at 5 mins, child tables named stats_300_t1_t2