Re: [PERFORM] How to keep queries low latency as concurrency increases

2012-11-05 Thread Marko Kreen
On Tue, Nov 6, 2012 at 1:31 AM, Jeff Janes wrote: > On Mon, Nov 5, 2012 at 2:58 PM, Marko Kreen wrote: >> On Sun, Nov 4, 2012 at 1:53 AM, Jeff Janes wrote: >>> On a 4 CPU machine, if I run pgbench -c10 -j10 with dummy queries >>> (like "select 1;" or &quo

Re: [PERFORM] How to keep queries low latency as concurrency increases

2012-11-05 Thread Marko Kreen
On Sun, Nov 4, 2012 at 1:53 AM, Jeff Janes wrote: > On a 4 CPU machine, if I run pgbench -c10 -j10 with dummy queries > (like "select 1;" or "set timezone...") against 2 instances of > pgbouncer, I get nearly twice the throughput as if I use only one > instance. > > A rather odd workload, maybe, b

Re: [PERFORM] [BUGS] BUG #4919: CREATE USER command slows down system performance

2009-07-15 Thread Marko Kreen
On 7/15/09, David Wilson wrote: > On Wed, Jul 15, 2009 at 11:10 AM, Marko Kreen wrote: > > From security standpoint, wasting more cycles on bad passwords is good, > > as it decreases the rate bruteforce password scanning can happen. > > > > And I cannot imagine a sc

Re: [PERFORM] [BUGS] BUG #4919: CREATE USER command slows down system performance

2009-07-15 Thread Marko Kreen
On 7/15/09, Tom Lane wrote: > Alvaro Herrera writes: > > > toruvinn wrote: > >> I was always wondering, though, why PostgreSQL uses this approach and not > >> its catalogs. > > > It does use the catalog for most things. THe flatfile is used for the > > situations where the catalogs are not y

Re: [PERFORM] Federated Postgresql architecture ?

2008-06-30 Thread Marko Kreen
On 6/27/08, Chris Browne <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] (Josh Berkus) writes: > > Jonah, > > > >> Hmm, I didn't think the Skype tools could really provide federated > >> database functionality without a good amount of custom work. Or, am I > >> mistaken? > > > > Sure, what d

Re: [PERFORM] Utilizing multiple cores for one query

2007-12-10 Thread Marko Kreen
On 12/1/07, Jonah H. Harris <[EMAIL PROTECTED]> wrote: > Currently, the only way to parallelize a query in Postgres is to use > pgpool-II. FYI: plproxy issues queries for several nodes in parallel too. -- marko ---(end of broadcast)--- TIP 6: exp