[HACKERS] Partitioned tables constraint_exclusion

I'm not sure if this is a bug, missing feature, misunderstanding on my part? I checked the TODO list and couldn't find anything on it. I currently have a 750 million row table, indexes are > 10 GB, so trying to partition it. The basic - constraint_exclusion + exact match = OK constraint_exclusi

Re: [HACKERS] Partitioned tables constraint_exclusion

Simon Riggs wrote: > On Mon, 2007-03-26 at 09:38 -0700, Weslee Bilodeau wrote: > >> mytest=# explain select count(*) from master where var_ts > ( >> '2007-03-26 16:03:27.370627+00'::timestamptz - '1 month'::interval >> )::timestamptz ; > &g

Re: [HACKERS] Partitioned tables constraint_exclusion

Weslee Bilodeau wrote: > Mainly its because the value comes from a reporting system that has > minimal brains, it passes values it gets from the user directly into a > query. > > IE, they enter '1 month', which I use to populate the interval value, > "ts >

Re: [HACKERS] Partitioned tables constraint_exclusion

et it to be smart enough to not use the tables outside its range. With the tables growing 2+ million rows a day, approaching 1 billion rows, its helps performance a lot. This works at least until the ongoing discussion of partitioned tables hopefully improves things in this area. > On Mar 26, 200

Re: [HACKERS] Getting the type Oid in a CREATE TYPE output function

Marko Kreen wrote: > On 10/12/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> Weslee Bilodeau <[EMAIL PROTECTED]> writes: >> > It works perfectly so long as I used the same key for all my custom >> > types. When I want a different key for each type though (so fo

Re: [HACKERS] Getting the type Oid in a CREATE TYPE output function

Marko Kreen wrote: > On 10/16/06, Weslee Bilodeau <[EMAIL PROTECTED]> wrote: >> Marko Kreen wrote: >> > The PGP functions happen to do it already - pgp_key_id(). >> >> Actually, Tom helped me realize I made a mistake, which I'm following >> his sugge

Re: [HACKERS] Getting the type Oid in a CREATE TYPE output function

Jim C. Nasby wrote: > On Tue, Oct 17, 2006 at 04:34:35PM +0300, Marko Kreen wrote: >>> I'm not sure if anyone else needs something like it, but it allows us to >>> transparently encrypt data directly in the tables. Minimum application >>> changes ('select enc_key' at connection) - the main requirem

[HACKERS] Performance/Security question on caching function OIDs for a connection

I'm working on my custom encryption types (as outlined in another thread) and was curious of one potential performance hit. On the input and output functions for the new type, I lookup the encrypt/decrypt functions using - FuncnameGetCandidates( list_make1( makeString( "decrypt" ) ) Runn

Re: [HACKERS] Acclerating INSERT/UPDATE using UPS

Christopher Browne wrote: > [EMAIL PROTECTED] (Hideyuki Kawashima) wrote: >> Joshua, >> >> I appreciate your quick & informative reply. And, I also really >> appreciate your kind comments. Since I have joined this ML 3 hours >> ago, I tried to be polite and slightly nervous. But I was relieved >> b

[HACKERS] Getting the type Oid in a CREATE TYPE output function ..

I'm trying to create a few new types, and based on the type in/out functions will operate a bit differently. For the input function finding the type Oid is easy - Oid our_type_oid = PG_GETARG_OID(1); For output though I'm having difficulty finding out the type Oid. I've tried using getBaseTyp

Re: [HACKERS] Getting the type Oid in a CREATE TYPE output function

Tom Lane wrote: > Weslee Bilodeau <[EMAIL PROTECTED]> writes: >> I'm trying to create a few new types, and based on the type in/out >> functions will operate a bit differently. >> For the input function finding the type Oid is easy - >> Oid our_type_oid =