easurement
USING btree
(value) WHERE value IS NULL;
END IF;
Thanks and Regards
Yan Cheng CHEOK
--- On Thu, 1/21/10, Yan Cheng Cheok wrote:
> From: Yan Cheng Cheok
> Subject: Re: [GENERAL] Partitioning on Table with Foreign Key
> To: "Vick Khera"
On Thu, Jan 21, 2010 at 3:46 AM, Yan Cheng Cheok wrote:
> table measurement will have a *lot* of row (millions). I want to speed up
> write and read access. Hence, I use partition technique.
>
> CREATE TABLE measurement_y2006m02 (
> CHECK ( date >= DATE '2006-02-01' AND date < DATE '2006-03-01
Make sense to me. Thanks for the advice. I will try that out.
Thanks and Regards
Yan Cheng CHEOK
--- On Thu, 1/21/10, Vick Khera wrote:
> From: Vick Khera
> Subject: Re: [GENERAL] Partitioning on Table with Foreign Key
> To: "Yan Cheng Cheok"
> Cc: pgsql-general
I am referring to
http://www.postgresql.org/docs/current/static/ddl-partitioning.html
I have the follow table :
table lot
=
id | date |
1 2010-01-19 13:53:57.713
2 2010-01-20 11:34:11.856
table measurement
=
id | fk_lot_id |
12
22
32
42
52
62
72
