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 71D6E53D71 for ; Tue, 10 May 2005 19:16:01 -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 77767-06 for ; Tue, 10 May 2005 22:15:52 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 651D153AAC for ; Tue, 10 May 2005 19:15:51 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 9D52315490; Tue, 10 May 2005 17:15:54 -0500 (CDT) Date: Tue, 10 May 2005 17:15:54 -0500 From: "Jim C. Nasby" To: Mischa Sandberg Cc: pgsql-performance@postgresql.org Subject: Re: Partitioning / Clustering Message-ID: <20050510221554.GR31103@decibel.org> References: <5F94B6EB-3925-4CD3-A67F-4310890B438A@advfn.com> <4280C801.80603@arbash-meinel.com> <1115762155.42812deb506d7@webmail.telus.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1115762155.42812deb506d7@webmail.telus.net> X-Operating-System: FreeBSD 4.11-RELEASE i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/171 X-Sequence-Number: 12335 On Tue, May 10, 2005 at 02:55:55PM -0700, Mischa Sandberg wrote: > just beyond belief, for both updates and queries. At Acxiom, the > datasets are so large, even after partitioning, that they just > constantly cycle them through memory, and commands are executes in > convoys --- sort of like riding a paternoster. Speaking of which... what's the status of the patch that allows seqscans to piggyback on already running seqscans on the same table? > So where should I go look, to see what's been done so far, on a Postgres > that can treat another PG server as a new table type? To the best of my knowledge no such work has been done. There is a project (who's name escapes me) that lets you run queries against a remote postgresql server from a postgresql connection to a different server, which could serve as the basis for what you're proposing. BTW, given your experience, you might want to check out Bizgres. (http://pgfoundry.org/projects/bizgres/) I'm sure your insights would be most welcome. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"