| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
| Cc: | David Kerr <dmk(at)mr-paradox(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: LONG delete with LOTS of FK's |
| Date: | 2013-05-17 22:12:02 |
| Message-ID: | d6afdf62-e63b-4539-ae98-728cc8c23432@email.android.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> wrote:
>On 18/05/13 03:06, Larry Rosenman wrote:
>> On 2013-05-16 18:35, David Kerr wrote:
>>
>>> - I'll take a look tomorrow, but we WERE seeing Seq Scan's against
>>> - multi-million
>>> - row tables, so I suspect Tom is right on with the replanning
>that's in
>>> - 9.2 fixing
>>> - it, and I'm in the process of validating that.
>>>
>>> That seems likely, although you could try enable_seqscan=false as
>well.
>>>
>>> Dave
>> The 9.2 upgrade DOES fix my issue.
>>
>> Thanks again, Tom and everyone.
>>
>>
>Did you also */enable_seqscan=false as well/*?
>
>Cheers,
>Gavin
No. Same set up as 9.1
--
Sent from Kaiten Mail. Please excuse my brevity.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raghavendra | 2013-05-18 07:09:16 | Re: Regarding Postgres Plus Associate Certification |
| Previous Message | Gavin Flower | 2013-05-17 21:49:42 | Re: LONG delete with LOTS of FK's |