Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming

Поиск
Список
Период
Сортировка
От Shelby Cain
Тема Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
Дата
Msg-id 20040824151212.90135.qmail@web41610.mail.yahoo.com
обсуждение исходный текст
Ответ на Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming  (Shelby Cain <alyandon@yahoo.com>)
Ответы Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow
Список pgsql-general
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Ah-hah.  The win32 hackers should confirm this, but
> my recollection is
> that sync/fsync are no-ops under Cygwin (one of the
> several reasons
> we would never recommend that port for production
> use).  So this would
> fit the assumption that the 7.4 code was simply not
> syncing.
>

Sounds reasonable.  However, I don't see the same
performance hit while doing bulk database operations
(ie: inserts, deletes, updates).  Is that expected
behavior?  Do vacuum operations fsync()/_commit() more
often?

Regards,

Shelby Cain




__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump in stand alone backend
Следующее
От: "Vidyasagara Guntaka"
Дата:
Сообщение: Not able to build libpq for Windows using 8.0.0 beta1