Re: [PERFORM] Delete query takes exorbitant amount of time

On Sat, 26 Mar 2005, Karim Nassar wrote: > On Sat, 2005-03-26 at 15:18 -0800, Stephan Szabo wrote: > > On Sat, 26 Mar 2005, Karim Nassar wrote: > > > > > On Sat, 2005-03-26 at 07:55 -0800, Stephan Szabo wrote: > > > > That seems like it should be okay, hmm, what does something like: > > > > > > >

Re: [PERFORM] How to improve db performance with $7K?

1. Buy for empty PCI-X Slot - 1 or dual channel SCSI-320 hardware RAID controller, like MegaRAID SCSI 320-2X (don't forget check driver for your OS) plus battery backup plus (optional) expand RAM to Maximum 256MB - approx $1K 2. Buy new MAXTOR drives - Atlas 15K II (4x36.7GB) - approx 4x$400. 3. S

Re: [PERFORM] [BUGS] BUG #1552: massive performance hit between 7.4

On Fri, 2005-03-25 at 10:18 +, Simon Riggs wrote: > > When running with PostgreSQL 7.4 on a dual-CPU Athlon MP2400+ machine > > with a gigabyte of RAM, running Debian Linux version 2.6.8.1, we were > > able to insert all this data in 5-7 minutes. It's taken a while to > > install Postgres 8

Re: [PERFORM] pg_autovacuum not having enough suction ?

Well the simple answer is that pg_autovacuum didn't see 10,000 inserts updates or deletes. pg_autovacuum saw:476095 - 471336 = 4759 U/D's relevant for vacuuming and 634119 - 629121 = 4998 I/U/D's relevant for performing analyze. The tough question is why is pg_autovacuum not seeing all t

Re: [PERFORM] Delete query takes exorbitant amount of time

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 t

Re: [PERFORM] Hardware questions

Junaili, I'd suggest you don't buy a dell. The aren't particularly good performers. Dave Junaili Lie wrote: Hi guys, We are in the process of buying a new dell server. Here is what we need to be able to do: - we need to be able to do queries on tables that has 10-20 millions of records (around 40-6

[PERFORM] Configuration/Tuning of server/DB

Using information found on the web, I've come up with some configuration and tuning parameters for a server/db that we will be implementing. I was wondering if I could generate some feedback as to configuration and tuning so that I could compare my estimations with those of others. Host is AIX

Re: [PERFORM] Delete query takes exorbitant amount of time

On Thu, 2005-03-24 at 20:48 -0500, Tom Lane wrote: > In that case there's a datatype mismatch between the referencing and > referenced columns, which prevents the index from being used for the > FK check. Can I have more words on this? Here is how I created the tables: CREATE TABLE int_sensor_mea

[PERFORM] Query Optimizer Failure / Possible Bug

The query and the corresponding EXPLAIN is at http://hannes.imos.net/query.txt I'd like to use the column q.replaced_serials for multiple calculations in the SELECT clause, but every time it is referenced there in some way the whole query in the FROM clause returning q is executed again. This doesn

Re: [PERFORM] What about utility to calculate planner cost constants?

On Tue, Mar 22, 2005 at 08:09:40AM -0500, Christopher Browne wrote: > Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Greg Stark) > wrote: > > I don't think it would be very hard at all actually. > > > > It's just a linear algebra problem with a bunch of independent > > variables and