From: | Yan Cheng Cheok <yccheok(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Correct Concept On Table Partition |
Date: | 2010-01-26 10:08:05 |
Message-ID: | 314323.29581.qm@web65706.mail.ac4.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Currently, I plan to use table partition to solve the following problem.
I have a table which is going to grow to a very huge row, as time goes on.
As I know, as table grow larger, the read operation will be slower.
Hence, I decide to use table partition, in order to improve read speed.
I have parent table named measurement.
Then I will have child tables named measurement_1, measurement_2, ....
First 1st millions rows will be write to measurement_1, 2nd millions into measurement_2, ....
My understanding is,
(1) measurement table will act as a virtual table, which make me easy for me to perform query read and query write.
(2) measurement_1, measurement_2 will be "real" table.
(3) when viewing the 2nd millions row (1,000,001 - 2,000,000) of measurement,
before partition
================
instead of reading total 2 millions row, and displaying the (1,000,001 - 2,000,000)
after partition
===============
we will just need to access table measurement_2 only, which is smaller, and shall be faster.
(4) extensive join operation will be involve. I am more concern into read speed.
Is this the correct expectation, on table partition?
Thanks and Regards
Yan Cheng CHEOK
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2010-01-26 10:36:07 | Re: Primary Key Increment Doesn't Seem Correct Under Table Partition |
Previous Message | Yan Cheng Cheok | 2010-01-26 10:00:58 | Primary Key Increment Doesn't Seem Correct Under Table Partition |