postgres_fdw FAST "where id in (140,144,148)" SLOW: "where id in (select 140 as id union select 144 union select 148)"

Hi I have postgres_fdw table called tbl_link. The source table is 2.5 GB in size with 122 lines (some lines has 70MB bytea column, but not the ones I select in the example) I noticed that when I put the specific ids in the list "where id in (140,144,148)" it works fast (few ms), but when I

Re: VACUUM FULL missing chunk number 0 for toast value

Yi Sun writes: > Once we tried to vacuum full a table, got the error msg "ERROR: missing > chunk number 0 for toast value", there is a doc as below for the select > issue, but for our case select is no issue, Hmm, "SELECT *" doesn't throw any error? That suggests that the missing-toast-data

Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2

This problem posted in OP is resolved. I did some workaround. I copied the required "pg_config*.h" from another machine where PG13 was installed via amazon linux 2 repos. > I don't believe 9.6 was supported either, but it may have worked "by chance". I'm not sure whether it worked "by chance" or

VACUUM FULL missing chunk number 0 for toast value

Hi All, OS: CentOS 7.6 PG: 11.11 Once we tried to vacuum full a table, got the error msg "ERROR: missing chunk number 0 for toast value", there is a doc as below for the select issue, but for our case select is no issue, what's the reason caused and how to fix this please? Thanks

Re: Visibility of data from table inherits function

On Sun, 2 Jan 2022 at 20:42, ourdiaspora wrote: > On Sunday, January 2nd, 2022 at 3:54 PM, Francisco Olarte > wrote: > > Inherits does not copy things. LIKE on creation does, but AFAIK it can > > copy nearly everything except data. > Thanks, had read that part of the documentation. > So far it