Indexing of text fields

Started by Adam Haberlachabout 27 years ago5 messagesgeneral
Jump to latest
#1Adam Haberlach
haberlaa@ricochet.net

I am going to be working with a database with a lot of rather
large text fields in it. To do some profiling, I have hacked up an
IRC bot to submit messages into a database. I cannot seem to get any
of my queries to use the indexes I create on the msg field--is there
something specific I need to use when I create the index or write
the query?
I'm hoping to migrate from FileMaker, which aparently has
excellent indexing of text fields (but sucks in a lot of other ways).
I need to prove that what I'm doing is worth it.

#2Gilles Darold
darold@neptune.fr
In reply to: Adam Haberlach (#1)
ISP with PostgreSQL

Hi all,

Is anybody know an ISP which provided PostgreSQL access ? I'm developping
a
powerfull solution for Ebusiness using Linux RedHat 5.2 and PostgreSQL
6.4.2. But
I can't find any ISP running PostgreSQL, they all works with MySQL.

Porting to this database or other, is not so difficult because I use
Perl/DBI but I really don't
want to. I want PostgreSQL because I need PostgreSQL as a professional
solution.

Also, I'm a free developper. I do it by myself on my sleep time as most
part of you,
so I need cheapest services :-)))...

Thanks a lot,

Gilles Darold

#3Daryl W. Dunbar
daryl@www.com
In reply to: Gilles Darold (#2)
RE: [GENERAL] ISP with PostgreSQL

Yea. Check out Epoch Internet, http://www.eni.net, 1-888-77-EPOCH,
I think they offer PostgreSQL. You'll probably have to call to find
out, I don't remember anything on the web page.

DwD

Show quoted text

-----Original Message-----
From: owner-pgsql-general@postgreSQL.org
[mailto:owner-pgsql-general@postgreSQL.org]On Behalf Of
Gilles Darold
Sent: Wednesday, February 24, 1999 3:53 AM
To: pgsql-general@postgreSQL.org
Subject: [GENERAL] ISP with PostgreSQL

Hi all,

Is anybody know an ISP which provided PostgreSQL access ?
I'm developping
a
powerfull solution for Ebusiness using Linux RedHat 5.2
and PostgreSQL
6.4.2. But
I can't find any ISP running PostgreSQL, they all works
with MySQL.

Porting to this database or other, is not so difficult
because I use
Perl/DBI but I really don't
want to. I want PostgreSQL because I need PostgreSQL as a
professional
solution.

Also, I'm a free developper. I do it by myself on my
sleep time as most
part of you,
so I need cheapest services :-)))...

Thanks a lot,

Gilles Darold

#4tc lewis
tim@iuinc.com
In reply to: Gilles Darold (#2)
Re: [GENERAL] ISP with PostgreSQL

hostme.com doesn't do dialup access, but does web hosting, and provides a
choice of mysql or postgresql free with any option. they (we, actually
*grin*) work with redhat linux/gnu systems.

check it out if you want: www.hostme.com
no big deal if not. =)

-tcl.
tim@iuinc.com

On Wed, 24 Feb 1999, Gilles Darold wrote:

Show quoted text

Hi all,

Is anybody know an ISP which provided PostgreSQL access ? I'm developping
a
powerfull solution for Ebusiness using Linux RedHat 5.2 and PostgreSQL
6.4.2. But
I can't find any ISP running PostgreSQL, they all works with MySQL.

Porting to this database or other, is not so difficult because I use
Perl/DBI but I really don't
want to. I want PostgreSQL because I need PostgreSQL as a professional
solution.

Also, I'm a free developper. I do it by myself on my sleep time as most
part of you,
so I need cheapest services :-)))...

Thanks a lot,

Gilles Darold

#5The Hermit Hacker
scrappy@hub.org
In reply to: Gilles Darold (#2)
Re: [GENERAL] ISP with PostgreSQL

We offer PostgreSQL services...see http://www.hub.org/prices.html, and
note that all prices are in Canadian Dollars...

On Wed, 24 Feb 1999, Gilles Darold wrote:

Hi all,

Is anybody know an ISP which provided PostgreSQL access ? I'm developping
a
powerfull solution for Ebusiness using Linux RedHat 5.2 and PostgreSQL
6.4.2. But
I can't find any ISP running PostgreSQL, they all works with MySQL.

Porting to this database or other, is not so difficult because I use
Perl/DBI but I really don't
want to. I want PostgreSQL because I need PostgreSQL as a professional
solution.

Also, I'm a free developper. I do it by myself on my sleep time as most
part of you,
so I need cheapest services :-)))...

Thanks a lot,

Gilles Darold

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org