Re: PostgreSQL Parallel Processing !
От | Marti Raudsepp |
---|---|
Тема | Re: PostgreSQL Parallel Processing ! |
Дата | |
Msg-id | CABRT9RD_VXa4zEDVYoe4a0TgDFbidBC884q_2S47hyre_Sp9Sg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: PostgreSQL Parallel Processing ! (sridhar bamandlapally <sridhar.bn1@gmail.com>) |
Ответы |
Re: PostgreSQL Parallel Processing !
Re: PostgreSQL Parallel Processing ! |
Список | pgsql-performance |
On Fri, Jan 27, 2012 at 06:31, sridhar bamandlapally <sridhar.bn1@gmail.com> wrote: > -------------------------------------------------------------------------- > | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | > -------------------------------------------------------------------------- > | 0 | SELECT STATEMENT | | 7444K| 944M| 16077 (4)| 00:03:13 | > | 1 | TABLE ACCESS FULL| EMP | 7444K| 944M| 16077 (4)| 00:03:13 | > -------------------------------------------------------------------------- Sorry to take this off topic, but... Seriously, over 3 minutes to read 944 MB of data? That's less than 5 MB/s, what's wrong with your database? :) Regards, Marti
В списке pgsql-performance по дате отправления: