Re: Benchmark-Comparison PostGreSQL vs. SQL Server

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Benchmark-Comparison PostGreSQL vs. SQL Server
Дата
Msg-id 200411251836.07053.ghodechhap@ghodechhap.net
обсуждение исходный текст
Ответ на Re: Benchmark-Comparison PostGreSQL vs. SQL Server  (Richard Huxton <dev@archonet.com>)
Ответы Re: Benchmark-Comparison PostGreSQL vs. SQL Server  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
On Thursday 25 Nov 2004 6:22 pm, Richard Huxton wrote:

> > On the other hand, if an application has to "fight" against the file
> > system, I would suppose it to increase RAM and CPU usage
> > significantly.
>
> It shouldn't be fighting the file system, but it does use it, and rely
> on it for caching (rather than bypassing your filesystem cache). For
> MS-SQL server I'm guessing you're allocating a lot of memory to SQL
> server and not much to the file-cache. For PG you'll want it the other
> way around.

Do we have some sort of document about how caching on windows works? It is
very simple on linux and BSDs but for other OSs, I haven't seen many
suggestions.

I am sure OS specific hints would help OP a lot.

 Shridhar



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

Предыдущее
От: "ON.KG"
Дата:
Сообщение: Re: Trigger before insert
Следующее
От: Daniel Martini
Дата:
Сообщение: Re: why use SCHEMA? any real-world examples?