On 20 March 2012 22:22, John R Pierce <pie...@hogranch.com> wrote: > your 7000 tables all contain the exact same information, with the only > difference being the stock ticker symbol, right? then really, the single > table, perhaps partitioned by month or whatever, is the right way to go. > Any schema that makes you have to build SQL statements from strings for > each query is designed wrong.
each table contains 1 minute price data for that symbol, so each table has the same schema, open, high,low,close and volume etc, but not the same data.. Thanks. > > > > -- > john r pierce N 37, W 122 > santa cruz ca mid-left coast > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
