Re: [GENERAL] 7.4Beta

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Childs <Blue(dot)Dragon(at)blueyonder(dot)co(dot)uk>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] 7.4Beta
Date: 2003-08-15 06:05:17
Message-ID: Pine.LNX.4.21.0308151601380.27005-100000@linuxworld.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, 14 Aug 2003, Stephan Szabo wrote:

> That really needs to be rewritten to do a single check over the table
> rather than running the constraint for every row. I keep meaning to get
> around to it and never actually do. :( I'm not sure that in practice
> you'll get a better plan at restore time depending on what the default
> statistics give you.

Perhaps it would be easier to allow SKIP VALIDATION (or something) with
ALTER TABLE ADD .... which can set FkConstraint->skip_validation. If we're
just handling pg_dump output, then presumably the data is already
validated. On the other handle, it might encourage users to bypass FKs
when they feel like it...

Thanks,

Gavin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-08-15 06:12:01 Re: [GENERAL] 7.4Beta
Previous Message Christopher Kings-Lynne 2003-08-15 05:46:25 Re: [GENERAL] 7.4Beta

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2003-08-15 06:12:01 Re: [GENERAL] 7.4Beta
Previous Message Christopher Kings-Lynne 2003-08-15 05:46:25 Re: [GENERAL] 7.4Beta