Re: R: Vacuum full: alternatives? - Mailing list pgsql-general

From Martín Marqués
Subject Re: R: Vacuum full: alternatives?
Date
Msg-id 599301d6-7fbf-82f4-20c5-0c9368b872cc@2ndquadrant.com
Whole thread Raw
In response to Re: R: Vacuum full: alternatives?  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: R: Vacuum full: alternatives?  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
El 20/06/16 a las 12:06, Melvin Davidson escribió:
>
> Martin and Vik,
>
>>...Think about a SELECT which has to scan all child tables.
>
> You are really digging for a corner case.
> If a scan has to scan all child tables, then
> A. it negates the ability to make partitions which are not used
> and
> B. The SELECT query is poorly crafted.

And you haven't read Vik's reply. :)

--
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: R: Vacuum full: alternatives?
Next
From: Melvin Davidson
Date:
Subject: Re: R: Vacuum full: alternatives?