On 11/1/06, Teodor Sigaev <[EMAIL PROTECTED]> wrote:
[snip]
Brain storm method:
Develop a dictionary which returns all substring for lexeme, for example for
word foobar it will be 'foobar fooba foob foo fo oobar ooba oob oo obar oba ob
bar ba ar'. And make GIN functional index over your column (
I tried the below script (again, going from 6.3->6.4.2 on RedHat 5.2
Linux).. Now I don't get the out of memory errors but it still chokes up
on the syntax.. The back end spits out things like:
ERROR: type name lookup of char16 failed
ERROR: ChangeAcl: class "accounts" not found
ERROR: Change
On Sun, 30 May 1999, Oliver Elphick wrote:
> Gregory Maxwell wrote:
> >
> >AHH! The pgsql v6.3 backend has begun crashing horribly on me since I've
> >added a few more database backed webpages (with messages like 'backend
> >cache invalidation...&
AHH! The pgsql v6.3 backend has begun crashing horribly on me since I've
added a few more database backed webpages (with messages like 'backend
cache invalidation...').. I figured that upgrading to 6.4.2 would solve my
problems.. But I can't upgrade! Things I've tried:
* Using old pg_dumpall -z
/usr/local/pgsql/data/pg_hba.conf
On Sun, 11 Apr 1999, Vince Vielhaber wrote:
>
> redirected to general
> -
>
>
> We are trying to use psql on RedHat 5.2 to access a database on another
> Redhat 5.2 box runing Postgres (started as user postgres: postmaster
>
> -
On Wed, 17 Feb 1999, Peter T Mount wrote:
[snip]
> If the TIGER/Line data is raster, and each feature (polygon, line,
> circle, etc) doesn't exceed the block size, then postgresql should be able
> to handle it.
[snip]
Vector not raster. Right?
On Wed, 13 Jan 1999, Jackson, DeJuan wrote:
> And remember unless you use full text indexing (which is expensive) you
> won't have indexing on that search (for either the LIKE or regex).
> -DEJ
Actually, if you use case sensitive regex, and anchor the begining (with
^) then it will use btr
On Thu, 17 Dec 1998, Bruce Momjian wrote:
> Quick mailing list support
except they cant tell me why a Dump/Restore from 6.3>6.4 wont work fore
some people. :)
/*Pardon my typing: Just switched to dvorak*/
On Fri, 4 Dec 1998, Taral wrote:
> >hygea=> explain select * from comuni where nome = 'A%';
> >NOTICE: QUERY PLAN:
> >Index Scan using nome_comune_idx on comuni (cost=2.05 size=2 width=84)
> >^
>
> The question was about LIKE, not =. Because LIKE uses regexp-style matching and
> we have no
anything for me.
System is Dual PII running RedHat 5.1+errata and kernel 2.1.125+ac2+other
patches.
I really need working rules, so any help would be warmly accepted. I can
send my dump file if needed.
Thanks,
Gregory Maxwell
10 matches
Mail list logo
