Re: reindex/vacuum locking/performance?

From: "Ronald Khoo" <ronald(at)cpm(dot)com(dot)my>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: reindex/vacuum locking/performance?
Date: 2003-10-06 03:07:01
Message-ID: blqm9l$ne5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> This would be relatively easy to fix as far as our own buffering is
> concerned, but the thing that's needed to make it really useful is
> to prevent caching of seqscan-read pages in the kernel disk buffers.
> I don't know any portable way to do that :-(

raw disc ? :-)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2003-10-06 06:06:36 Re: count(*) slow on large tables
Previous Message Andrew Sullivan 2003-10-06 02:01:03 Re: reindex/vacuum locking/performance?