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

Re: Delete query takes exorbitant amount of time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Karim Nassar <karim(dot)nassar(at)NAU(dot)EDU>,Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Delete query takes exorbitant amount of time
Date: 2005-03-25 15:17:17
Message-ID: 23515.1111763837@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> I vote to make this an ERROR in 8.1 - I see little benefit in allowing
> this situation to continue.

Other than spec compliance, you mean?  SQL99 says

            ... The declared type of each referencing column shall be
            comparable to the declared type of the corresponding referenced
            column.

It doesn't say that it has to be indexable, and most definitely not that
there has to be an index.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Simon RiggsDate: 2005-03-25 15:38:25
Subject: Re: [BUGS] BUG #1552: massive performance hit
Previous:From: Jack XueDate: 2005-03-25 15:12:05
Subject: Script for getting a table of reponse-time breakdown

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