Reiner Dassing <dassing@wettzell.ifag.de> writes:
> I have a table which has a lot of entries (some x millions) of the kind
> (id, timestamp, value)
> The access (selects) is concentrated to the timely last some thousands
> entries.
> To adapt this fact I want to setup a "virtual" table - test in my
> example - which
> is accessed by the clients but in reality the entries are separated to
> different small
> tables. These table are dynamically created to hold the values
> distinguished by years.
Why bother? Seems like you are just making life complicated for
yourself. One big table with a suitable index ought to work fine.
regards, tom lane