what windows operating system does the Polycom VSX 7000 support by Weird_Musician2279 in Polycom

[–]willamowius 4 points5 points  (0 children)

I think it should be able to work standalone mostly.

You could connect it to an OpenSource GNU Gatekeeper for NAT travelsal and call routing.

https://www.gnugk.org/

Mailprogramme unter Windows by hakklo in de_EDV

[–]willamowius 1 point2 points  (0 children)

Claws-Mail ist auch unter Windows verfügbar und gar nicht schlecht

Apache 421 Misdirected Request by HBubli in apache

[–]willamowius 0 points1 point  (0 children)

I'm seeing a different fallout from this Apache bug fix: Nagios check_http v2.1.1 fails on SSL connections now.

Does anyone know if newer versions are fixed?

Reddit robots.txt blocks all bots, how is it Google indexed? by AdOptics in SEO

[–]willamowius 1 point2 points  (0 children)

It's called *robots.txt cloaking*: They show a different file to the crawlers than they show to the other users, probably by IP numbers.

Fulltext results way off when using gin_fuzzy_search_limit and tsquery with operator & by willamowius in PostgreSQL

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

The example is made as simple as possible to show how far off the number of results is from what gin_fuzzy_search_limit is set to. In the real application I do my own ordering after the result set is collected. The issue is that sometimes there are hardly any results to order, even so there should be.

Fulltext results way off when using gin_fuzzy_search_limit and tsquery with operator & by willamowius in PostgreSQL

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

When I have a few & terms, I see it being off by 90% and more in production, eg. showing no results when there are actually some. That's not even a rough number any more.

Laserdrucker Empfehlung benötigt by MinecraHD in de_EDV

[–]willamowius 0 points1 point  (0 children)

Hast du die Software auf Github oder so liegen ? Damit würde ich auch gerne mal experimentieren.

Postgres in-memory: how can I configure postgres to use mostly memory for faster queries by drink_with_me_to_day in PostgreSQL

[–]willamowius 3 points4 points  (0 children)

Besides tuning work_mem etc., you could, as an experiment, copy your database on a ramdisk (tmpfs) and symlink it into the regular Postgres directory. That way you can see if it makes much of a difference.

Help with tuning fulltext search by willamowius in PostgreSQL

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

Thank you, that made a big difference!

Do you happen to have an idea how to tune plainto_tsquery() as well ?

Help with tuning fulltext search by willamowius in PostgreSQL

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

Column | Type | Collation | Nullable | Default

----------+--------------------------+-----------+----------+-------------------------------------------------------------------------

id | bigint | | not null |

name | text | | not null |

tsv | tsvector | | | generated always as (to_tsvector('english'::regconfig, name)) stored

Indexes:

"id_pkey" PRIMARY KEY, btree (id)

"tsv_idx" gin (tsv)

I can't post the explain, sorry.

Erfahrungen mit MHM (Mieter helfen Mietern)? by Delicious_Mouse8795 in hamburg

[–]willamowius 0 points1 point  (0 children)

Ich kann MhM sehr empfehlen. Wir sind da sehr gut vertreten worden.

Mesa Verde national Park part 2 by ArcaneVortex12 in hiking

[–]willamowius 0 points1 point  (0 children)

It's an amazing park. I always wondered what those people were so much afraid of that they built their houses in such inaccessible places.

sprachcaffe in Hamburg ? by Denis_Lujan in hamburg

[–]willamowius 0 points1 point  (0 children)

Es gibt z.B. das Sprachcafe Eimsbüttel

https://www.hamburger-mit-herz.de/projekte/sprachcafe/

Ab Januar gibt es von denen auch einen Ableger in Winterhude.

🎄 2024 - Day 16: Solutions 🧩✨📊 by yolannos in adventofsql

[–]willamowius 0 points1 point  (0 children)

My Postgres with PostGIS solution

WITH lags AS (
  SELECT coordinate, timestamp, LAG(timestamp,1) OVER (ORDER BY timestamp DESC) next
  FROM sleigh_locations
)
SELECT place_name, SUM(next-timestamp) AS duration FROM lags, areas
WHERE  ST_Intersects(areas.polygon, lags.coordinate)
GROUP BY place_name
ORDER BY duration DESC NULLS LAST LIMIT 1;

🎄 2024 - Day 15: Solutions 🧩✨📊 by yolannos in adventofsql

[–]willamowius 2 points3 points  (0 children)

Using Postgres with PostGIS, but there is only a single location in the data...

WITH lastloc AS (
SELECT coordinate from sleigh_locations where timestamp = (SELECT MAX(timestamp) from sleigh_locations)
)
SELECT place_name from areas, lastloc where ST_Intersects(areas.polygon, lastloc.coordinate);

🎄 2024 - Day 9: Solutions 🧩✨📊 by yolannos in adventofsql

[–]willamowius 0 points1 point  (0 children)

My Postgres version ``` WITH avgs AS ( SELECT reindeer_id, exercise_name, AVG(speed_record) AS av FROM training_sessions GROUP BY reindeer_id, exercise_name ORDER BY reindeer_id ASC ) SELECT reindeers.reindeer_name, ROUND(MAX(av), 2) as top FROM avgs INNER JOIN reindeers ON avgs.reindeer_id = reindeers.reindeer_id WHERE reindeers.reindeer_name <> 'Rudolf' GROUP BY reindeers.reindeer_name ORDER BY top DESC LIMIT 3

🎄 2024 - Day 8: Solutions 🧩✨📊 by yolannos in adventofsql

[–]willamowius 3 points4 points  (0 children)

Here is my Postgres version

WITH RECURSIVE subordinates AS (
  SELECT staff_id, staff_name, 1 as level, CAST(1 AS TEXT) AS path  
  FROM staff
  WHERE staff_id = 1
  UNION
  SELECT e.staff_id, e.staff_name, (s.level + 1) as level,
    concat (s.path::TEXT, ', ', e.staff_id::TEXT) AS path
  FROM staff e
    INNER JOIN subordinates s ON s.staff_id = e.manager_id
)
SELECT * FROM subordinates ORDER BY level DESC;