Re: disabling OIDs?

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: disabling OIDs?
Date: 2004-12-13 04:25:53
Message-ID: 7c1574a904121220253ae4a5b2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 12 Dec 2004 22:16:27 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Lonni J Friedman <netllama(at)gmail(dot)com> writes:
> > The spam filtering package I use (dspam) had a section in their
> > release notes recently which stated that disabling OIDs greatly
> > increased speeds, and so they suggested that people do that on their
> > tables.
>
> "greatly increased"? I doubt it.
>
> Last I heard, dspam was not noted for any large amount of cluefulness
> WRT postgres. It was only recently that we managed to talk them out of
> their most egregious bits of mysql-centricity. Going to them for
> postgres tuning tips is about like coming to me for mysql tuning ...
>

OK, thanks. So is there any real benefit in doing this in a generic
(non-dspam) sense, or is it just a hack that wouldn't be noticable?
Any risks or potential problems down the line?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-12-13 04:33:58 Re: using inheritance in production application.
Previous Message Tom Lane 2004-12-13 03:16:27 Re: disabling OIDs?