Splitting a database table into multiple segments for performance or manageability.
0
votes
0answers
9 views
What inefficiency does sharding & partitioning attempt to address?
I have never implemented sharding or partitioning, but from what I understand, multiple servers are used to distribute large amounts of data.
Is this because of a limited hardware budget or to ...
1
vote
1answer
18 views
Logically Horizontale-Partitioned Tables
I have two legacy tables, lets call them TableA and TableB. Both of them fall under the same schema design with identical columns, in other words you can union them directly as one table. The only ...
3
votes
3answers
93 views
Best practices for configuring the Drive/Filegroup setup for Microsoft SQL 2008
I am a software developer for a small company. I wish we had a dba but not in the cards at this point for this company. I was working on migrating our 75gb SQL Server 2000 database to SQL Server 2008 ...
1
vote
2answers
40 views
Return ID from partitioned table in postgres?
When I insert a record I need to return the inserted id by RETURNING. The problem is that the table is partitioned and in partitioned table I can't use RETURNING. I run multiple queries at once so I'm ...
0
votes
1answer
19 views
Does Oracle Partition by Reference optimizes join queries
Oracle 11g has a new feature in partitioning tables called partition by reference.
I want to know whether Oracle joins (nested-loop-joins or hash-join or ...) rows from proper partitions when joining ...
0
votes
1answer
42 views
Proper drive partitioning in Linux for Oracle
I have a current production physical server running on RHEL and I'm going to be building a new Oracle Linux VM to take it's place. Below is a listing of the existing physical drive partitions.
Can ...
3
votes
0answers
54 views
Storing and querying rolling data in PostgreSQL
I have a large quantity of weather model data being put into a PostgreSQL database. The machine has 8 cores and 16 GB of RAM. I'm running PostgreSQL 9.3 with PostGIS 2.1. Each table will have a ...
5
votes
2answers
163 views
Oracle partition by interval using persian calendar
Oracle supports Persian (Jalali) calendar in DDL queries, I can easily say:
select to_char(register_date, 'YYYY-MM-DD', 'nls_calendar=persian')
from my_table;
I created a table as:
create ...
6
votes
1answer
83 views
How accurate is the sys.partition.rows column?
The system view sys.partitions has a column "rows" that is the total number of rows in a given partition. For a table that is not partitioned (or only has one partition depending on how you look at ...
1
vote
1answer
44 views
Postgres: Put 1 database in separate HD partition?
I have 2 HD partitions - one with SSD and another with regular hard drives.
I have multiple databases (as in logical database, not physical) with 1 data directory. I want the data for 1 of the ...
0
votes
1answer
179 views
Database partitioning - Horizontal and Vertical sharding - Difference between Normalization and Row Splitting?
I am trying to grasp the different concepts of Database Partitioning and this is what I understood of it:
Horizontal Partitioning/Sharding: Splitting a table into different tables that will contain a ...
1
vote
1answer
27 views
Snapshotting Database Tables
I have a reporting database (in SQL Server) that takes nightly snapshots of the production data (Oracle) for users to query against for the next day, but now the requirement is getting to be that they ...
0
votes
1answer
48 views
Constrain exclusion to fetch latest N rows
I'm managing a table with several million records which are being inserted in real time.
A part of my app needs to display the last N inserted records, so at the beginning I just queried for:
...
3
votes
0answers
69 views
PostgreSQL 9.2 - Partitioning: Constraint Exclusion on SELECT not kicking in [closed]
My partitioned table SELECT queries include all partitioned tables even though checks are in place and constraint_exclusion = on.
The insert trigger works fine and new rows are inserted into the ...
1
vote
1answer
189 views
Partitioning MySQL vs PostgreSQL
For our new system we are looking for database server. We considered a lot of pros/cons for MySQL(InnoDB) vs PostgreSQL and the breaking point for us is partitioning. We will choose the one which ...
