By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

how can we use partition table ?

P: 15
now i have a question, because in our project

some tables have too records ,so the speed of the run application is
very slow ,

we plan to use partition table. but what can we do ?

the restriction condition as followers

the original data in the table ,

means how could i move the data .to other partition tables,

and at the same time the foreign key also must be taken

account.


the table have 2 foreign key , namely reference to other tables
and these tables may be change into partition table also.

so how can we use partition table ?
can anyone help me?

our operation system is windows ,and the language is java .



henry
Sep 7 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
I'm not sure if I understand what u need (mostly because of my poor english), but maybe this site would help
http://www.postgresql.org/docs/8.1/i...titioning.html
Sep 7 '07 #2

P: 15
I'm not sure if I understand what u need (mostly because of my poor english), but maybe this site would help
http://www.postgresql.org/docs/8.1/i...titioning.html

thank you for your help
actually , my english is poor. .
Sep 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.