optimizations could be done that pl/pgsql can't
do.
--Rainer
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Vladimir
Sitnikov
Sent: Saturday, September 06, 2008 12:11 AM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] indexing for distinct search in timestamp
You might get great improvement for '%' cases using index on
channel_name(,
start_time) and a little bit of pl/pgsql
Basically, you need to implement the following algorithm:
1) curr_ = ( select min() from ad_log )
2) record_exists = ( select 1 from ad_log where =cur_ and
_all_other_conditions
ED] On Behalf Of Rainer Mager
Sent: 28 August 2008 09:06
To: pgsql-performance@postgresql.org
Subject: [PERFORM] indexing for distinct search in timestamp based table
I'm looking for some help in speeding up searches. My table is pretty simple
(see below), but somewhat large, and continu
ge-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Rainer Mager
> Sent: 28 August 2008 09:06
> To: pgsql-performance@postgresql.org
> Subject: [PERFORM] indexing for distinct search in timestamp based table
>
> I'm looking for some help in speeding up
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rainer Mager
Sent: 28 August 2008 09:06
To: pgsql-performance@postgresql.org
Subject: [PERFORM] indexing for distinct search in timestamp based table
I'm looking for some help in speeding up searche
Rainer Mager wrote:
I'm looking for some help in speeding up searches. My table is pretty simple
(see below), but somewhat large, and continuously growing. Currently it has
about 50 million rows.
Regarding your use of LIKE:
(1)If you are able to specify the beginning character(s) of the
st
I'm looking for some help in speeding up searches. My table is pretty simple
(see below), but somewhat large, and continuously growing. Currently it has
about 50 million rows.
The table is (I know I have excessive indexes, I'm trying to get the
appropriate ones and drop the extras):
