This really should have been asked on pgsql-performance and would probably
get a better response there..
On Sun, Nov 26, 2006 at 16:35:52 +,
Michael Simms <[EMAIL PROTECTED]> wrote:
> PostgreSQL version: 8.1.4
> Operating system: Linux kernel 2.6.12
> Description:Performance seriou
>>> On Sun, Nov 26, 2006 at 5:24 AM, in message
<[EMAIL PROTECTED]>, Joost Kraaijeveld
<[EMAIL PROTECTED]> wrote:
>
> Are there guidelines (or any empirical data) available how to
determine
> how often a table should be vacuumed for optimum performance or is
this
> an experience / trial- and- er
* Jim C. Nasby:
> What's interesting is that apparently FreeBSD also has overcommit (and
> IIRC no way to disable it), yet I never hear people going off on OOM
> kills in FreeBSD. My theory is that FreeBSD admins are smart enough to
> dedicate a decent amount of swap space, so that by the time you
Am 27.11.2006 um 17:05 schrieb AgentM:
There is a known unfortunate limitation on Darwin for SysV shared
memory which, incidentally, does not afflict POSIX or mmap'd shared
memory.
Hmmm. The article from Chris you have linked does not mention the
size of the mem segment you can allocate.
On Nov 27, 2006, at 2:23 , Brian Wipf wrote:
On 26-Nov-06, at 11:25 PM, Jim C. Nasby wrote:
On Sat, Nov 18, 2006 at 08:13:26PM -0700, Brian Wipf wrote:
It certainly is unfortunate if Guido's right and this is an upper
limit for OS X. The performance benefit of having high
shared_buffers
on
On Sun, Nov 26, 2006 at 05:41:02PM -0600, Jim C. Nasby wrote:
What's interesting is that apparently FreeBSD also has overcommit (and
IIRC no way to disable it), yet I never hear people going off on OOM
kills in FreeBSD.
Could just be that nobody is using FreeBSD.
Seriously, though, there are
On Mon, Nov 27, 2006 at 07:23:47AM +, Brian Wipf wrote:
> On 26-Nov-06, at 11:25 PM, Jim C. Nasby wrote:
> >On Sat, Nov 18, 2006 at 08:13:26PM -0700, Brian Wipf wrote:
> >>It certainly is unfortunate if Guido's right and this is an upper
> >>limit for OS X. The performance benefit of having hig
On 11/25/06, Arnau <[EMAIL PROTECTED]> wrote:
Hi all,
I have a table with statistics with more than 15 million rows. I'd
like to delete the oldest statistics and this can be about 7 million
rows. Which method would you recommend me to do this? I'd be also
interested in calculate some kind of
Hi.
After I had my hands on an Intel MacBook Pro (2 GHz Core Duo, 1GB
RAM), I made some comparisons between the machines I have here at the
company.
For the ease of it and the simple way of reproducing the tests, I
took pgbench for the test.
Konfigurations:
1. PowerMac G5 (G5 Mac OS X)