Re: write latency on single partition table

2018-04-09 Thread Alain RODRIGUEZ
Hi, Challenging the possibilty that the latancy is related with the number of record is a good guess indeed. It might be, but I don't think so, given the max 50 Mb partition size. This should should allow to catch a partition of this size, probably below 1 second. It is possible to trace a query

Re: write latency on single partition table

2018-04-06 Thread onmstester onmstester
The size is less than 50MB Sent using Zoho Mail On Sat, 07 Apr 2018 09:09:41 +0430 Laxmikant Upadhyay laxmikant@gmail.com wrote It seems your partition size is more..what is the size of value field ? Try to keep your partition size within 100 mb. On Sat, Apr 7, 2018,

Re: write latency on single partition table

2018-04-06 Thread Laxmikant Upadhyay
It seems your partition size is more..what is the size of value field ? Try to keep your partition size within 100 mb. On Sat, Apr 7, 2018, 9:45 AM onmstester onmstester wrote: > > I've defained a table like this > > create table test ( > hours int, > key1 int, > value1

write latency on single partition table

2018-04-06 Thread onmstester onmstester
I've defained a table like this create table test ( hours int, key1 int, value1 varchar, primary key (hours,key1) ) For one hour every input would be written in single partition, because i need to group by some 500K records in the partition for a report with expected response time in