Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT

Tom Lane wrote:
>     Partitioning using these techniques will work well with up to
>     perhaps a hundred partitions; don't try to use many thousands of
>     partitions.
>
>             regards, tom lane
>
Hmmm, what happens if I need 10 years of data, in monthly partitions? It
would be 120 partitions. Can you please elaborate on that limitation?
Any plans on lifting that restriction?

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com