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: > 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), i.e. 12 tabl

Re: [PERFORM] Partitions and max_locks_per_transaction

2009-11-19 Thread Tom Lane
=?UTF-8?B?SHJpc2hpa2VzaCAo4KS54KWD4KS34KWA4KSV4KWH4KS2IOCkruClh+CkueClh+CkguCkpuCksw==?= =?UTF-8?B?4KWHKQ==?= 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 h

[PERFORM] Partitions and max_locks_per_transaction

2009-11-19 Thread हृषीकेश मेहेंदळ े
Hi All, I have a stats collection system where I collect stats at specific intervals (from network monitoring nodes), and stuff them into a PostgreSQL DB. 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_30