Managing Databases with Partititions

[Scott Waldon]

I'm using Build 128.4 (2022-09-04 17:39) with Java 17 (64 bit)

I've searched thru the manual and can't find any mention of any preferences for dealing with partitions.

In other tools a table XYZ when partitioned has a subfolder beneath it where the partitions are found. In SQLWorkbench they appear to be expanded in the context of the current table list. Such that when there is a 1000 way partition. You have 1000 table names to scroll thru to see the next table name. This becomes unmanageable very quickly when dealing with large data.

Have I missed some obvious or hidden setting, or is the a feature enhancement request?

Thanks for your thoughts and suggestions

Scott

[Thomas Kellerer]

The DbTree will display it like that:

Postgres:

Oracle:

Regards
Thomas

[Scott Waldon]

I've never seen sqlworkbench display like this, but instead all I've ever seen is this format. I am connecting to postgres.

[Thomas Kellerer]

It looks like you are using the DbExplorer rather than the DbTree.

Which SQL Workbench build are you using and what is the JDBC driver version?
Newer drivers report those tables as "PARTITIONED TABLE" not "TABLE"

You can filter out partitions by changing a configuration setting, e.g. by running WbSetDBConfig:

WbSetDBConfig partitions.tablelist.remove=true;

But this depends a bit on the driver (and only works for partitions using the declarative partitioning not for the deprecated inheritance based partitioning).

Regards
Thomas

Scott Waldon schrieb am 20.01.2023 um 21:36:
> I've never seen sqlworkbench display like this, but instead all I've ever seen is this format. I am connecting to postgres.
>

> SqlWorkBenchPartitions.PNG
>
> On Friday, January 20, 2023 at 10:33:55 AM UTC-5 Thomas Kellerer wrote:
>
> The DbTree will display it like that:
>
> Postgres:
>

> Oracle: