From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Open 7.4 items |
Date: | 2003-10-05 18:40:10 |
Message-ID: | 20031005112452.T74878@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Sun, 5 Oct 2003, Tom Lane wrote:
> Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> writes:
> >> Improve speed of building of constraints during restore
>
> > Did we get consensus on what to do with this,
>
> Not really, it was still up in the air I thought. However, the
> discussion will become moot if we don't have an implementation
> of the faster-checking alternative to look at pretty soon. Do you
> have something nearly ready to show?
It's not cleaned up, but yes. It appears to work for the simple tests I've
done and should fall back if the permissions don't work to do a single
query on both tables.
I wasn't sure what to do about some of the spi error conditions. For many
of them I'm just returning false now so that it will try the other
mechanism in case that might work. I'm not really sure if that's worth it,
or if I should just elog(ERROR) and give up.
Attachment | Content-Type | Size |
---|---|---|
single_check.diff | text/plain | 14.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-10-05 18:57:21 | Re: count(*) slow on large tables |
Previous Message | Tom Lane | 2003-10-05 18:26:48 | Re: PQfnumber and quoted identifiers |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-10-05 18:59:08 | Re: Open 7.4 items |
Previous Message | Tom Lane | 2003-10-05 18:16:10 | Re: fix log_min_duration_statement logic error |