pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Rod Taylor <pg@rbt.ca>
To: David Teran <david.teran@cluster9.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: optimizing Postgres queries
Date: Thu, 08 Jan 2004 22:16:49 -0500
Message-ID: <1073618208.322.18.camel@jester> (raw )
In-Reply-To: <6F2414E8-3FB9-11D8-A528-000A95A6F0DC@cluster9.com >
References: <4B0023AC-3F72-11D8-B3EB-000A95A6F0DC@cluster9.com >
<200401051705.55120.shridhar_daithankar@myrealbox.com >
<64C8DBBA-3F77-11D8-A528-000A95A6F0DC@cluster9.com >
<200401051740.05006.shridhar_daithankar@myrealbox.com >
<3796212E-3F79-11D8-A528-000A95A6F0DC@cluster9.com >
<9966.1073316152@sss.pgh.pa.us >
<9CC6A792-3FAF-11D8-A528-000A95A6F0DC@cluster9.com >
<16230.1073328760@sss.pgh.pa.us >
<A5055773-3FB1-11D8-A528-000A95A6F0DC@cluster9.com >
<20540.1073329548@sss.pgh.pa.us >
<4530AF9E-3FB4-11D8-A528-000A95A6F0DC@cluster9.com >
<20759.1073330625@sss.pgh.pa.us >
<6F2414E8-3FB9-11D8-A528-000A95A6F0DC@cluster9.com >
On Mon, 2004-01-05 at 14:57, David Teran wrote:
> ... wow:
>
> executing a batch file with about 4250 selects, including lots of joins
> other things PostgreSQL 7.4 is about 2 times faster than FrontBase
> 3.6.27. OK, we will start to make larger tests but this is quite
> interesting already: we did not optimize a lot, just invoked VACUUM
> ANALYZE and then the selects ;-)
>
> Thanks to all who answered to this thread.
I presume that batch file was executed linearly -- no parallelism?
You're actually testing one of PostgreSQL's shortcomings.
PostgreSQL (in my experience) does much better in such comparisons with
a parallel load -- multiple connections executing varied work (short
selects, complex selects, inserts, updates, deletes).
Anyway, just a tip that you will want to test your actual load. If you
do batch work with a single thread, what you have is fine. But if you
have a website with tens or hundreds of simultaneous connections then
your non-parallel testing will not reflect that work load.
view thread (17+ messages)
Message-ID: <1073618208.322.18.camel@jester>
Permalink: ../1073618208.322.18.camel@jester/
Also on: postgresql.org/message-id/1073618208.322.18.camel@jester
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pg@rbt.ca, david.teran@cluster9.com, tgl@sss.pgh.pa.us
Subject: Re: optimizing Postgres queries
In-Reply-To: <1073618208.322.18.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox