Re: plpgsql returning resultset

From: Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql returning resultset
Date: 2008-09-03 09:42:49
Message-ID: 48BE5C19.20003@ifi.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Roberts, Jon wrote:
> PostgreSQL has table partitioning in it so you don't have to dynamically
> figure out which table to get the data from.

I know, but the super table can't handle the number of partition tables
I need, 10K-100K tables. Whenever I do a query on the super table, it
just aborts.

regards

thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Maxim Boguk 2008-09-03 11:19:55 Postgresql optimisator deoptimise queries sometime...
Previous Message Tom Lane 2008-09-03 04:31:12 Re: Index non-usage problem in 8.2.9