I am afraid I over-simplyfied my use-case. Sorry.
In fact, I am not using a character sequence, but a custom COMPOSITE TYPE;
part of which is a hstore:
CREATE TYPE SSTORE AS (scope TEXT, kvp hstore);
I created some functions and operators around it -- sort-of costly
operations for comparing SSTOR
Could you index the reverse of the string so the unique part appears first?
On May 14, 2011, at 11:20, InterRob wrote:
> Dear list,
>
> I would be pleased if you could share some thoughts with me on the following:
> say I wish to maintain a table with all distinct character sequences
> (varia
On Sun, 15 May 2011 00:05:13 +0930, Daron Ryan wrote about [GENERAL]
Duplicated Fields:
> I am designing a database that will include at lot of duplicated
> data.
>Does Postgres perform many optimisations to eliminate duplications of
>fields or should I create additional tables to reference mys
Dear list,
I would be pleased if you could share some thoughts with me on the
following: say I wish to maintain a table with all distinct character
sequences (variable length) showing series with strong similarities.
Example:
"abbbabacccdef"
"abbbabaccdcdf"
"abbbabaccdcgf"
...
"qwtrhdffdd"
...
"qw
I am designing a database that will include at lot of duplicated data.
Does Postgres perform many optimisations to eliminate duplications of
fields or should I create additional tables to reference myself?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
On Fri, May 13, 2011 at 09:39:58PM +0530, Nick Raj wrote:
> Hi,
> I am able to debug postgres by --enable-debug but breakpoint in cube is not
> working. Can you more elaborate on your second point?
> Even i also tried to change makefile of contrib/cube by -g(debug) but it
> gives error.
> Any idea
