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

 · 

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