Re: Request to modify view_table_usage to include materialized views

Hey Tom, Thanks for the info. I'll submit a document change request instead. Thanks! Jon On Mon, Dec 5, 2022 at 11:53 AM Tom Lane wrote: > Jonathan Lemig writes: > > Would it be possible to modify the information_schema.view_table_usage > > (VTU) to include materiali

Request to modify view_table_usage to include materialized views

Hello, I think this is the correct mail list for feature/modification requests. If not please let me know which mail list I should use. Would it be possible to modify the information_schema.view_table_usage (VTU) to include materialized views? ( https://www.postgresql.org/docs/current/infoschema

Re: Name of main process differs between servers (postmaster vs postgres)

ohnston < david.g.johns...@gmail.com> wrote: > On Tue, Jun 26, 2018 at 2:51 PM, Jonathan Lemig wrote: > >> From what I can tell, things are running fine on both servers, I guess I >> just don't like there is a difference/inconsistency. Can anyone please >>

Name of main process differs between servers (postmaster vs postgres)

Hi, I noticed on two of my postgres servers, one has "postmaster" for the main process, and the other has "postgres". My question is - why is this? For example: Server1: postgres 909 1 0 May08 ?00:03:55 /usr/pgsql-9.6/bin/postmaster -D /var/lib/pgsql/9.6/data/ Server2: postgre