Re: [HACKERS] Priorities for 6.6

Поиск
Список
Период
Сортировка
Искать
От
Vadim Mikheev
Тема
Re: [HACKERS] Priorities for 6.6
Дата
Msg-id
375A6814.9A9BDA23@krs.ru
Список
Дерево обсуждения
Re: Real Programmers (was: [HACKERS] Priorities for 6.6) Vadim Mikheev <vadim@krs.ru>
Re: Real Programmers (was: [HACKERS] Priorities for 6.6) A James Lewis <james@fsck.co.uk>
Re: Real Programmers (was: [HACKERS] Priorities for 6.6) wieck@debis.com (Jan Wieck)
Re: Real Programmers (was: [HACKERS] Priorities for 6.6) A James Lewis <james@fsck.co.uk>
Bruce Momjian wrote:
> 
> > In short, if you load a bunch of tuples into a table, the first select
> > after the load can run a lot slower than you might expect, because it'll
> > be writing back most or all of the pages it touches.  But that penalty
> > doesn't affect every select, only the first one to scan a newly-written
> > tuple.
> 
> I have removed this from the TODO list:
> 
>         * Prevent fsync in SELECT-only queries

When selecting (i.e. - read-only) transaction commits,
it change pg_log - we obviously can avoid this!
No sense to store commit/abort status of read-only xactions!

Vadim

В списке pgsql-hackers по дате отправления
От: Vadim Mikheev
Дата:
От: wieck@debis.com (Jan Wieck)
Дата:
FAQ