Re: Syscaches should store negative entries, too

From: Hannu Krosing <hannu(at)krosing(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Syscaches should store negative entries, too
Date: 2002-01-30 18:40:17
Message-ID: 1012416017.1923.3.camel@rh72.home.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 2002-01-31 at 00:00, Tom Lane wrote:
>
> To make negative cache entries work correctly, we'd have to issue
> cross-backend SI messages for inserts into the system catalogs, not
> only for updates and deletes. This would mean more SI traffic than
> there is now. I think it'd still be a win, but the case for negative
> cache entries isn't quite as airtight as I thought. There could be
> scenarios where the extra SI traffic outweighs the savings from avoiding
> failing catalog searches.
>
> Comments anyone?

The standard one - if not sure, make it an option ;)

------------
Hannu

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew T. O'Connor 2002-01-30 18:42:14 Re: [ADMIN] postgresql under Windows is slow
Previous Message Tom Lane 2002-01-30 17:58:04 Re: postgresql under Windows is slow