jakob / jakob/Postico

Query returning many rows consumes two cores on MacBook Pro

Open
#616 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

## What did you do?

I ran a query that returned tens to hundreds of billions of rows.

## What did you expect to happen?

I honestly don't know what I expected to happen. I'm… sorry? 😂

## What actually happened?

The rows counter updates very quickly, rather like #610. Could use similar throttling? But this is more extreme CPU utilisation… and rapid growth in compressed RAM utilisation. I can't imagine you're loading data directly into the UI, right? Anyway, this was very silly behaviour on my part more than Postico's.

## What software versions are you using?

Postico version: Version 1.4.4 (3963)

macOS version: 10.14.1 (18B75)

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.4896

Contributor guide

No contributing guide indexed for this repository

Research direction

No files, tests, or entry points are identified in the issue. Start by reviewing the handling of queries that return extremely large result sets and the row-counter behavior referenced in issue #610; clarify the intended throttling and memory-usage behavior before defining done.

Written by the indexing model from the issue text.

Assessment

Tech stack
macos, postgresql, python
Domain
databases, desktop, performance
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.