"Gnanakumar" writes:
> Does PostgreSQL establish working UDP sockets on some specific defined port
> or it chooses the port randomly?
The stats collector socket is opened on whatever port bind() chooses to
assign.
regards, tom lane
--
Sent via pgsql-admin mailing list (
Silvio Brandani wrote:
> we have a performance issue on deleting data from a table.
>
> the delete is on the index key so should be very fast but the table
> have 13 contraints of type foreign keys and the slowness seems due
> to all the works done with the constraint.
> Trying to drop the const
Hi alls,
we have a performance issue on deleting data from a table.
the delete is on the index key so should be very fast but the table
have 13 contraints of type foreign keys and the slowness seems due to
all the works done with the constraint.
Trying to drop the constraint and execute the d
>> Does stats collector process need any other special
>> resource/privilege/operations/port to start?
> If I understand correctly, it uses UDP. I don't think PostgreSQL
> uses UDP outside of that.
Still I'm not able to resolve/fix this statistics collector (not
starting/working) in one of our
