[GENERAL] word/phrase extraction & ranking

2012-11-14 Thread Marius Andreiana
Hello, From selected rows in a table, how can one extract and rank words/phrases based on how often they occur? Here's an example: http://developer.yahoo.com/search/content/V1/termExtraction.html INPUT: CREATE TABLE phrases ( idBIGSERIAL, phrase VARCHAR(1)); INSERT INTO phrases (phrase)

Re: [GENERAL] order of row processing affects updates

2004-09-19 Thread Marius Andreiana
. > Basically what we would like to do would be something like doing constraint > validations only at the end of execution of an update query, instead of > after every row update. does it fail even if it's in a BEGIN UPDATE .. COMMIT ? -- Marius Andreiana Galuna - Solu

Re: [GENERAL] [ADMIN] tracking db changes / comparing databases

2004-08-18 Thread Marius Andreiana
mplete and tested push the modifications to the production > session. To do that I'd need to be able to produce: > 1. data-definition changes http://sourceforge.net/projects/zongle > 2. data added/modified to the tables run the scripts to import/change data on both devel and productio

Re: [GENERAL] Data version idea (please discuss)

2004-08-06 Thread Marius Andreiana
tgresql.org/docs/postgres/sql-checkpoint.html http://developer.postgresql.org/docs/postgres/sql-savepoint.html There are some examples in postgresql 7.5 new features announcements over the net. -- Marius Andreiana Galuna - Solutii Linux in Romania http://www.galuna.ro ---(

Re: [GENERAL] [PERFORM] NOT IN query takes forever

2004-08-03 Thread Marius Andreiana
for sort_mem. Thanks for the advice. I increased shmmax to allow shared_buffers to be 128mb and set sort_mem to 24mb. -- Marius Andreiana Galuna - Solutii Linux in Romania http://www.galuna.ro ---(end of broadcast)--- TIP 6: Have you searched