Re: Performance issues

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Doug McNaught <doug(at)wireboard(dot)com>
Cc: Eric Lee Green <eric(at)badtux(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Performance issues
Date: 2002-03-19 04:21:41
Message-ID: 26179.1016511701@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doug McNaught <doug(at)wireboard(dot)com> writes:
> So just te be clear, what you're seeing is that batched INSERTs go
> fast, and batched SELECTs go fast, but when you interleave them it's
> really slow?
> If you can provide a test case, I'm
> willing to bet the PG gurus will be interested...

Yup, I'd be interested in a test case. This behavior makes no sense
to me either :-(

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-03-19 05:19:19 Re: temp table indexes
Previous Message Andrew Bartley 2002-03-19 04:18:03 temp table indexes