Re: Partitioning / Clustering

From: PFC
Subject: Re: Partitioning / Clustering
Date: ,
Msg-id: op.sqklj9ppth1vuj@localhost
(view: Whole thread, Raw)
In response to: Re: Partitioning / Clustering  (John A Meinel)
Responses: Re: Partitioning / Clustering  ("Jim C. Nasby")
List: pgsql-performance

Tree view

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, )


> SELECT row1, row2 FROM table1_on_machine_a NATURAL JOIN
> table2_on_machine_b
> WHERE restrict_table_1 AND restrict_table_2
> AND restrict_1_based_on_2;

    I don't think that's ever going to be efficient...
    What would be efficient would be, for instance, a Join of a part of a
table against another part of another table which both happen to be on the
same machine, because the partitioning was done with this in mind (ie. for
instance partitioning on client_id and keeping the information for each
client on the same machine).

    You could build your smart pool daemon in pl/pgsql and use dblink ! At
least you have the query parser built-in.

    I wonder how Oracle does it ;)


pgsql-performance by date:

From: Mischa Sandberg
Date:
Subject: Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL
From: Greg Stark
Date:
Subject: Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL