Re: enhance the efficiency of migrating particularly large tables

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: David Zhang <david(dot)zhang(at)highgo(dot)ca>
Cc: Pgsql Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: enhance the efficiency of migrating particularly large tables
Date: 2024-05-02 22:55:06
Message-ID: CAApHDvod=QWNDhzpe6oHdCLbPfZ5i-dutAG9-Wrvj_3CbxpZQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 3 May 2024 at 09:33, David Zhang <david(dot)zhang(at)highgo(dot)ca> wrote:
> Is there a simple way to get the min of ctid faster than using min(), but similar to get the max of ctid using pg_relation_size?

The equivalent approximation is always '(0,1)'.

David

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2024-05-02 23:04:40 Re: Removing unneeded self joins
Previous Message David Zhang 2024-05-02 22:37:08 wrong comment in libpq.h