| From: | Yan Cheng Cheok <yccheok(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Is It Good Practice That I use TableName-Month-Year Convention |
| Date: | 2010-01-13 08:16:38 |
| Message-ID: | 558771.51019.qm@web65703.mail.ac4.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I realize the READ performance goes down dramatically when my table goes large. Every new day goes on, my table can increase x millions of new rows.
I was wondering whether this is good practice I can design my database in this way?
Instead of having
lot <-> unit <-> measurement
Can I have
lot-March-2010 <-> unit-March-2010 <-> measurement-March-2010
lot-April-2010 <-> unit-April-2010 <-> measurement-April-2010
(1) That's mean in my stored procedure, I need to dynamically generate the table name. Is this the "dynamic SQL" to correct way, to dynamically generate table name : http://www.postgresql.org/docs/8.1/interactive/ecpg-dynamic.html
(2) Is this consider a good approach, to overcome speed problem (especially read speed). Any potential problem I should put an eye on, before I implement this strategy?
Thanks and Regards
Yan Cheng CHEOK
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yan Cheng Cheok | 2010-01-13 08:28:39 | Re: Extremely Slow Cascade Delete Operation |
| Previous Message | Grzegorz Jaśkiewicz | 2010-01-13 08:13:30 | Re: Extremely Slow Cascade Delete Operation |