On Tue, Feb 07, 2006 at 07:54:19PM +0100, Nemanja Corlija wrote:
> On 2/7/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> > You might want to put a legend on your results tables so it's clear
> > what the numbers represent. I assume these are times but I didn't see
> > anything so far that said.
>
On Tue, Feb 07, 2006 at 08:07:03PM +0100, Nemanja Corlija wrote:
> On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > AFAIK MySQL ships with a few different config files, so presumably
> > choosing the appropriate one would be equivalent to what I provided for
> > PostgreSQL.
> Yes, and I
On Tue, Feb 07, 2006 at 11:51:22AM -0500, [EMAIL PROTECTED] wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> > On Tue, Feb 07, 2006 at 09:54:22AM -0600, Jim C. Nasby wrote:
> > > Hrm, that's rather odd. What does top show when it's running through
> > > psql? Are the test scripts available for
On Tue, Feb 07, 2006 at 08:11:02PM +0100, Nemanja Corlija wrote:
> On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > I see theh tcl now... is TCL piping into psql, or are there a set of raw
> > files you could post or send me?
> TCL generates files and then I'm piping those files to all
On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> I see theh tcl now... is TCL piping into psql, or are there a set of raw
> files you could post or send me?
TCL generates files and then I'm piping those files to all databases
except Firebird, which doesn't accept commands from stdin so I'm
On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> AFAIK MySQL ships with a few different config files, so presumably
> choosing the appropriate one would be equivalent to what I provided for
> PostgreSQL.
Yes, and I installed it as a developer machine. That should be the
least performant one of
> > You might want to put a legend on your results tables so it's clear
> > what the numbers represent. I assume these are times but I didn't see
> > anything so far that said.
> Its time in seconds.
> "sync" in case of SQLite is PRAGMA synchronous=FULL; while in case of
> MySQL it signifies usage
Jim C. Nasby said:
> Finally, and luckily this applies to SQLite as well so this doesn't get
> too off topic :), PLEASE seek help/advice BEFORE spending a bunch of
> money on a big server! All too often I see people who spend a load of $$
> on equipment they didn't need or won't be able to
On 2/7/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> You might want to put a legend on your results tables so it's clear
> what the numbers represent. I assume these are times but I didn't see
> anything so far that said.
Its time in seconds.
"sync" in case of SQLite is PRAGMA synchronous=FULL;
On 2/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Looks like I need to work on Test 6 some, huh? Your suggestion
> that the servers are creating a temporary index to do the join
> was my first throught too. I wonder if I should look into teaching
> that trick to SQLite. Do you think you
On Tue, Feb 07, 2006 at 10:04:43AM -0500, Clay Dowling wrote:
>
> Jim C. Nasby said:
>
> > Well, that certainly won't help things... at a minimum, on your machine,
> > you should change the following:
> > shared_buffers=1
> > effective_cache_size=10
> >
> > The following should also
On Tue, Feb 07, 2006 at 09:54:22AM -0600, Jim C. Nasby wrote:
> Hrm, that's rather odd. What does top show when it's running through
> psql? Are the test scripts available for download? I'll try this on my
> machine as well...
I see theh tcl now... is TCL piping into psql, or are there a set of
On Tue, Feb 07, 2006 at 08:07:53AM -0500, [EMAIL PROTECTED] wrote:
> It is also interesting to note that PostgreSQL get significantly
> slower in Test 13 (join with an index) versus Test 6 (the same
> join without an index). What is that about? Firebird shows the
> same effect, but less
On Tue, Feb 07, 2006 at 10:08:23AM +0100, Nemanja Corlija wrote:
> On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > On Tue, Feb 07, 2006 at 07:31:50AM +0100, Nemanja Corlija wrote:
> > > > Well, that certainly won't help things... at a minimum, on your machine,
> > > > you should change the
On 2/6/06, Nemanja Corlija <[EMAIL PROTECTED]> wrote:
> I've posted some benchmarks between SQLite, PostgreSQL, MySQL and FirebirdSQL.
>
> Details at http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
You might want to put a legend on your results tables so it's clear
what the numbers
Jim C. Nasby said:
> Well, that certainly won't help things... at a minimum, on your machine,
> you should change the following:
> shared_buffers=1
> effective_cache_size=10
>
> The following should also help:
> work_mem=1
> vacuum_cost_delay=50
> autovacuum=on
>
Nemanja Corlija <[EMAIL PROTECTED]> wrote:
> I've posted some benchmarks between SQLite, PostgreSQL, MySQL and FirebirdS=
> QL.
>
> Details at http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
>
Thanks for your hard work, Nemanja! This is useful information.
Looks like I need to work on
On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> On Tue, Feb 07, 2006 at 07:31:50AM +0100, Nemanja Corlija wrote:
> > > Well, that certainly won't help things... at a minimum, on your machine,
> > > you should change the following:
> > > shared_buffers=1
> > > effective_cache_size=10
>
On Tue, Feb 07, 2006 at 07:06:26AM +0100, Nemanja Corlija wrote:
> On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > Did you happen to do an analyze?
> Nope. All databases are run as default as possible. And, they all get
> same scripts to execute.
Then your results for PostgreSQL are
On Tue, Feb 07, 2006 at 07:31:50AM +0100, Nemanja Corlija wrote:
> > Did you happen to do an analyze?
> Nope. All databases are run as default as possible. And, they all get
> same scripts to execute.
Which means PostgreSQL can only take a wild stab at what's in the
database.
> > > > What
On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> On Tue, Feb 07, 2006 at 07:06:26AM +0100, Nemanja Corlija wrote:
> > On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > > For test 8 on PostgreSQL, what's EXPLAIN ANALYZE for one of those show?
> > test=# EXPLAIN ANALYZE SELECT count(*),
On Tue, Feb 07, 2006 at 07:06:26AM +0100, Nemanja Corlija wrote:
> On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > For test 8 on PostgreSQL, what's EXPLAIN ANALYZE for one of those show?
> test=# EXPLAIN ANALYZE SELECT count(*), avg(b) FROM t2 WHERE b>=0 AND b<100;
>
On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> For test 8 on PostgreSQL, what's EXPLAIN ANALYZE for one of those show?
test=# EXPLAIN ANALYZE SELECT count(*), avg(b) FROM t2 WHERE b>=0 AND b<100;
QUERY PLAN
On Tue, Feb 07, 2006 at 05:57:24AM +0100, Nemanja Corlija wrote:
> I've posted some benchmarks between SQLite, PostgreSQL, MySQL and FirebirdSQL.
>
> Details at http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
For test 8 on PostgreSQL, what's EXPLAIN ANALYZE for one of those show?
What
24 matches
Mail list logo