Re: Parallel safety of CURRENT_* family
От | Tom Lane |
---|---|
Тема | Re: Parallel safety of CURRENT_* family |
Дата | |
Msg-id | 14911.1480627621@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Parallel safety of CURRENT_* family (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: Parallel safety of CURRENT_* family
|
Список | pgsql-hackers |
Robert Haas <robertmhaas@gmail.com> writes: > On Thu, Dec 1, 2016 at 3:46 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >> but it doesn't: >> >> regression=# select distinct transaction_timestamp() from tenk1; >> transaction_timestamp >> ------------------------------- >> 2016-12-01 15:44:12.839417-05 >> (1 row) >> >> How is that happening? > Because the table is so small, the leader probably finishes running > the whole plan before the workers finish starting up. Good try, but EXPLAIN ANALYZE says that the workers are processing some of the rows. Also, I see the same behavior with a much larger test table. > You can see the problem like this, though: Yeah, I didn't have any doubt that it was real. Still don't know why my test case isn't doing what I expected, though. regards, tom lane
В списке pgsql-hackers по дате отправления: