On Sun, 24 Aug 2008 13:37:11 +0200
Alban Hertroys <[EMAIL PROTECTED]> wrote:
> >>> Is it going to make things faster if I:
> >>> delete from s;
> >>> reindex table s;
> >> Why do you think this step would help you any? There's no index
> >> on p to begin with. You'd just be reindexing the auto-g
On Aug 22, 2008, at 9:45 AM, Ivan Sergio Borgonovo wrote:
On Fri, 22 Aug 2008 08:48:30 +0200
Alban Hertroys <[EMAIL PROTECTED]> wrote:
Is it going to make things faster if I:
delete from s;
reindex table s;
Why do you think this step would help you any? There's no index on
p to begin wit
On Fri, 22 Aug 2008 08:48:30 +0200
Alban Hertroys <[EMAIL PROTECTED]> wrote:
>
> > Is it going to make things faster if I:
> >
> > delete from s;
> > reindex table s;
> Why do you think this step would help you any? There's no index on
> p to begin with. You'd just be reindexing the auto-generat
Is it going to make things faster if I:
delete from s;
reindex table s;
Why do you think this step would help you any? There's no index on p
to begin with. You'd just be reindexing the auto-generated unique
index on s (due to it being a PK).
delete from p;
And no, this would most lik
On Thu, 21 Aug 2008 10:19:44 -0700
Joshua Drake <[EMAIL PROTECTED]> wrote:
> On Thu, 21 Aug 2008 10:16:21 -0700
> Alan Hodgson <[EMAIL PROTECTED]> wrote:
>
>
> > > Any hint to track down the problem?
> > 1) Define slow.
still undefined anyway 20-30min compared to over 2h and still
running.
>
On Thu, Aug 21, 2008 at 07:06:32PM +0200, Ivan Sergio Borgonovo wrote:
> I've a large table with a pk and several smaller tables with fk
> referencing to it.
>
> deleting from the first table is very slow.
>
> Not all the related fk have indexes but they are VERY small (0 to
> 100 records) while
On Thu, 21 Aug 2008 10:16:21 -0700
Alan Hodgson <[EMAIL PROTECTED]> wrote:
> > Any hint to track down the problem?
>
> 1) Define slow.
>
> 2) Tell us what your disk subsystem consists of.
>
> 3) Are there any delete triggers on the tables?
>
And the EXPLAIN ANALYZE
Joshua D. Drake
--
The
On Thursday 21 August 2008, Ivan Sergio Borgonovo <[EMAIL PROTECTED]>
wrote:
> I've a large table with a pk and several smaller tables with fk
> referencing to it.
>
> deleting from the first table is very slow.
>
> Not all the related fk have indexes but they are VERY small (0 to
> 100 records) w