Blog

I have a 230GB database without a clustered index that I’m trying to partition into 25 files for efficiency on a hard drive with 460GB of space. I’ve created the partition function and partition scheme, and I have executed the commands. During the partition process, the 25 files grew to about 230GB as well andRead more

I’ve implemented Table Partitioning for one of our Tables which contains loads and loads of data. About 10-20K records are saved every 2-3 minutes. User will want access to the latest 3 months data mostly. So I have created the following partitions i – Data Before 10th-2017 – ii – Data from: 01-10-2017 till 31-12-2017Read more

I’m using a rooted XPeria Z1c. Recently I got myself a bigger SDCard (128 GB) and I decided to use 2 partitions. I started ‘adb shell’ then partitioned the card using sm partition disk:<disk_id> mixed 50 After disconnecting the phone I formatted the 2nd partion as exFAT. Result is that I have 3 partitions onRead more

I’m building a DB that will have several tables partitioned into 64 partitions. Although I’m using PG 10, I’m using the inheritance method as I need greater control over each table than what is currently possible with declarative partitioning. I have a hash function in C that determines which partition to target for all ops.Read more

Given a normal matrix, for example m = Array[a,{4,4}] which has dimensions {4,4}, I can partition it by using: m2 = Partition[m,{2,2}], which has dimensions {2,2,2,2}. Now, if m is a sparse array, for example: m = SparseArray[Table[{i,i}->i,{i,1,4}],{4,4}] I would like to be able to partition it in a similar manner but with the resultRead more

I’m trying to figure out the approximate number of areas the positive $ n$ -space will be divided into if we partition it as follows: we have $ k$ linear functions $ F_1$ , $ F_2$ , …, $ F_k$ on $ n$ variables (with positive “weights” for each variable) that return a real number,Read more

I have a query which was executing in 30 secs before one of its table parititioned and after partitioning the query is ever running. Table that is recently partitioned is ysm_yield_session_master. This new table holds 4 to 5 partitions and each partition has up to ~90 million rows. yr_yield_result and ywd_yield_website_details are other partitioned tablesRead more

I’m trying to create a tilemap in one of my games and I would like to split the tilemap up into grids. By making grids containing a fixed amount of tiles, I only need to render the portion(s) of the tilemap that’s visible inside the camera (i.e, the grid(s) that’s currently inside the camera viewport).Read more