X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DAE6F533AA for ; Tue, 10 May 2005 22:48:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05522-09 for ; Wed, 11 May 2005 01:48:48 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id C5263531C6 for ; Tue, 10 May 2005 22:48:47 -0300 (ADT) Received: from [192.168.1.105] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j4B1fWa3018327; Tue, 10 May 2005 18:41:35 -0700 Message-ID: <42816480.5050108@commandprompt.com> Date: Tue, 10 May 2005 18:48:48 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Mischa Sandberg Cc: pgsql-performance@postgresql.org Subject: Re: Partitioning / Clustering References: <5F94B6EB-3925-4CD3-A67F-4310890B438A@advfn.com> <4280C801.80603@arbash-meinel.com> <42815EBA.7010806@familyhealth.com.au> <1115775266.42816122ec4e3@webmail.telus.net> In-Reply-To: <1115775266.42816122ec4e3@webmail.telus.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/178 X-Sequence-Number: 12342 Mischa Sandberg wrote: > Quoting Christopher Kings-Lynne : > > >>>This is why I mention partitioning. It solves this issue by storing >>>different data sets on different machines under the same schema. >>>These seperate chunks of the table can then be replicated as well for >>>data redundancy and so on. MySQL are working on these things >> >>*laff* >>Yeah, like they've been working on views for the last 5 years, and >>still haven't released them :D :D :D > > > ? > http://dev.mysql.com/doc/mysql/en/create-view.html > ...for MySQL 5.0.1+ ? Yes but MySQL 5 isn't out yet (considered stable). Sincerely, Joshua D. Drake > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org