News for hackers. Stuff that matters.
Re:Pg_lake: Postgres with Iceberg and data lake access by inglor on Tuesday November 04, 2025 @12:37PM (#45813650)
This is really nice though looking at the code - a lot of the postgres types are missing as well a lot of the newer parquet logical types - but this is a great start and a nice use of FDW.
Re:Pg_lake: Postgres with Iceberg and data lake access by pgguru on Tuesday November 04, 2025 @12:49PM (#45813791)
Hi, what types are you expecting to see that aren't supported? I believe we had support for most/all builtin postgres types.
Re:Pg_lake: Postgres with Iceberg and data lake access by inglor on Wednesday November 05, 2025 @09:01AM (#45822915)
Postgres has like 300+ types but mostly stuff like decimals should work the same way it does with Postgres (with the edge cases like NaN existing in Postgres but not parquets accordingly)
Re:Pg_lake: Postgres with Iceberg and data lake access by mslot on Wednesday November 05, 2025 @11:03AM (#45824418)
In principle, Postgres has an infinite number of possible types :).

pg_lake maps types into their Parquet equivalent and otherwise stores as text representation, there are a few limitations like very large numerics.

https://github.com/Snowflake-Labs/pg_lake/blob/main/docs/ice...

Re:Pg_lake: Postgres with Iceberg and data lake access by inglor on Tuesday November 04, 2025 @12:37PM (#45813652)
Also, any planned support for more catalogs?
Re:Pg_lake: Postgres with Iceberg and data lake access by pgguru on Tuesday November 04, 2025 @04:39PM (#45816194)
I think we have recently merged (or are getting ready to merge) REST catalog support, so that will open some things up in this department.