Re: [GENERAL] website doc search is extremely SLOW

On Wed, 31 Dec 2003, Dave Cramer wrote: > I can modify mine to be client server if you want? > > It is a java app, so we need to be able to run jdk1.3 at least? jdk1.4 is available on the VMs ... does your spider? for instance, you mention that you have the docs indexed right now, but we are cur

Re: [GENERAL] website doc search is extremely SLOW

Hello, Why are we not using Tsearch2? Besides the obvious of getting everything into the database? Sincerely, Joshua D. Drake On Tue, 2003-12-30 at 21:24, Marc G. Fournier wrote: > On Wed, 31 Dec 2003, Dave Cramer wrote: > > > Why are their multiple servers hitting the same db > > > > what

Re: [GENERAL] website doc search is extremely SLOW

I can modify mine to be client server if you want? It is a java app, so we need to be able to run jdk1.3 at least? Dave On Wed, 2003-12-31 at 00:04, Marc G. Fournier wrote: > does anyone know anything better then mnogosearch, that works with > PostgreSQL, for doing indexing? the database serve

Re: [GENERAL] website doc search is extremely SLOW

Why are their multiple servers hitting the same db what servers are searching through the db? Dave On Wed, 2003-12-31 at 00:04, Marc G. Fournier wrote: > does anyone know anything better then mnogosearch, that works with > PostgreSQL, for doing indexing? the database server is a Dual Xeon 2.4G,

Re: [GENERAL] website doc search is extremely SLOW

On Wed, 31 Dec 2003, Dave Cramer wrote: > Why are their multiple servers hitting the same db > > what servers are searching through the db? www.postgresql.org and archives.postgresql.org both hit the same DB ... the point is more that whatever alternative that someone can suggest, it has to be ab

Re: [GENERAL] Is my MySQL Gaining ?

On Tue, 30 Dec 2003, Joshua D. Drake wrote: > > > > Have you undertaken the MySQL certifications? If not, how can you say > > that they are not worthwhile? > > > > I think what a lot of people forget is that certifications are meant > to be a baseline. They are meant to allow an employer to s

Re: [GENERAL] website doc search is extremely SLOW

does anyone know anything better then mnogosearch, that works with PostgreSQL, for doing indexing? the database server is a Dual Xeon 2.4G, 4G of RAM, and a load avg right now of a lowly 1.5 ... the file system is 3x72G drive in a RAID5 configuration, and the database server is 7.4 ... the mnogos

Re: [GENERAL] website doc search is extremely SLOW

search for create index took 59 seconds ? I've got a fairly (< 1 second for the same search) fast search engine on the docs at http://postgresintl.com/search?query=create index if that link doesn't work, try postgres.fastcrypt.com/search?query=create index for now you will have to type it, I'm

Re: [GENERAL] website doc search is extremely SLOW

Marc G. Fournier wrote: On Mon, 29 Dec 2003, D. Dante Lorenso wrote: Trying to use the 'search' in the docs section of PostgreSQL.org is extremely SLOW. Considering this is a website for a database and databases are supposed to be good for indexing content, I'd expect a much faster performance.

Re: [GENERAL] website doc search is extremely SLOW

When you got to docs and then click static, it has the ability to search. It is slow Sincerely, Joshua D. Drake On Tue, 2003-12-30 at 19:05, Marc G. Fournier wrote: > On Mon, 29 Dec 2003, D. Dante Lorenso wrote: > > > Trying to use the 'search' in the docs section of PostgreSQL.o

Re: [GENERAL] website doc search is extremely SLOW

On Tue, 30 Dec 2003, Marc G. Fournier wrote: > On Mon, 29 Dec 2003, D. Dante Lorenso wrote: > > > Trying to use the 'search' in the docs section of PostgreSQL.org > > is extremely SLOW. Considering this is a website for a database > > and databases are supposed to be good for indexing content, I'

Re: [GENERAL] Is my MySQL Gaining ?

> Have you undertaken the MySQL certifications? If not, how can you say > that they are not worthwhile? > I think what a lot of people forget is that certifications are meant to be a baseline. They are meant to allow an employer to say, "Hey this person at least has some idea of what they are

Re: [GENERAL] website doc search is extremely SLOW

On Mon, 29 Dec 2003, D. Dante Lorenso wrote: > Trying to use the 'search' in the docs section of PostgreSQL.org > is extremely SLOW. Considering this is a website for a database > and databases are supposed to be good for indexing content, I'd > expect a much faster performance. What is the full

Re: [GENERAL] Is my MySQL Gaining ?

On Tue, 30 Dec 2003, Nigel J. Andrews wrote: > Date: Tue, 30 Dec 2003 11:12:05 + (GMT) > From: Nigel J. Andrews <[EMAIL PROTECTED]> > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] Is my MySQL Gaining ? > > > Just to poke fun at MySQl: > > On Tue, 30 Dec 2003, Bret Bus

Re: [GENERAL] PostgreSQL Porting Project

Bugzilla is a good example "PostgreSQL support. (Bug 98304 ) http://bugzilla.mozilla.org/show_bug.cgi?id=98304 " They only support mysql, want to support postgres, and are tageting it in the next release, but might need a nudge/support.

Re: [GENERAL] PostgreSQL Porting Project

On Wed, 31 Dec 2003, Greg Sabino Mullane wrote: > > Maybe this is where the advocacy site and community can help the > > most. We could list these utilities that only support MySQL > > and ask for members of the community to contact the developers > > to help them support Postgres. Now, there are

[GENERAL] PostgreSQL Porting Project

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Maybe this is where the advocacy site and community can help the > most. We could list these utilities that only support MySQL > and ask for members of the community to contact the developers > to help them support Postgres. Now, there are a lot

Re: [GENERAL] 7.4.1 RPMS

On Tuesday 30 December 2003 04:44 pm, Ericson Smith wrote: > Are there any 7.4.1 RPM's yet? I looked at the mirrors but no go. After I get back from vacation (which I am on right now). -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC

Re: [GENERAL] Where can I find the "Contrib" page on the PostgreSQL site?

It comes with the distribution (assuming by distribution you mean the main tarball, some "distributions" package it seperatly i think). You can view the contents on the web via webcvs: http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/ Robert Treat On Tuesday 30 December 2003 11

Re: [GENERAL] Is my MySQL Gaining ?

On Tuesday 30 December 2003 06:50, B. van Ouwerkerk wrote: > I don't know that particular book myself but the book MySQL written by Paul > DuBois took me much less then 21 days :-) I have yet to find a simular book > about PostgreSQL.. > uh... I would have to think that Korry Douglas's book titled

Re: [GENERAL] 'like' refuses to use an index???

"Keith C. Perry" <[EMAIL PROTECTED]> writes: > Show the pg_controldata program work in 7.4? If not, shouldn't it be removed > from the docs in favor of the show method of finding out the locale. It still works, but you're right, the docs should suggest the easier way... fixed ...

Re: [GENERAL] 'like' refuses to use an index???

Quoting Tom Lane <[EMAIL PROTECTED]>: > Mike Nolan <[EMAIL PROTECTED]> writes: > > However, I think RH always sets the LANG environmental variable, so > > that's going to be picked up by initdb, which means that the C locale > > will NOT be used unless specifically asked for. Other OS packages

Re: [GENERAL] 'like' refuses to use an index???

> Mike Nolan <[EMAIL PROTECTED]> writes: > > However, I think RH always sets the LANG environmental variable, so > > that's going to be picked up by initdb, which means that the C locale > > will NOT be used unless specifically asked for. Other OS packages may > > also force the choice of a defa

Re: [GENERAL] 'like' refuses to use an index???

Quoting Mike Nolan <[EMAIL PROTECTED]>: > > You didn't initdb in C locale ... > > The documentation section on localization could use some enhancements > and maybe some more examples. > > The 'c' locale isn't very well defined in the docs, except to say that it > is 'special' and is the defa

Re: [GENERAL] 'like' refuses to use an index???

Keith C. Perry wrote: Ahhh, so it is!! So let me ask you this. In order to build an index that would be able to handle something like "lastname like '%erry'", would you need that full text search patch in contrib (tsearch?) or could you do it with an index on a function? I suppose, if this is

Re: [GENERAL] 'like' refuses to use an index???

Quoting Dima Tkach <[EMAIL PROTECTED]>: > Nah... > This is a different story - for teh index to be useful, the *beginning* > of your search string must be known. > So "like '00423%" and "~ '^00423'" should both work, but "like '%423'" > and "~ '00423'" both won't - it's like searching a telephon

Re: [GENERAL] 'like' refuses to use an index???

Mike Nolan <[EMAIL PROTECTED]> writes: > However, I think RH always sets the LANG environmental variable, so > that's going to be picked up by initdb, which means that the C locale > will NOT be used unless specifically asked for. Other OS packages may > also force the choice of a default LANG v

Re: [GENERAL] Problem with ecpg

On Tue, Dec 30, 2003 at 11:39:29AM -0300, Carmen Gloria Sepulveda Dedes wrote: > When I execute an ecpg program (in an insert on a table), I get this What do you mean with this? The ecpg program does an insert? Or how do you use a program in an insert? Also it would surely help if you could provi

Re: [GENERAL] Is my MySQL Gaining ?

On Mon, Dec 29, 2003 at 23:41:22 -, John Sidney-Woollett <[EMAIL PROTECTED]> wrote: > Actually, sometimes these questions will be postgres specific, and this is > where the docs are too light. > > An example is an update statement using values from a correlated subquery. > Here's example cod

Re: [pgsql-advocacy] [GENERAL] Is my MySQL Gaining ?

--- Bret Busby <[EMAIL PROTECTED]> wrote: > On Mon, 29 Dec 2003, Jeff Eckermann wrote: > > > > > Isn't this what books are supposed to be for? i.e. > to > > fill in the gaps or provide the coverage, tips, > howtos > > etc. etc. that no-one really expects formal > > documentation to cover. There

[GENERAL] Problem with ecpg

Hello! I'm working with Postgres 7.4 on Tru64. When I execute an ecpg program (in an insert on a table), I get this error: EYE000: message type 0x5a arrived from server while idle How can I resolve this? Thanks. CG ---(end of broadcast)--- TIP

Re: [GENERAL] Is my MySQL Gaining ?

"Bret Busby" <[EMAIL PROTECTED]> Wrote: > On Sat, 27 Dec 2003, Chris Travers wrote: > > In short, I do not see MySQL as any sort of threat to PostgreSQL, near or > > long-term. PostgreSQL will continue when MySQL no longer exists. Firebird > > is a more serious competitor long-term, though I foun

Re: [GENERAL] Is my MySQL Gaining ?

At 20:00 30-12-2003 +0700, Chris Travers wrote: Personally I think that the docs are great (especially so with 7.4). Of course they are aimed at experienced admins, so it is easier to find things if you have a basic understanding of the RDBMS to start with. Of course things can always be improved

Re: [GENERAL] Is my MySQL Gaining ?

From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>: > I still don't find it. I know you can do a varchar(255) but what is the > maximum PG will allow? Is there a maximum? > In short, how much can I put into the field before it breaks. It is not in the manual because in this case it probably doesn't matt

Re: [pgsql-advocacy] [GENERAL] Is my MySQL Gaining ?

On Tue, Dec 30, 2003 at 09:23:21AM -0300, Martin Marques wrote: > El Mar 30 Dic 2003 02:49, Bret Busby escribió: > > And, if a person did not already have it installed and set up, would the > > person then have not been required to find elsewhere, how to do those? > > The question then is: "How d

Re: [GENERAL] Is my MySQL Gaining ?

Personally I think that the docs are great (especially so with 7.4). Of course they are aimed at experienced admins, so it is easier to find things if you have a basic understanding of the RDBMS to start with. Of course things can always be improved, but I am opposed to adding cruft to the core d

Why views, stored proc's etc. Re: [GENERAL] Is my MySQL Gaining ?

I have previously made my viewpoint known regarding the need for training docs separate from the main docs.   Regarding views:  Think single point of maintenance.  Here are a few examples:   1:  You have a complex query which is run with different restrictions in the WHERE clause.  You can se

Re: [GENERAL] Is my MySQL Gaining ?

If you have no control over the running postmasters, then where the files are stored gives you no advantage at all either for backup or security. Backing up physical files while the postmaster running is asking for it; this is explained every three days or so on the lists. (that should be part of

Re: [GENERAL] Is my MySQL Gaining ?

El Mar 30 Dic 2003 04:07, B. van Ouwerkerk escribió: > >Does it say that there is a limit? Yes surely there is one, which most > > likely will depends on the Processor and OS you are running (64 bit or 32 > > bit), but anyway, such log varchars wouldn't be that recommended, and > > maybe the TEXT d

Re: [pgsql-advocacy] [GENERAL] Is my MySQL Gaining ?

El Mar 30 Dic 2003 02:49, Bret Busby escribió: > On Mon, 29 Dec 2003, Martin Marques wrote: > > > > At this point, the book makes the following assumptions: > > > > * You have installed POSTGRESQL. > > * You have a running POSTGRESQL server. > > * You are configured as a POSTGRESQL user

Re: [GENERAL] Is my MySQL Gaining ?

a contractor, or an employee of a contractor, and, as I previosuly mentioned, the scenario where an ISP, by hosting a web site with a database backend, has a database in the same holding area as is held all the databases of all of the ISP's clients who similarly have web sites with database backen

Re: [GENERAL] Is my MySQL Gaining ?

B. van Ouwerkerk wrote: IMO there's no valid reason for MySQL bashing. I'm not going to defend either one because that kind of discussion leads to nowhere. How about pure entertainment? Or maybe because we don't have anything better to do on a Friday night because the one girl this year who ac

[GENERAL] ERROR: cache lookup for type 0 of ... pg.dropped.14........ failed

Hi All, I run into an error message. I have the following function where t_stockchanges is one of my tables. create or replace function get_last_open(int, int) returns setof t_stockchanges AS ' declare ProductID alias for $1; StockID alias for $2;

Re: [GENERAL] Is my MySQL Gaining ?

> secrtifications, and, the "Teach Yourself MySQL in 21 Days" book, and > that series of books has set exercises, etc, to aid the learning, > ... I thought MySQL was supposed to be easy to install, admin and use, how come it takes 21 days to learn it and needs formalised training courses? Perhaps

Re: [GENERAL] what about uniqueness of inherited primary keys

Hi all; The real problem with using the trigger approach is as follows: Normally the unique constraint is handled by an index (most efficient way), but doing so using a trigger is more likely to lose this benefit and give you some performance problems. IIRC, the problems with inherited keys are,

Re: [GENERAL] Is my MySQL Gaining ?

Just to poke fun at MySQl: On Tue, 30 Dec 2003, Bret Busby wrote: > ... > It is alright for people in this thread, to say "But they are MySQL, and > MySQL is not as powerful as PostgreSQL, so who cares what advantages > there are in MySQL", but MySQL appears to be more mature, as it has > thin

Re: [GENERAL] Is my MySQL Gaining ?

On Tue, 30 Dec 2003, Tom Lane wrote: > Date: Tue, 30 Dec 2003 02:07:23 -0500 > From: Tom Lane <[EMAIL PROTECTED]> > To: Bret Busby <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: Re: [GENERAL] Is my MySQL Gaining ? > > Bret Busby <[EMAIL PROTECTED]> writes: > > Does Pos

Re: [GENERAL] website doc search is extremely SLOW

On Mon, 29 Dec 2003, D. Dante Lorenso wrote: > Trying to use the 'search' in the docs section of PostgreSQL.org > is extremely SLOW. Considering this is a website for a database > and databases are supposed to be good for indexing content, I'd > expect a much faster performance. > > I submitted m

Re: [pgsql-advocacy] [GENERAL] Is my MySQL Gaining ?

On Tuesday 30 December 2003 02:28, Joshua D. Drake wrote: > >How would this differ from the existing Tutorial? > > Well, for one it would tell the user how to start postgresql ;) Like this? http://wiki.ael.be/index.php/PostgresQL101 It is linked from front page of techdocs.postgresql.org under n

Re: [GENERAL] Is my MySQL Gaining ?

However, a language like PHP is very different from an enterprise DB, so our tutorial really doesn't help a newbie to databases understand how to USE PostgreSQL. In order to do this, it would need to cover a bunch of other topics as well, such as normalization, etc. The result would be something

Re: [GENERAL] Is my MySQL Gaining ?

Does it say that there is a limit? Yes surely there is one, which most likely will depends on the Processor and OS you are running (64 bit or 32 bit), but anyway, such log varchars wouldn't be that recommended, and maybe the TEXT data type would be more suitable. If you are used to MySQL you're us

Re: [GENERAL] Is my MySQL Gaining ?

Bret Busby <[EMAIL PROTECTED]> writes: > Does PostgreSQL yet allow the user or programmer, to determine where the > database will be stored? You speak as though you think that would be a good idea. In my mind, "where the database is stored" is not a matter for users, nor for programmers, but for