From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Boszormenyi Zoltan <zb(at)cybertec(dot)at> |
Cc: | PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>, pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: plan time of MASSIVE partitioning ... |
Date: | 2010-09-08 13:54:11 |
Message-ID: | AANLkTi=wMcigktiaT6O=Y56Qgdwxpq-XfrF-Jyi71RB8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Sep 7, 2010 at 2:14 PM, Boszormenyi Zoltan <zb(at)cybertec(dot)at> wrote:
> Hi,
>
> Robert Haas írta:
>> 2010/9/3 PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>:
>>
>>> i tried this one with 5000 unindexed tables (just one col):
>>>
>>> test=# \timing
>>> Timing is on.
>>> test=# prepare x(int4) AS select * from t_data order by id desc;
>>> PREPARE
>>> Time: 361.552 ms
>>>
>>> you will see similar or higher runtimes in case of 500 partitions and a handful of indexes.
>>>
>>
>> I'd like to see (1) a script to reproduce your test environment (as
>> Stephen also requested) and (2) gprof or oprofile results.
>>
>
> attached are the test scripts, create_tables.sql and childtables.sql.
> The following query takes 4.7 seconds according to psql with \timing on:
> EXPLAIN SELECT * FROM qdrs
> WHERE streamstart BETWEEN '2010-04-06' AND '2010-06-25'
> ORDER BY streamhash;
Neat. Have you checked what effect this has on memory consumption?
Also, don't forget to add it to
https://commitfest.postgresql.org/action/commitfest_view/open
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-09-08 14:01:36 | Re: UTF16 surrogate pairs in UTF8 encoding |
Previous Message | Robert Haas | 2010-09-08 13:50:59 | Re: Synchronization levels in SR |