why select count(*) consumes wal logs
| От | Ravi Krishna |
|---|---|
| Тема | why select count(*) consumes wal logs |
| Дата | |
| Msg-id | 653931906.1147337.1541523848244@mail.yahoo.com обсуждение исходный текст |
| Ответы |
Re: why select count(*) consumes wal logs
Re: why select count(*) consumes wal logs |
| Список | pgsql-general |
PG 10.5 I loaded 133 million rows to a wide table (more than 100 cols) via COPY. The table has no index at this time. Since I am the only user I don't see any other activity. Now when I run select count(*) on the table where I just loaded data, it runs for ever, more than 10min and still running. Intrigued, I checked locks and saw nothing. Then I noticed something strange. When select count(*) runs, PG is writing to wal_logs, and that too a large amount. Why? I suspect vaccum is getting triggered, but this is a brand new table with no updates. So it should not. Is there a SQL to peek into what PG is doing to write so much to WAL logs ?
В списке pgsql-general по дате отправления: