Gregory Stark escribió: > Alvaro Herrera <alvhe...@commandprompt.com> writes: > > > Jonah H. Harris escribió: > >> Now, in the case where hint bits have been updated and a WAL record is > >> required because the buffer is being flushed, requiring the WAL to be > >> flushed up to that point may be a killer on performance. Has anyone > >> tested it? > > > > I didn't measure it but I'm sure it'll be plenty slow. > > How hard would it be to just take an exclusive lock on the page when setting > all these hint bits?
I guess it will be intolerably slow then. If we were to say "we have CRC now, but if you enable it you have 1% of the performance" we will get laughed at. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
