El vie, 21 ene 2022 a las 5:04, Michael Lewis ()
escribió:
> When dealing with foreign tables, I believe planning is not the same
> because of access to statistics (maybe has improved since 9.6 though). I
> just wonder... Would it be a viable option to create a materialized view
> using the FDW bu
When dealing with foreign tables, I believe planning is not the same
because of access to statistics (maybe has improved since 9.6 though). I
just wonder... Would it be a viable option to create a materialized view
using the FDW but then use the PHP script against the local tables only?
Materialize
Ekaterina Amez writes:
> I've tested the query with psql and DBeaver and it takes only milliseconds:
> it returns 39 records and now there's only 16000 records on the table but
> I've tested it with <100K. When I've tested my php script the same query
> takes 14 minutes to return (more or less).
Hi,
After receiving an Unknown Address error with *pgsql-...@postgresql.org* I've
discovered this mailing list is catalogued as Inactive, so I'm sending my
question to this list.
I've made a php cli script that downloads a file from FTP, loads it in a
table and compares against the same table in
