| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: On Scalability |
| Date: | 2010-10-07 07:28:29 |
| Message-ID: | 4CAD769D.9090301@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On 07.10.2010 10:09, Vincenzo Romano wrote:
> Any feedbacks from TGL and Heikki, then?
I don't have anything to add to what others said already. Your best
advice is to test it yourself.
I would expect the plan time to be linear relative to the number of
partial indexes or child tables involved, except that constraint
exclusion of CHECK constraints on the partitions is exponential. But I
also wouldn't be surprised if there's some other non-linear aspect there
that shows its head with thousands of partitions.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2010-10-07 07:30:56 | Re: Issues with Quorum Commit |
| Previous Message | Vincenzo Romano | 2010-10-07 07:09:58 | Re: On Scalability |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2010-10-07 07:41:30 | Re: On Scalability |
| Previous Message | Vincenzo Romano | 2010-10-07 07:09:58 | Re: On Scalability |