[GENERAL] Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!

2011-10-28 Thread Mohamed Hashim
hores system wide = 256000 max ops per semop call = 32 semaphore max value = 32767 -- Messages Limits max queues system wide = 3977 max size of message (bytes) = 65536 default max size of queue (bytes) = 65536 -- Regards Mohamed Hashim.N Mobile:09894587678

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-02-03 Thread Mohamed
x27;t the first dictionary (hunar) return the stopwords recognized and not ar_simple? / Moe On Sat, Jan 10, 2009 at 11:14 AM, Andrew wrote: > Mohamed wrote: > > Thank you for you detailed answer. I have learned alot more about this > stuff now :) > > Your welc

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Mohamed
Little harsh, are we? I have read the WHOLE documentation, it's a bit long so confusion might arise + I am not familiar with postgre AT ALL so the confusion grows. Perhaps I am an idiot and you don't like helping idiots or perhaps it's something else? Which one is it? If you don't want to help me,

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Mohamed
On Mon, Feb 2, 2009 at 4:34 PM, Oleg Bartunov wrote: > On Mon, 2 Feb 2009, Oleg Bartunov wrote: > > On Mon, 2 Feb 2009, Mohamed wrote: >> >> Hehe, ok.. >>> I don't know either but I took some lines from Al-Jazeera : >>> http://aljazeera.net/port

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Mohamed
nothing... :( Is there a way of making sure that words not recognized also gets indexed/searched for ? (Not that I think this is the problem) / Moe On Mon, Feb 2, 2009 at 3:50 PM, Oleg Bartunov wrote: > Mohamed, > > comment line in ar.affix > #FLAG long > and creation of i

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Mohamed
Little to close, don't you think ? It might be that the arabic hunspell (ayaspell) affix file is damaged on some lines and I got the fixed one from Andrew. Just wanted to let you know. / Moe On Mon, Feb 2, 2009 at 3:25 PM, Mohamed wrote: > Ok, thank you Oleg. > I have another

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Mohamed
this error : (again the affix file) ERROR: wrong affix file format for flag CONTEXT: line 560 of configuration file "C:/Program Files/PostgreSQL/8.3/share/tsearch_data/arabic_utf8_alias.affix": "PFX 1013 Y 6 " / Moe On Mon, Feb 2, 2009 at 2:41 PM, Oleg Bartunov wrote: >

Re: [GENERAL] Fulltext search configuration

2009-02-02 Thread Mohamed
affix file format for flag CONTEXT: line 42 of configuration file "C:/Program Files/PostgreSQL/8.3/share/tsearch_data/hunarabic.affix": "PFX Aa Y 40 / Moe On Mon, Feb 2, 2009 at 12:13 PM, Daniel Chiaramello < daniel.chiarame...@golog.net> wrote: > Hi Mohamed. > > I

[GENERAL] Fulltext search configuration

2009-02-02 Thread Mohamed
I have ran into some problems here. I am trying to implement arabic fulltext search on three columns. To create a dictionary I have a hunspell dictionary and and arabic stop file. CREATE TEXT SEARCH DICTIONARY hunspell_dic ( TEMPLATE = ispell, DictFile = hunarabic, AffFile = hunarabic

Re: [GENERAL] Indices types, what to use. Btree, Hash, Gin or Gist

2009-02-01 Thread Mohamed
us_of_ad_index' // Always in the query, guess could be included in all indexes as partial Thats only the index fields of this relation. Things that are searched for. I will create a Gin index on description also but thats for the fulltext that is coming together but is a bit of a

Re: [GENERAL] Indices types, what to use. Btree, Hash, Gin or Gist

2009-02-01 Thread Mohamed
My Gmail(bloody gmail!) has been auto-replying to the last messager (Scott) so I think we have been having a private discussion on this topic. Here is an update on our discussion. ME : When it comes to the boolean, the content is about 70-30%. I find it strange though that an index on a 50-50% isn

[GENERAL] Indices types, what to use. Btree, Hash, Gin or Gist

2009-01-31 Thread Mohamed
Hi, I have several fields that use to match with my queries. I am curious to what index types is best for what. Here is some examples that will help you understand. Say I have a 1000 000 rows. Speed is of the essence here, insertions and updates happens relatively less frequent than search. I wa

[GENERAL] Running queries to fetch a count of hits in DB on several things

2009-01-16 Thread Mohamed
Hi, this is basically what I would like to improve : 1) A user searches for a product on category and location. a) The query is run and the result (limit 30) are returned and shown. b) The same query is ran again but now I return the count on how many matches there was totally. (This has to be pos

[GENERAL] Returning number of matches on a query when using limit

2009-01-13 Thread Mohamed
Hi. How would I return the number of matches found by a query, but when I only want to return 30 of them ? In MySQL there is a way of calling SQL_CALC_FOUND_ROWS to do this? Is there something similiar that can be done in PostgreSQL ? Do I have to rerun my query? Thanks / Moe

[GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-09 Thread Mohamed
s and there are > doubtless more knowledgeable people in this forum who will be able to > correct anything I say that may be misleading or incorrect. > > Cheers, > > Andy > > Mohamed wrote: > > no one ? > > / Moe > > > On Thu, Jan 8, 2009 at 11:46 AM, Mo

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-09 Thread Mohamed
there are > doubtless more knowledgeable people in this forum who will be able to > correct anything I say that may be misleading or incorrect. > > Cheers, > > Andy > > Mohamed wrote: > > no one ? > > / Moe > > > On Thu, Jan 8, 2009 at 11:46 AM, Mohame

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-08 Thread Mohamed
no one ? / Moe On Thu, Jan 8, 2009 at 11:46 AM, Mohamed wrote: > Ok, thank you all for your help. It has been very valuable. I am starting > to get the hang of it and almost read the whole chapter 12 + extras but I > still need a little bit of guidance. > > I have now these fil

Re: [GENERAL] to_tsquery, plainto_... avoiding bad input, injections. Is there a builtin function for this ? Escaping?

2009-01-08 Thread Mohamed
into that. / Moe On Thu, Jan 8, 2009 at 5:20 PM, Christopher Swingley wrote: > Greetings! > > > Wed, Jan 7, 2009 at 8:07 PM, Mohamed > > > Hi, I am wondering whether or not there exists any built in > > > function for making sure a query/textinput is not harmful

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-08 Thread Mohamed
Ok, thank you all for your help. It has been very valuable. I am starting to get the hang of it and almost read the whole chapter 12 + extras but I still need a little bit of guidance. I have now these files : - A arabic Hunspell rar file (OpenOffice version) wich includes : - ar.dic

Re: [GENERAL] to_tsquery, plainto_... avoiding bad input, injections. Is there a builtin function for this ? Escaping?

2009-01-08 Thread Mohamed
. any one? On Wed, Jan 7, 2009 at 8:07 PM, Mohamed wrote: > Hi, I am wondering whether or not there exists any built in function for > making sure a query/textinput is not harmful or one that escapes them. If > not, what kind of things should I watch out for ? > As of now, I g

[GENERAL] to_tsquery, plainto_... avoiding bad input, injections. Is there a builtin function for this ? Escaping?

2009-01-07 Thread Mohamed
Hi, I am wondering whether or not there exists any built in function for making sure a query/textinput is not harmful or one that escapes them. If not, what kind of things should I watch out for ? As of now, I get errors on the quote ( ' ) if it is entered in an input and in to_tsquery also on spac

[GENERAL] The length of a tsvector (lexemes + positions) must be less than 1 megabyte

2009-01-07 Thread Mohamed
http://www.postgresql.org/docs/8.3/interactive/textsearch-limitations.html The length of a tsvector (lexemes + positions) must be less than 1 megabyte > What does this mean ? Is that per column and row or for the whole index ?

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-05 Thread Mohamed
There has been an error made and messages I have written didn't not end up here so I will do a repost on couple ... :) --- Thank you Oleg. I am reading that g

[GENERAL] Mailing list ?

2009-01-05 Thread Mohamed
Mailing list ?

[GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-05 Thread Mohamed
Hi! I have just made the switch from MySql to PostgreSql to be able to take advantage of TSearch2 and I just arrived to the mailing list :) I am creating a website in two languages (english, arabic) and would like to have dictionaries for both for my search. I noticed that arabic wasn't in as defau

Re: [GENERAL] general features

2007-06-03 Thread Badawy, Mohamed
Thanks for all of the replies,,, What I mean by clustering is to put the database on many machines. Best Regards,,, Mohamed Badawy THIS EMAIL AND ANY ATTACHED FILES ARE CONFIDENTIAL. If you are not the intended recipient you are notified that any disclosure, reproduction

[GENERAL] general features

2007-06-03 Thread Badawy, Mohamed
peed. Best Regards,,, Mohamed Badawy THIS EMAIL AND ANY ATTACHED FILES ARE CONFIDENTIAL. If you are not the intended recipient you are notified that any disclosure, reproduction,copying, distribution, or action taken in reliance on the contents of this information is strictly prohib