jakob / jakob/Postico

Provide option to let query run as long as necessary

Open
#593 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

You can use this template for reporting bugs.
Feel free to remove parts that are not relevant, or just write something free-form if you prefer.

## What did you do?

- I executed a COPY query for AWS Redshift which takes a very long time.

## What did you expect to happen?

- I expected Postico to wait until the query completed.

## What actually happened?

- The app closed the connection after 300 seconds, which cancelled the query

## What software versions are you using?

Postico version:
1.4.2 (2845)

macOS version:
10.13.6 (17G65)

PostgreSQL version:
PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.3906

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue concerns long-running AWS Redshift COPY queries and a connection timeout after 300 seconds. Start by locating the query execution and timeout handling in the Postico codebase, then inspect the existing comments or tests around connection cancellation. Done means users can choose to let a query run beyond the current limit without the connection being closed.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, postgresql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.