Performance-Problem

From: elwood(at)agouros(dot)de (Konstantinos Agouros)
To: pgsql-general(at)postgresql(dot)org
Subject: Performance-Problem
Date: 2001-03-30 17:10:25
Message-ID: elwood.985972029@news.agouros.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I had the following problem: I have a table with around 5Mio entries.
I joined this table with a table with about 50 entries. Doing a insert into
another_table <my select-statement>. I am sure the select-statement might be
optimized but after 6 days of running I had to reboot the machine for other
reasons. The Machine is a 2CPU E250 Sun Sparc running 7.0.3.
Anybody has an idea (besides SQL-Tuning) how to get faster? Maybe take a look
at 7.1, since this is not a production database yet.
The SQL-Statement (yes I know I should post this, too, but I don't have access
to the script right now) was called from a perlscript using DBI/DBD and I have
set -F in the PGOPTIONS-parameter as well as AutoCommit to 0.

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2001-03-30 17:30:14 RE: dynamic field names in a function.
Previous Message Bruce Momjian 2001-03-30 17:00:13 Re: Temporary table