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 t

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,

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 broadcast)---

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 m

[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." http://www.securityfocus.com/

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 P

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: http://momjian.us/expire/fulltext/SGML/

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?

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

Re: [HACKERS] Load Distributed Checkpoints test results

2007-06-16 Thread Heikki Linnakangas
Josh Berkus wrote: 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. It would be the ldc-justwrites-2.patch: http://archives.postgresql.org/pgsql-patches/2007-06/