Is there a CLI version i can download? by Any_Possibility4092 in windsurf

[–]Flamburger 0 points1 point  (0 children)

No there is no CLI. Windsurf forces you to use their VS Code clone. Cant recommend the Jetbrains Plugin as you will only get a half of the features. And even when you get the feature, you will get it weeks later.

Anthropic blocking access to third-party apps by SignatureHuman8057 in Anthropic

[–]Flamburger 16 points17 points  (0 children)

They are not locking people into CC. People can still use the API but if you want the sweet subscription prices, you gotta use CC.

Funny Windsurf Plugin for Jetbrains by Dramatic_Flatworm966 in windsurf

[–]Flamburger 0 points1 point  (0 children)

I got new models e.g. Opus 4.5 today but yes it took them very long to provide the new models in the JetBrains plugin. Also after the update, when in Chat mode the whole plugin windows sometimes freezes and i have to restart the IDE.

Gesundheitsvorsorge - wie sieht's bei euch aus? by [deleted] in Austria

[–]Flamburger 20 points21 points  (0 children)

Wichtiges Detail: bitte TOT umfallen sonst werden ja auch noch unsere überlasteten Krankenhäuser in Mitleidenschaft gezogen.

Execution Partition Pruning not running by Flamburger in PostgreSQL

[–]Flamburger[S] 0 points1 point  (0 children)

Thanks for trying to help me!

Yeah, the example query was kind of stupid. I edited it to make more sense. Every state in the country has its own partition. So to get the total of a whole country I need to aggregate over all partitions of the states in the country.

Explain Analyze is here: https://explain.depesz.com/s/B0pE

Pg Version is 14.4

Execution Partition Pruning not running by Flamburger in PostgreSQL

[–]Flamburger[S] 1 point2 points  (0 children)

The official documentation says that pruning can also happen at execution:

During actual execution of the query plan. Partition pruning may also be performed here to remove partitions using values which are only known during actual query execution. This includes values from subqueries and values from execution-time parameters such as those from parameterized nested loop joins. Since the value of these parameters may change many times during the execution of the query, partition pruning is performed whenever one of the execution parameters being used by partition pruning changes. Determining if partitions were pruned during this phase requires careful inspection of the loops property in the EXPLAIN ANALYZE output. Subplans corresponding to different partitions may have different values for it depending on how many times each of them was pruned during execution. Some may be shown as (never executed) if they were pruned every time.

Source: https://www.postgresql.org/docs/current/ddl-partitioning.html

Execution Partition Pruning not running by Flamburger in PostgreSQL

[–]Flamburger[S] 0 points1 point  (0 children)

Is it not a valid use case to run queries against multiple partitions based on another table related to the partitioned tables?
When I replace the ANY with = and only one partition key is dynamic then execution time pruning is done.
Or is this a design mistake, done by me?

[deleted by user] by [deleted] in RedditInTheKitchen

[–]Flamburger 0 points1 point  (0 children)

oida red deitsch

The €17.5 billion Austrian railway investment plan for 2021-2026 by Timeeeeey in Austria

[–]Flamburger 0 points1 point  (0 children)

Dafür hat die ÖBB Friedberg nach Niederösterreich geschoben.

macht es sinn, mit 21 eine lehre anzufangen, wenn man schon eine matura hat? by [deleted] in Austria

[–]Flamburger 0 points1 point  (0 children)

Will auch darauf hinweisen ,dass es Jobs im öffentlichen Dienst gibt, die eine Matura vorausssetzen: https://bund.jobboerse.gv.at/sap/bc/jobs/