Search Postgresql Archives

Re: Column type modification in big tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Column type modification in big tables
From: Dominique Devienne <ddevienne@xxxxxxxxx>
Date: Wed, 14 Aug 2024 10:04:17 +0200
In-reply-to: <20240813205351.eqzihh5t7urh7olf@hjp.at>
References: <CAD=mzVUX13ZM16kP4QhY+F5XiLr=ezCXftKOTKA4eUvhphgOJw@mail.gmail.com> <CAKna9Vb_mx+dX02XOV6mpr8RFC-5io38kM6=4xRHQj_MUvQ+aQ@mail.gmail.com> <CAKAnmmJ6fqyYafLB_im75oxxfTuCLUY0ftBPU57pUm0g+pm6FQ@mail.gmail.com> <CAKna9VZJ4fginFJZenGQxWs9eAw9Z8g-YkdnOFcie5RvuJ=5OQ@mail.gmail.com> <CAKAnmmLv72uk1p8+zmWpkC+BTatrdmRe_NpRbwRsi1LAU-cJFQ@mail.gmail.com> <CAKna9VZGwtNx9NAZ0QjdT-WhtFETAaFzpUsvM6R90mjaAoP3vA@mail.gmail.com> <CAD=mzVVS6HbV25M7EA+TJYk22G=GJvQK5Gbe9eeifYSmadYtNA@mail.gmail.com> <CAKna9Vb0ABStAWogCsXK+jTT9ZuLESJ0_-r3Wtvd=rZpYMYwxw@mail.gmail.com> <CAKAnmm+_avfVEFGgADebEyH=oQrEDuvviOcMYNa+myjJrds8Eg@mail.gmail.com> <CAKna9VaA5N7sNRmjL7QujG92Mk-rx-7R1nSGhOVNZyXma=8LPw@mail.gmail.com> <20240813205351.eqzihh5t7urh7olf@hjp.at>

On Tue, Aug 13, 2024 at 10:54 PM Peter J. Holzer <hjp-pgsql@xxxxxx> wrote:
> You could look at the data files. Tables in PostgreSQL are stored as a
> series of 1GB files, so you watching them being created and/or read
> gives you a pretty good idea about progress.

Thanks Peter, very insightful. Appreciated. --DD

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Re: Column type modification in big tables
  - From: sud
- Re: Column type modification in big tables
  - From: Lok P
- Re: Column type modification in big tables
  - From: Greg Sabino Mullane
- Re: Column type modification in big tables
  - From: Lok P
- Re: Column type modification in big tables
  - From: Greg Sabino Mullane
- Re: Column type modification in big tables
  - From: Lok P
- Re: Column type modification in big tables
  - From: sud
- Re: Column type modification in big tables
  - From: Lok P
- Re: Column type modification in big tables
  - From: Greg Sabino Mullane
- Re: Column type modification in big tables
  - From: Lok P
- Re: Column type modification in big tables
  - From: Peter J. Holzer

Prev by Date: Re: Column type modification in big tables
Next by Date: Using PQsocketPoll() for PIPELINE mode
Previous by thread: Re: Column type modification in big tables
Next by thread: Re: Column type modification in big tables
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]