The database-partitioning tag has no wiki summary.
0
votes
1answer
14 views
function/procedure to update (ALTER) another function/procedure
I have partitioned tables on PostgreSQL 9.2 each and every one with a partition function that looks like this:
CREATE OR REPLACE FUNCTION myPartitionSelectionFunction()
RETURNS trigger AS
$BODY$
...
1
vote
0answers
58 views
Optimising Large SQL Server Tables
I have a very large table with around 50 million rows and 15 columns. Whenever I read, I always need all columns so I can't split them. I have a clustered index on the table with 4 keys and I always ...
-1
votes
0answers
21 views
How to create example data warehouse with PostgreSQL?
I want to create data warehouse with PostgreSQL. I have only basic information about data warehouse. I want to try small example in real database. I am using PostgreSQL. I searched and find pentaho ...
0
votes
0answers
14 views
Retrieving datas from partitioned table - MySQL
I've one generic question regarding retrieving datas from an partitioned table (MySQL Database).
I've Partitioned by Year range in the table.Also i've indexed the partitioned column.
PARTITION BY ...
1
vote
0answers
25 views
Does partitioning a MySQL table also increase index creation performance?
This is something I was wondering since I'm planning to partition a aggregation table with 10 mil records where rebuilding indexes cause table locks for some time.
Because partitions are bluntly put ...
1
vote
1answer
28 views
SQL Server Switch more than one Partition at once
I have 100 parititons in a table that I need to switch to its corresponding stage table (on the same FG and with aligned indexes)
Currently i m using the query below
Alter Table MS_PROD
Switch ...
1
vote
1answer
40 views
Exclude some records from aggregate function
Having this piece of SQL code:
MIN([Price]) OVER (PARTITION BY [Brand], [Article]) AS MinPrice,
Question: how to exclude from MIN() some records, where a.e. [Supplier] != 10?
0
votes
1answer
22 views
MySQL table Partition with FLOOR function (partition function not allowed)?
I'm trying to make a partitioned table with the following RANGE function
CREATE TABLE `fact_events` (
`event_key` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`event_type_key` tinyint(3) unsigned NOT ...
0
votes
0answers
22 views
Creating Dynamic Sub-Partitions In Oracle for a large table
I have a SQL script that creates large temporary table (part of a data warehouse) by selecting data from multiple tables.
My table is partitioned by Country_id and sub partitioned by month_id.
...
0
votes
1answer
17 views
postgresql partition check on hstore field
i have a master table that i am partitioning. everything is fine, except that one of the fields is a hstore type and i would like the CHECK on the partition creation to check against that hstore key's ...
9
votes
8answers
347 views
Storing changes on entities: Is MySQL the proper solution?
i want to store changes that i do on my "entity" table. This should be like a log. Currently it is implemented with this table in MySQL:
CREATE TABLE `entitychange` (
`id` int(11) unsigned NOT NULL ...
-3
votes
1answer
50 views
SQL Server Partitioining on Date field [closed]
Need help - How to create partition in SQL server which will held 2011, 2012, 2013 data in separate file groups.
I'm struggling to understand between RANGE RIGHT or RANGE LEFT....
0
votes
0answers
23 views
How to create a partition for mysql database?
I have questions about partition my MySQL tables. I have a very large table with 5 Million Records. It is a transnational database so this table is going to keep incriminating. So I am thinking to add ...
0
votes
1answer
34 views
how to use vars in the command “create partition” with mysql
I want to create an event that every 15 days executes a procedure. This procedure must to create a new partition. I am doing the following:
/*Vars
v_tab --> logic tables's name
v_year --> ...
0
votes
0answers
47 views
postgreSQL get last ID in partitioned tables /
my question is basically the same as this one, but i couldn't find an answer, its also written "to be solved in the next release" and "easy for min/max scans"
PostgreSQL+table partitioning: ...
