Skip site navigation (1) Skip section navigation (2)

Re: Delete query takes exorbitant amount of time

From: Karim Nassar <karim(dot)nassar(at)NAU(dot)EDU>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Delete query takes exorbitant amount of time
Date: 2005-03-25 05:35:55
Message-ID: 1111728955.9085.238.camel@k2.cet.nau.edu (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-performance
On Thu, 2005-03-24 at 21:24 -0800, Josh Berkus wrote:
> Karim,
> How about getting some decent disk support?  A single 10K SCSI disk is a bit 
> sub-par for a database with 100's of millions of records.  Too bad you didn't 
> get a v40z ...

Hehe. I have one I am setting up that will be dedicated to postgresql,
hence my question about a week ago about disk partitioning/striping :-)


> Beyond that, you'll want to do the same thing whenever you purge the 
> referencing table; drop keys, delete, re-create keys.  Or think about why it 
> is you need to delete batches of records from this FKed table at all.

The database is for weather data from multiple sources. When adding a
new dataset, I have to create/test/delete/recreate the config in the
FKed table. Users don't have this power, but I need it.
Drop/delete/recreate is a totally acceptable solution for this scenario.

I guess I was wondering if there is other general tuning advice for such
large table indexes such as increasing statistics, etc. 

Thanks,
-- 
Karim Nassar
Department of Computer Science
Box 15600, College of Engineering and Natural Sciences
Northern Arizona University,  Flagstaff, Arizona 86011
Office: (928) 523-5868 -=- Mobile: (928) 699-9221


In response to

Responses

pgsql-performance by date

Next:From: Oleg BartunovDate: 2005-03-25 05:38:33
Subject: Re: Delete query takes exorbitant amount of time
Previous:From: Josh BerkusDate: 2005-03-25 05:24:39
Subject: Re: Delete query takes exorbitant amount of time

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group