Re: glacial deletes (long)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: glacial deletes (long)
Date: 2001-09-03 23:21:13
Message-ID: 11896.999559273@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"P.J. \"Josh\" Rovero" <rovero(at)sonalysts(dot)com> writes:
> explain verbose delete from wx_grib_catalog where grib_file_id = 3347194;
> [ produces a seqscan ]

Do you have an index on wx_grib_catalog.grib_file_id ?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-09-03 23:36:14 Re: plpgsql function parameter questions
Previous Message Tom Lane 2001-09-03 23:11:31 Re: Crash in vacuum analyze