ericemc3

### What happens? I want to create a spatial table into my Postgis Database from a geojson file, using duckdb-postgres. ### To Reproduce ``` CREATE OR REPLACE TABLE postgres_db.provincie_2025 AS...

can't open a geojson.gz file

5

`FROM st_read('https://object.data.gouv.fr/contours-administratifs/2024/geojson/departements-100m.geojson.gz') ;` => SQL Error: Not implemented Error: GZipFileSystem: GetLastModifiedTime is not implemented!

Autocompletion not working easily with DuckDB?

1

### Description With Postgres, i can write `Select * from`, hit Ctrl Space, and then select a table in a list. Then if i hit Ctrl Space on the '*',...

Request crashing DuckDB

1

### What happens? From https://duckpgq.org/#__tabbed_3_4 ### To Reproduce ``` -- Number of forums posted on by the most followed person WITH mfp AS ( FROM GRAPH_TABLE (snb MATCH (follower:Person)-[follows:knows]->(person:Person) COLUMNS...

Performance issue with finbench example

2

### What happens? I read with great interest your blog post: https://duckdb.org/2025/10/22/duckdb-graph-queries-duckpgq ### To Reproduce But this final request takes 2 minutes on my PC: ``` FROM GRAPH_TABLE(finbench MATCH p...

I have a `SET file_search_path = '...';` setting. but neither pbix_meta() nor pbix_read() seem to take it into account

### Description If i switch to map view in the data editor, then launch another query, progress bar don't show ### DBeaver Version community 25.3 ### Operating System win 11...

Poor window function performance compared to a SEMI JOIN equivalent

6

### What happens? A two lines query with a window function condition takes (at least) 20 times longer than its (verbose) equivalent using a semi-join. ### To Reproduce I can’t...

The second execution of the same request takes twice as long, even after a DROP TABLE

4

### What happens? source data: https://icem7.fr/data/2025-09-27_123.parquet (500 Mo) ### To Reproduce ```sql CREATE OR REPLACE TABLE t1 AS SELECT *, COUNT(*) OVER w AS nbDupExactComm FROM read_parquet('2025-09-27_123.parquet') WINDOW w AS...