Martin Gainty wrote: > Good Afternoon All- > I come from the other DBMS from California where extremely large datasets > could be partitioned into separate and distinct partition tables > Lets say for example I have Property Table which contains a tera worth of > data and to gain performnce in the indexing I *could* partition this table so > that > All Cities which are A-M are in Partition1PropertyTable > All Cities which are N-Z are in Parition2PropertyTable > Can I achieve this in Postgres DB?
http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html Joshua D. Drake > Thanks, > Martin -- > --------------------------------------------------------------------------- > This e-mail message (including attachments, if any) is intended for the use > of the individual or entity to which it is addressed and may contain > information that is privileged, proprietary , confidential and exempt from > disclosure. If you are not the intended recipient, you are notified that any > dissemination, distribution or copying of this communication is strictly > prohibited. > --------------------------------------------------------------------------- > Le présent message électronique (y compris les pièces qui y sont annexées, le > cas échéant) s'adresse au destinataire indiqué et peut contenir des > renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le > destinataire de ce document, nous vous signalons qu'il est strictement > interdit de le diffuser, de le distribuer ou de le reproduire. > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
