Re: [PERFORM] PostgreSQL as a local in-memory cache

s TCP connections. -- Jonathan Gardner jgard...@jonathangardner.net -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] PostgreSQL as a local in-memory cache

t; I may have stumbled upon this by my ignorance, but I thought I read that synchronous_commit controlled whether it tries to line up commits or has a more free-for-all that may cause some intermediate weirdness. -- Jonathan Gardner jgard...@jonathangardner.net -- Sent via pgsql-performance mailing

Re: [PERFORM] PostgreSQL as a local in-memory cache

quot;EXECUTE ins(%s)", (tx,)); >                #~ conn.commit() >                #~ cursor.execute("EXECUTE sel" ); >        conn.commit() >        d = time() - start >        tx += N > print "result : %d tps" % (tx / d) > cursor.execute("DROP TABLE t

Re: [PERFORM] PostgreSQL as a local in-memory cache

ly forgot about pgbench. I'm going to dump my cheesy python script and play with that for a while. -- Jonathan Gardner jgard...@jonathangardner.net -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [PERFORM] [HACKERS] [SQL] Materialized View Summary

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 24 February 2004 01:48 pm, Robert Treat wrote: > On Tue, 2004-02-24 at 12:11, Richard Huxton wrote: > > On Tuesday 24 February 2004 16:11, Jonathan M. Gardner wrote: > > > I've written a summary of my findings on implementing and using > > >

[PERFORM] DELETE ... WHERE ctid IN (...) vs. Iteration

. However, for a small set of data in the IN group, no tablescan is performed. I assume that (a) works at O(ln(N)) for large N, and O(N) for small N, while (b) works at O(N) universally. Therefore, (a) is the superior algorithm. I welcome criticism and correction. - -- Jonathan Gardner [EMAIL

Re: [PERFORM] Perfomance Tuning

er on. Everything else is tweaking. Is it absolutely necessary to store 8MB files in the database? I find it cumbersome. Storing them on a file server has been a better alternative for me. - -- Jonathan Gardner <[EMAIL PROTECTED]> Live Free, Use Linux! -BEGIN PGP SIGNATURE- V

Re: [PERFORM] Memory question

nel to cache, the more responsive it is going to be. - -- Jonathan Gardner <[EMAIL PROTECTED]> (was [EMAIL PROTECTED]) Live Free, Use Linux! -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/AF8EWgwF3QvpWNwRArmVAJwK5C2ExmS8Rayrne33UJ0KZZM4UgCgq7b5 3J1LGtofgtnKq/bPtF75lNI=