Re: [SQL] two queryes in a single tablescan
От | Andreas Kretschmer |
---|---|
Тема | Re: [SQL] two queryes in a single tablescan |
Дата | |
Msg-id | 20071020171938.GA24518@KanotixBox обсуждение исходный текст |
Ответ на | Re: [SQL] two queryes in a single tablescan (Markus Schaber <schabi@logix-tt.com>) |
Ответы |
Re: [SQL] two queryes in a single tablescan
|
Список | pgsql-performance |
Markus Schaber <schabi@logix-tt.com> schrieb: > > is there any way to get both results in a single query, > > eventually through stored procedure? > > The retrieved [count(*),A] ; [count(*),B)] data couldnt fit > > on a single table, of course. > > > > The main goal would be to get multiple results while scanning the > > table[s] once only > > thus getting results in a faster way. > > PostgreSQL 8.3 contains great improvements in this area, you can simply > start the selects from concurrent connections, and the backend will > synchronize the scans. works this right across different transactions? I mean, for instance, TX a insert rows and TX b insert other rows and both clients (with different transactions) starts a seq-scan? Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-performance по дате отправления: