[HACKERS] Re: Re: The new, the improved ... FTS Searching of Mailing List Archives
Bruce Momjian [EMAIL PROTECTED] writes: I hope FTS for postgresql doesn't start looking like Oracle's Context/Intermedia... Proprietary interfaces == lock in == ick. /featurerequest This is what I was hoping... Something to make it automatic. Well, I would love to see full text indexing with some understanding of the language in question as well - I believe this is what Oracles product is about and not just simple regexp matching. I want to be able to do regexps, synonyms, soundex, etc. And I guess there is no standard for specifying these different kind of searches. regards, Gunnar ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] Re: Onject Database Survey ... Help needed ...
The Hermit Hacker [EMAIL PROTECTED] writes: I'm just starting to go through the sections, so right now, none of them have answers yet ... if ppl could help by reading through and providing answers so that I can provide as accurate of information as possible, it should give for a good initial showing for PgSQL on the Object stage ... I honestly don't make sense of some of the survey questions. On the Java Map Generation for instance, I feel the possible are answers is not close to reality at all - and there is not very much pgsql specific work in this process either... I usually have a XML representation of the schema that is transformed by XSL into SQL schema and docs. The same XML schema is then used to create the basic object model for the schema by using straight class to relation mapping. regards, Gunnar ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Re: More on elog and error codes
Thomas Lockhart [EMAIL PROTECTED] writes: So we need some good error numbering scheme. Any ideas? SQL9x specifies some error codes, with no particular numbering scheme other than negative numbers indicate a problem afaicr. Shouldn't we map to those where possible? Good point, but I guess most of the errors produced are pgsql specific. If I remember right Sybase had several different SQL types of error mapped to one of the standard error codes. Also the JDBC API provides methods to look at the database dependent error code and standard error code. I've found both useful when working with Sybase. cheers, Gunnar ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Re: Performance monitor
Denis Perchine [EMAIL PROTECTED] writes: Small question... Will it work in console? Or it will be X only? It will be tck/tk, so I guess X only. That's bad. Cause it will be unuseful for people having databases far away... Like me... :-((( Another point is that it is a little bit strange to have X-Window on machine with database server... At least if it is not for play, but production one... Well, I use X all the time over far distances - it depends on your connection... And you are not running an X server on the database server, only an X client. But I agree that it would be nice to have monitoring architecture that allowed a multitude of clients... regards, Gunnar ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] Re: Performance monitor
Bruce Momjian [EMAIL PROTECTED] writes: My idea is that they can telnet into the server machine and do remote-X with the application. Just set the DISPLAY variable and it should work. Well, actually you would want to tunnel your X session through ssh if security of the database server is of any importance... But this works fine on high bandwidth connections, but X is a real pain if you are sitting with low bandwidth(e.g. cellphone connection when you're in the middle of nowhere on your favorite vacation ;-) regards, Gunnar ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Re: Query precompilation?
Steffen Emil Thorkildsen [EMAIL PROTECTED] writes: me. Are there ways to precompile a sqlquery or do other tricks to get the *fastest* insertion-rate, since the data-queue is growing faster than 200/sec... I don't care about integrity etc! I'm using PostgreSQL 7.0.3, RH 6.2 Linux 2.2.4, and the pq library with gcc. Apart from the COPY mentioned by Tom Lane, you should also fo through the obvious checklist: use -F to disable fsync, drop indexes(if possible), use several connections(could help if you have multiprossessor system)
Re: [HACKERS] Now 376175 lines of code
Bruce Momjian [EMAIL PROTECTED] writes: I just counted lines, not line content. Not sure which is more meaningful. Our comments are as important as the code, sometimes, though they do not add functionality to the application. I am not inclined to inflate numbers, but I am not sure the 59% number is accurate either. Counting the number of lines is only meaningful as a relative measurement of complexity and spent effort - IMHO. And I think lines of code measurements usually ignore blank lines and lines with comments. However, Preprocessor directives is code - and sometimes it would be fair to add some extra lines for the increased complexity caused by cool CPP macros ;-) Regards, Gunnar Gunnar