Re: [HACKERS] [PATCHES] Load Distributed Checkpoints, revised patch

2007-06-16 Thread Simon Riggs
On Fri, 2007-06-15 at 13:11 +0200, Michael Paesold wrote: Heikki Linnakangas wrote: Here's an updated WIP version of the LDC patch. I just spreads the writes, that achieves the goal of smoothing the checkpoint I/O spikes. I think sorting the writes etc. is interesting but falls in the

Re: [HACKERS] How does the tsearch configuration get selected?

2007-06-16 Thread Bruce Momjian
Teodor Sigaev wrote: So, added to my plan (http://archives.postgresql.org/pgsql-hackers/2007-06/msg00618.php) n) single encoded files. That will touch snowball, ispell, synonym, thesaurus and simple dictionaries n+1) use encoding names instead of locale's names in configuration FYI, I

Re: [HACKERS] Load Distributed Checkpoints test results

2007-06-16 Thread Josh Berkus
All, Where is the most current version of this patch? I want to test it on TPCE, but there seem to be 4-5 different versions floating around, and the patch tracker hasn't been updated. -- Josh Berkus PostgreSQL @ Sun San Francisco ---(end of

Re: [HACKERS] To all the pgsql developers..Have a look at the operators proposed by me in my researc

2007-06-16 Thread Josh Berkus
Tasneem, For example: For 6, the range defined by NEAR is: 4 – 8 For 2147,483,647, the range defined by NEAR is: 1717,986,917 – 2576,980,377 But yes, for other cases it may not give good results. We can give the option for the user to specify the

[HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-16 Thread Michael Fuhr
A message entitled Having Fun With PostgreSQL was posted to Bugtraq today. I haven't read through the paper yet so I don't know if the author discusses security problems that need attention or if the article is more like a compilation of Stupid PostgreSQL Tricks.

Re: [HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-16 Thread Tom Lane
Michael Fuhr [EMAIL PROTECTED] writes: A message entitled Having Fun With PostgreSQL was posted to Bugtraq today. I haven't read through the paper yet so I don't know if the author discusses security problems that need attention or if the article is more like a compilation of Stupid

Re: [HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-16 Thread Jeremy Drake
On Sat, 16 Jun 2007, Michael Fuhr wrote: A message entitled Having Fun With PostgreSQL was posted to Bugtraq today. I haven't read through the paper yet so I don't know if the author discusses security problems that need attention or if the article is more like a compilation of Stupid

[HACKERS] Updated tsearch documentation

2007-06-16 Thread Bruce Momjian
I have completed my first pass over the tsearch documentation: http://momjian.us/expire/fulltext/HTML/sql.html They are from section 14 and following. I have come up with a number of questions that I placed in SGML comments in these files:

Re: [HACKERS] Performance Monitoring

2007-06-16 Thread Robert Treat
On Friday 15 June 2007 13:29, Greg Smith wrote: On Fri, 15 Jun 2007, Umar Farooq wrote: Surprisingly, no matter what type of query I execute, when I use strace to monitor the system calls generated they turn out to be the same for ALL sorts of queries. How are you calling strace? The

Re: [HACKERS] Load Distributed Checkpoints test results

2007-06-16 Thread Greg Smith
On Fri, 15 Jun 2007, Gregory Stark wrote: But what you're concerned about is not OLTP performance at all. It's an OLTP system most of the time that periodically gets unexpectedly high volume. The TPC-E OLTP test suite actually has a MarketFeed component to in it that has similar properties