View Issue Details

IDProjectCategoryView StatusLast Update
0008484VALENTINA STUDIOTool - SQL Editorpublic2019-05-12 06:26
Reportersv-alexAssigned ToSergey Pashkov 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformINTELOSMAC OS OS Version*
Product Version 
Target VersionFixed in Version 
Summary0008484: First Query Hangs
DescriptionI have a postgres database with around 1000 schemas. Each schema has around 50 tables. These tables can very in size, but some have millions of rows.

The first query I run against this database always takes 2-5 minutes to return any data, even when making a trivial query.

While my client is hung I can see that it is running queries against pg_catalog.

This behavior should be sped up or made optional.
TagsNo tags attached.
Working with DB:postgreSQL Server
Version of your DB

Activities

sv-alex

sv-alex

2019-04-25 19:43

reporter   ~0010759

Come on guys, don't make me switch to DBeaver!
Sergey Pashkov

Sergey Pashkov

2019-04-25 21:16

developer   ~0010760

Hello,

So you can type in your query but after you click Execute you wait 2-5 minutes before getting the result. Right?
sv-alex

sv-alex

2019-04-26 13:58

reporter   ~0010762

Yes, that is correct
Sergey Pashkov

Sergey Pashkov

2019-05-12 06:26

developer   ~0010802

Fix will be available in version 9.1.5

Issue History

Date Modified Username Field Change
2019-03-14 14:10 sv-alex New Issue
2019-04-25 19:43 sv-alex Note Added: 0010759
2019-04-25 21:16 Sergey Pashkov Note Added: 0010760
2019-04-26 13:58 sv-alex Note Added: 0010762
2019-05-11 20:42 Sergey Pashkov Assigned To => Sergey Pashkov
2019-05-11 20:42 Sergey Pashkov Status new => confirmed
2019-05-12 06:26 Sergey Pashkov Status confirmed => resolved
2019-05-12 06:26 Sergey Pashkov Resolution open => fixed
2019-05-12 06:26 Sergey Pashkov Note Added: 0010802