0

We have a query we want to run with pg-promise, but we want to cancel it if it takes to long to run. Is there a method in PGP to do this?

Edit:

I understand this is usually considered a hack, however I want to fetch roughly 100,000 rows out of 100 million or so. Those queries can take a long time, and sadly by the time we would fetch them just letting the query run(3-4 minutes) the data is considered outdated. We want to avoid that. since this is an insert heavy table and we are just reading it, letting a long read run is fine(would only cause an issue if we do an update or delete, which we don't often on this table).

Robert Mennell
  • 1,954
  • 11
  • 24
  • 1
    Might help: https://github.com/brianc/node-postgres/issues/773 – Matt Nov 16 '17 at 23:04
  • @Matt thanks I'll keep that in mind. I'm attempting to avoid touching the raw connections, but if I can't help but have to rely on the pid I might just have to do that. – Robert Mennell Nov 16 '17 at 23:06

0 Answers0