[HACKERS] EXLCUDE constraints and Hash indexes

2016-08-17 Thread Jeff Janes
From: https://www.postgresql.org/docs/9.4/static/sql-createtable.html "The access method must support amgettuple (see Chapter 55); at present this means GIN cannot be used. Although it's allowed, there is little point in using B-tree or hash indexes with an exclusion constraint, because this does

Re: [HACKERS] Declarative partitioning - another take

2016-08-17 Thread Ashutosh Bapat
On Wed, Aug 17, 2016 at 11:51 AM, Amit Langote < langote_amit...@lab.ntt.co.jp> wrote: > On 2016/08/17 14:33, Ashutosh Bapat wrote: > >> +relid_is_partition(Oid relid) > >> +{ > >> + return SearchSysCacheExists1(PARTRELID, > ObjectIdGetDatum(relid)); > >> +} > >> > >> This is used in a lot

Re: [HACKERS] Declarative partitioning - another take

2016-08-17 Thread Amit Langote
On 2016/08/17 14:33, Ashutosh Bapat wrote: >> +relid_is_partition(Oid relid) >> +{ >> + return SearchSysCacheExists1(PARTRELID, ObjectIdGetDatum(relid)); >> +} >> >> This is used in a lot of places, and the overhead of checking it in >> all of those places is not necessarily nil. Syscache

Re: [HACKERS] Detecting skipped data from logical slots (data silently skipped)

2016-08-17 Thread Craig Ringer
On 17 August 2016 at 05:18, Andres Freund wrote: > On 2016-08-08 10:59:20 +0800, Craig Ringer wrote: > > Right. Though if we flush lazily I'm surprised the effect is that big, > > you're the one who did the work and knows the significance of it. > > It will be. Either you're

<    1   2