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
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 >
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
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
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
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
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
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
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
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 =
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
11 matches
Mail list logo