[GENERAL] Trigram performance penalty on varchar?

Hi, I am indexing a 100 million record table composed of varchar(255) as the field to be indexed. I have always seen that examples of pg_trgm are based on text type fields. Is this by any special reason?. My computer is creating the index since 5 hours ago so I guess there must be something

Re: [GENERAL] Working with huge amount of data. RESULTS!

y problem is that I am not searching for Words in a dictionary fashion, suppose my "data" is random garbage, that it has common consecutive bytes. How could I generate a dictionary from this random garbage to make it easier for indexing? Thanks On Mon, Feb 11, 2008 at 04:37:2

Re: [GENERAL] Working with huge amount of data.

articles. Thanks :) On Feb 11, 2008, at 9:37 AM, Mario Lopez wrote: Hi guys :-), I am working on a personal project in which I am trying to make sense on a huge (at least for me) amount of data. I have approximately 150 million rows of unique words (they are not exactly words it is just for

Re: [GENERAL] Working with huge amount of data.

Hubert, Your two posts look pretty cool :), I would read them tonight and answer you back :) Thanks! On Mon, Feb 11, 2008 at 04:37:24PM +0100, Mario Lopez wrote: SELECT * FROM names WHERE name LIKE ‘keyword%’ Or SELECT * FROM names WHERE name LIKE ‘%keyword%’ check this: http

[GENERAL] Working with huge amount of data.

Hi guys :-), I am working on a personal project in which I am trying to make sense on a huge (at least for me) amount of data. I have approximately 150 million rows of unique words (they are not exactly words it is just for explaining the situation). The table I am inserting this is a quite si

Re: [GENERAL] PostgreSQL XID exceeded crash.

Hi, I forgot to mention that we are using plphp version 1.1 but I guess that in the process of making a pg_restore this issue does not really matter. Thanks Mario. Mario Lopez escribió: Hi, The platform as you have seen is Debian testing branch. I have activated log_statement but again

Re: [GENERAL] PostgreSQL XID exceeded crash.

Hi, The platform as you have seen is Debian testing branch. I have activated log_statement but again nothing clear, the query that makes the system fail has nothing strange on it here is a dump. I do not know how toget a stack trace and the "crash" does not provide a core dump :(. Could you

Re: [GENERAL] PostgreSQL XID exceeded crash.

processes exiting unexpectedly Any more ideas, please?. Thanks for your time Alvaro :). --- Mario. Alvaro Herrera escribió: Hola, Mario Lopez wrote: Hola Alvaro, The process that are being reaped are postgresql child processes, more precisely the process that is attending my queryes

Re: [GENERAL] PostgreSQL XID exceeded crash.

Hola Alvaro, The process that are being reaped are postgresql child processes, more precisely the process that is attending my queryes... Here I have another log that has the %p %i and %x in that order but I see no clear difference. Thanks. Alvaro Herrera escribió: Mario Lopez wrote

Re: [GENERAL] PostgreSQL XID exceeded crash.

s all of it's child processes, which ends in a crash from pg_restore or any application using this table. Thanks. Alvaro Herrera escribió: Mario Lopez wrote: Hi!, I am having an XID issue with PostgreSQL, while doing a pg_restore from a 200MB saved database I get a server crash,

[GENERAL] PostgreSQL XID exceeded crash.

Hi!, I am having an XID issue with PostgreSQL, while doing a pg_restore from a 200MB saved database I get a server crash, searching through the debug messages I have found that PostgreSQL crashes due to a exausted XID resource with a message that looks this way (sorry for the Spanish log) UB