Re: Speeding up INSERTs and UPDATEs to partitioned tables
| От | Krzysztof Nienartowicz |
|---|---|
| Тема | Re: Speeding up INSERTs and UPDATEs to partitioned tables |
| Дата | |
| Msg-id | 1539597853300-0.post@n3.nabble.com обсуждение |
| Ответ на | Re: Speeding up INSERTs and UPDATEs to partitioned tables (David Rowley <david.rowley@2ndquadrant.com>) |
| Ответы |
Re: Speeding up INSERTs and UPDATEs to partitioned tables
Re: Speeding up INSERTs and UPDATEs to partitioned tables |
| Список | pgsql-hackers |
We see quite prohibitive 5-6x slowdown with native partitioning on in comparison to trigger based in PG9.5. This is clearly visible with highly parallel inserts (Can share flamediagrams comparing the two). This basically excludes native partitioning from being used by us. Do you think your changes could be backported to PG10? - we checked and this would need quite a number of changes but given the weight of this change maybe it could be considered? Thanks Krzysztof -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
В списке pgsql-hackers по дате отправления: