From: Jim C. Nasby <decibel@decibel.org>
To: Mischa Sandberg <mischa.sandberg@telus.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Partitioning / Clustering
Date: Tue, 10 May 2005 17:15:54 -0500
Message-ID: <20050510221554.GR31103@decibel.org> (raw)
In-Reply-To: <1115762155.42812deb506d7@webmail.telus.net>
References: <5F94B6EB-3925-4CD3-A67F-4310890B438A@advfn.com>
<4280C801.80603@arbash-meinel.com>
<DCFAEF09-885E-492C-A885-EEE405E7773F@advfn.com>
<1115762155.42812deb506d7@webmail.telus.net>
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?"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: decibel@decibel.org, mischa.sandberg@telus.net
Subject: Re: Partitioning / Clustering
In-Reply-To: <20050510221554.GR31103@decibel.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox