[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

Re: [GENERAL] order of row processing affects updates

2004-09-19 Thread Marius Andreiana
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 - Solutii Linux in Romania http://www.galuna.ro

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

2004-08-18 Thread Marius Andreiana
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 production. -- Marius Andreiana Galuna

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

2004-08-06 Thread Marius Andreiana
/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 ---(end of broadcast

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

2004-08-03 Thread Marius Andreiana
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 our list archives? http