pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gary Doades <gpd@gpdnet.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL and Linux 2.6 kernel.
Date: Fri, 02 Apr 2004 01:32:10 -0500
Message-ID: <23109.1080887530@sss.pgh.pa.us> (raw)
In-Reply-To: <406C7956.17885.4B2DCD2@localhost>
References: <BAY8-F7R0ZJi4W8StO00001d4b4@hotmail.com>
	<406C7956.17885.4B2DCD2@localhost>

"Gary Doades" <gpd@gpdnet.co.uk> writes:
> As a test in PosgreSQL I issued a statement to update a single column
> of a table containing 2.8 million rows with the values of a column in
> a table with similar rowcount.  Using the above spec I had to stop the
> server after 17 hours. The poor thing was thrashing the hard disk and
> doing more swapping than useful work.

This statement is pretty much content-free, since you did not show us
the table schemas, the query, or the EXPLAIN output for the query.
(I'll forgive you the lack of EXPLAIN ANALYZE, but you could easily
have provided all the other hard facts.)  There's really no way to tell
where the bottleneck is.  Maybe it's a kernel-level issue, but I would
not bet on that without more evidence.  I'd definitely not bet on it
without direct confirmation that the same query plan was used in both
setups.

			regards, tom lane



view thread (34+ messages)  latest in thread

Message-ID: <23109.1080887530@sss.pgh.pa.us>
Permalink:  ../23109.1080887530@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/23109.1080887530@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, gpd@gpdnet.co.uk
  Subject: Re: PostgreSQL and Linux 2.6 kernel.
  In-Reply-To: <23109.1080887530@sss.pgh.pa.us>

* 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