Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql returning resultset - Mailing list pgsql-general

From Thomas Finneid
Subject Re: plpgsql returning resultset
Date
Msg-id 48BE5C19.20003@ifi.uio.no
Whole thread Raw
In response to Re: plpgsql returning resultset  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: aderose
Date:
Subject: vacuum analyze hurts performance
Next
From: Maxim Boguk
Date:
Subject: Postgresql optimisator deoptimise queries sometime...