haman...@t-online.de writes:
> I am using a query pretty often that looks like
> SELECT <> WHERE <> AND
> <>
>
> Is there a way (with sql or plpgsql) to convert that into
> SELECT myquery('<>')
I would solve that by creating a view like:
CREATE VIEW some_view_name AS
SELECT <> WHERE <>;
See
Matthew Pounsett writes:
> [...] Is there any rule of thumb for making sure one has enough space
> available for the upgrade?
No, because it depends greatly on which version you are upgrading from
and which version you are upgrading to etc.
Perhaps you could carve out a slice of data, e.g. 1 GB
Matthew Pounsett writes:
> On Thu, 18 Jul 2019 at 19:53, Rob Sargent wrote:
>
> Can you afford to drop and re-create those 6 indices?
>
> Technically, yes. I don't see any reason we'd be prevented from doing that.
> But, rebuilding them will take a long time. That's a lot of downtime to incur
