Re: Partitioning / Clustering

От: Mischa Sandberg
Тема: Re: Partitioning / Clustering
Дата: ,
Msg-id: 1115777953.42816ba1b4618@webmail.telus.net
(см: обсуждение, исходный текст)
Ответ на: Re: Partitioning / Clustering  ("Jim C. Nasby")
Ответы: Re: Partitioning / Clustering  (Tom Lane)
Список: 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, )

Quoting "Jim C. Nasby" <>:

> 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.

Okay, if the following looks right to the powerthatbe, I'd like to start
a project. Here's the proposition:

"servername.dbname.schema.object" would change RangeVar, which would
affect much code. "dbname.schema.object" itself is not implemented in
8.0. So, simplicity dictates something like:

table pg_remote(schemaname text, connectby text, remoteschema text)

The pg_statistic info from a remote server cannot be cached in local
pg_statistic, without inventing pseudo reloids as well as a
pseudoschema. Probably cleaner to cache it somewhere else. I'm still
reading down the path that puts pg_statistic data where costsize can get
at it.

First step: find out whether one can link libpq.so to postmaster :-)



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

От: "David Roussel"
Дата:
Сообщение: Re: Partitioning / Clustering
От: "Edin Kadribasic"
Дата:
Сообщение: Optimizer wrongly picks Nested Loop Left Join