Re: Partitioning / Clustering

От: Jim C. Nasby
Тема: Re: Partitioning / Clustering
Дата: ,
Msg-id: 20050510221554.GR31103@decibel.org
(см: обсуждение, исходный текст)
Ответ на: Re: Partitioning / Clustering  (Mischa Sandberg)
Ответы: Re: Partitioning / Clustering  (Mischa Sandberg)
Список: pgsql-performance

Скрыть дерево обсуждения

Partitioning / Clustering  (Alex Stapleton, )
 Re: Partitioning / Clustering  (John A Meinel, )
  Re: Partitioning / Clustering  ("Adam Haberlach", )
   Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (, )
    Re: Partitioning / Clustering  (Mischa Sandberg, )
   Re: Partitioning / Clustering  (John A Meinel, )
    Re: Partitioning / Clustering  (PFC, )
     Re: Partitioning / Clustering  ("Jim C. Nasby", )
   Re: Partitioning / Clustering  (Bruno Wolff III, )
  Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (Josh Berkus, )
    Re: Partitioning / Clustering  (Neil Conway, )
     Re: Partitioning / Clustering  ("Joshua D. Drake", )
      Re: Partitioning / Clustering  (Neil Conway, )
       Re: Partitioning / Clustering  (Josh Berkus, )
        Re: Partitioning / Clustering  (Neil Conway, )
   Re: Partitioning / Clustering  (Mischa Sandberg, )
    Re: Partitioning / Clustering  ("Jim C. Nasby", )
     Re: Partitioning / Clustering  (Mischa Sandberg, )
      Re: Partitioning / Clustering  (Tom Lane, )
   Re: Partitioning / Clustering  (Christopher Kings-Lynne, )
    Re: Partitioning / Clustering  (Mischa Sandberg, )
     Re: Partitioning / Clustering  ("Joshua D. Drake", )
     Re: Partitioning / Clustering  (Christopher Kings-Lynne, )
      Re: Partitioning / Clustering  (Mischa Sandberg, )
 Re: Partitioning / Clustering  (Simon Riggs, )
  Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (Christopher Kings-Lynne, )
    Re: Partitioning / Clustering  (Simon Riggs, )
   Re: Partitioning / Clustering  (Greg Stark, )
 Re: Partitioning / Clustering  ("David Roussel", )
  Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (Alex Stapleton, )
  Re: Partitioning / Clustering  (Josh Berkus, )
   Re: Partitioning / Clustering  (PFC, )
   Re: Partitioning / Clustering  (PFC, )
  Re: Partitioning / Clustering  ("Jim C. Nasby", )
  Re: Partitioning / Clustering  (PFC, )
   Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (Alex Turner, )
    Re: Partitioning / Clustering  (Alex Stapleton, )
     Re: Partitioning / Clustering  (Alex Turner, )
      Re: Partitioning / Clustering  (John A Meinel, )
       Re: Partitioning / Clustering  (Josh Berkus, )
        Re: Partitioning / Clustering  (Alex Stapleton, )
  Re: Partitioning / Clustering  (PFC, )
 Re: Partitioning / Clustering  (Josh Berkus, )

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               
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?"


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: Configing 8 gig box.
От: Sam Vilain
Дата:
Сообщение: Re: Prefetch