> ------------ Původní zpráva ------------ > Od: Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> > Předmět: Re: postgreSQL multithreading > Datum: 30.3.2008 17:39:02 > ---------------------------------------- > postgre@xxxxxxxxx <postgre@xxxxxxxxx> schrieb: > > > Hi all, > > > > I was trying to find some way to implement multithreading into my postgreSQL > stored functions. > > > > The thing is, that I have data stored in multiple tables - for each day one > table - and I want to write > > a function which selects data from these tables and stores them into files (or > just returns the data in cursor); > > Information about data stored in these tables are in another table defined > like this: > > > > partitions_daily(from_date timestamp, to_date timestamp, table_name) > > > > From_date and to_date tells in which table the requested data should be > found. > > > > In this time I have function through which I can get the data, the problem is > that everything is processed with only > > one CPU core. I think it should be very easy to make this model to be > multithreaded and use more CPU cores. > > I think, the only way to achieve this is to use multiple connections to > the database. One connection to select the table_name and than, for > every table_name, a own connection to the database to select and write > the data to files. > > What about some C dynamically loaded function in which I could call new connection for each thread? Lukas Houf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
