On 2007-02-21, Mark Kirkwood <[EMAIL PROTECTED]> wrote:
> With respect to 'select count(*) from ...' being slower on FreeBSD,
> there are a number of things to try to make FreeBSD faster for this sort
> of query. Two I'm currently using are:
>
> - setting sysctl vfs.read_max to 16 or 32
> - rebui
Jacek Zarêba wrote:
Hello, I've set up 2 identical machines, hp server 1ghz p3,
768mb ram, 18gb scsi3 drive. On the first one I've installed
Debian/GNU 4.0 Linux, on the second FreeBSD 6.2. On both
machines I've installed Postgresql 8.2.3 from sources.
Now the point :)) According to my tests post
Le mercredi 21 février 2007 10:57, Jacek Zaręba a écrit :
> Now the point :)) According to my tests postgres on Linux
> box run much faster then on FreeBSD, here are my results:
You may want to compare some specific benchmark, as in bench with you
application queries. For this, you can consider T
In response to "Jacek Zaręba" <[EMAIL PROTECTED]>:
> Hello, I've set up 2 identical machines, hp server 1ghz p3,
> 768mb ram, 18gb scsi3 drive. On the first one I've installed
> Debian/GNU 4.0 Linux, on the second FreeBSD 6.2. On both
> machines I've installed Postgresql 8.2.3 from sources.
> Now
On 2/21/07, Jacek Zaręba <[EMAIL PROTECTED]> wrote:
Hello, I've set up 2 identical machines, hp server 1ghz p3,
768mb ram, 18gb scsi3 drive. On the first one I've installed
Debian/GNU 4.0 Linux, on the second FreeBSD 6.2. On both
machines I've installed Postgresql 8.2.3 from sources.
Now the poin
Hello, I've set up 2 identical machines, hp server 1ghz p3,
768mb ram, 18gb scsi3 drive. On the first one I've installed
Debian/GNU 4.0 Linux, on the second FreeBSD 6.2. On both
machines I've installed Postgresql 8.2.3 from sources.
Now the point :)) According to my tests postgres on Linux
box run
