Postgres Pro
Downloads
Home   >   mailing lists

Re: glacial deletes (long) - Mailing list pgsql-general

From Tom Lane
Subject Re: glacial deletes (long)
Date
Msg-id 11896.999559273@sss.pgh.pa.us
Whole thread Raw
In response to glacial deletes (long)  ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>)
List pgsql-general
Tree view 
"P.J. \"Josh\" Rovero" <rovero@sonalysts.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Crash in vacuum analyze
Next
From: Bruce Momjian
Date:
Subject: Re: plpgsql function parameter questions