Skip site navigation (1) Skip section navigation (2)

On Scalability

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: On Scalability
Date: 2010-07-29 17:08:52
Message-ID: AANLkTi=6=WRpND-MXv92D-+iC9AnYDwLsbbXMXj4uNky@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Hi all.
I'm wondering about PGSQL scalability.
In particular I have two main topics in my mind:

1. What'd be the behavior of the query planner in the case I have
a single huge table with hundreds or thousands of partial indexes
(just differing by the WHERE clause).
This is an idea of mine to make index-partitioning instead of
table-partitioning.

2. What'd be the behavior of the query planner in the case I have
hundreds or thousands of child tables, possibly in a multilevel hierarchy
(let's say, partitioning by year, month and company).

I fear the presence of linear selection algorithms in these two cases that
would kill my design.

Is there any insight about these two points?

-- 
NotOrAnd Information Technologies
Vincenzo Romano
--
NON QVIETIS MARIBVS NAVTA PERITVS

Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2010-07-29 17:12:06
Subject: Re: On Scalability
Previous:From: Tom LaneDate: 2010-07-29 15:20:45
Subject: Re: planner index choice

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-07-29 17:10:28
Subject: Re: string_to_array has to be stable?
Previous:From: Robert HaasDate: 2010-07-29 17:06:03
Subject: Re: string_to_array has to be stable?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group