2
That question is too broad, but here are some pointers about configuring autovacuum:
For tables that receive bulk inserts, run an explicit VACUUM afterwards or use PostgreSQL v13.
For tables with many updates, a fillfactor of 70 to 90 (depending on row size) is a good thing if no updated column...
There is a document on the internet that discusses AUTOVACUUM in PostgreSQL on RDS titled: Understanding autovacuum in Amazon RDS for PostgreSQL environments
In particular ....
Autovacuum is a daemon that automates the execution of VACUUM and ANALYZE (to gather statistics) commands. Autovacuum c...
I answered this question using a method that looked ok and solved the user's problem. But later a more experienced user added a comment showing a method that is the solution "by design" and looks more professional. With his authorization I improved my answer with that method and removed mine (see...
Today I ran across this question, which I think is a pretty good example of a situation where a full answer may not be warranted. It was a bit messy in the original edit, but there was a correct (if incredibly trivial) answer available to respond with. So...
Is the comment-only answer ever const...
As a thank you for being awesome, if you are on page 1 or page 2 of …
https://dba.stackexchange.com/users?tab=reputation&filter=all
… we'll be sending you a little care package shortly:
Database Administrators t-shirt in your size
Database Administrators die-cut, vinyl stickers
Stack Exchange...
I need to log the below attributes at a new table when any user or application contact and query anything in the SQL server.
Remote Machine Name.
Remote Machine IP.
Server Name OR IP connected.
Action Date.
Type of Access.
The username - used for login.
DB Name connected.
Queries executed.
I tr...
With SQLAudit you cannot track HostName or IP address.
However, there's an alternative method for auditing, based on streaming extended events. I blogged about it earlier this year.
Basically, you treat locks acquired as indicators of the operations being performed on the tables (shared locks ...
I have a table where every entry is a node and the table contains the direct connections of each node to other nodes. I am looking to create a view with a column for each node containing all the nodes in the chain, not just the nodes the node itself is connected to.
An example would be generating...
I applied this logic:
Each connection is included in other connection but itself.
SELECT
e1.node,
e1.connections,
COALESCE(e2.connections, e1.connections)
FROM
example e1
LEFT JOIN
example e2
ON e2.node <> e1.node
AND e1.connections <@ e2.connections;
node | conn...
Is it possible to create some sort of chain of grouping in Postgres? Let's say I have the following chart:
CREATE TABLE foo AS
SELECT row_number() OVER () AS id, *
FROM ( VALUES
( 'X', 'D', 'G', 'P' ),
( 'F', 'D', 'L', 'M' ),
( 'X', 'N', 'R', 'S' ),
( 'Y', 'I', 'W', NULL ),
( 'U', 'Z',...
Something like this?:
CREATE VIEW MyUnion AS
SELECT
a, b, c,
d,
CAST(NULL AS varchar(32)) AS e
FROM table_1
UNION ALL
SELECT
a, b, c,
CAST(NULL AS bigint) AS d,
e
FROM table_2 ;
