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

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow
Дата
Msg-id cgfoqd$6vk$2@floppy.pyrenet.fr
обсуждение исходный текст
Ответ на Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming  (Shelby Cain <alyandon@yahoo.com>)
Список pgsql-general
Shelby Cain wrote:

> --- 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?

I think you have other problems around, see the post where
I did some tests.


Regards
Gaetano Mendola



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Invalid input for integer on VIEW
Следующее
От: Silvio Matthes
Дата:
Сообщение: WG: Re: Re: select ... where ='' does a seqscan [auf Viren geprueft]