# Auto-ddos

**URL:** <https://meta.discourse.org/t/self-ddos/388614>\
**Category:** Product Support\
**Tags:** unsupported-install\
**Created:** [17 Novembre 2025, 12:28am UTC](https://meta.discourse.org/t/self-ddos/388614 "2025-11-17T00:28:51Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Eviepayne](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/eviepayne/32/352733_2.png) [@Eviepayne](https://meta.discourse.org/u/Eviepayne)\
**Post date:** [17 Novembre 2025, 12:28am UTC](https://meta.discourse.org/t/self-ddos/388614/1 "2025-11-17T00:28:51Z")

</div>

Non sono sicuro se questo sia un bug o meno, ma sembra che il mio forum stia subendo un attacco DDoS.  
Una volta al giorno il sito va giù perché sembra che stia creando un indice:

> CREATE INDEX CONCURRENTLY temp\_idx\_recent\_regular\_post\_search\_data  
> ON post\_search\_data USING GIN(search\_data)  
> WHERE NOT private\_message AND post\_id \>= 0

Questo a sua volta crea molte query parallele:

> SELECT “posts”.“id”, “posts”.“user\_id”, “posts”.“topic\_id”, “posts”.“post\_number”, “posts”.“raw”, “posts”.“cooked”, “posts”.“created\_at”, “posts”.“updated\_at”, “posts”.“reply\_to\_post\_number”, “posts”.“reply\_count”, “posts”.“quote\_count”, “posts”.“deleted\_at”, “posts”.“off\_topic\_count”, “posts”.“like\_count”, “posts”.“incoming\_link\_count”, “posts”.“bookmark\_count”, “posts”.“score”, “posts”.“reads”, “posts”.“post\_type”, “posts”.“sort\_order”, “posts”.“last\_editor\_id”, “posts”.“hidden”, “posts”.“hidden\_reason\_id”, “posts”.“notify\_moderators\_count”, “posts”.“spam\_count”, “posts”.“illegal\_count”, “posts”.“inappropriate\_count”, “posts”.“last\_version\_at”, “posts”.“user\_deleted”, “posts”.“reply\_to\_user\_id”, “posts”.“percent\_rank”, “posts”.“notify\_user\_count”, “posts”.“like\_score”, “posts”.“deleted\_by\_id”, “posts”.“edit\_reason”, “posts”.“word\_count”, “posts”.“version”, “posts”.“cook\_method”, “posts”.“wiki”, “posts”.“baked\_at”, “posts”.“baked\_version”, “posts”.“hidden\_at”, “posts”.“self\_edits”, “posts”.“reply\_quoted” …

Il problema qui è che sto usando un database gestito che ha un pool di connessioni di 197 che viene rapidamente riempito.

---

_[View the full topic](https://meta.discourse.org/t/self-ddos/388614)._
