Le ven. 17 janv. 2025 à 18:12, Franjo Stipanovic a
écrit :
> Thank you, Guillaume, Tom.
>
> In that case, querying pg_stat_user_tables on replica for last_vacuum,
> last_autovacuum, last_analyze, and last_autoanalyze columns makes no sense?
> Those specific columns are not transferred from the ma
"Zacher, Stacy" writes:
> We are having issues getting the pgvector extension to work in a database.
This:
> dbdev=# create extension if not exists vector;
> ERROR: type "vector" already exists
indicates you've got some type named "vector" in that database
already. It didn't come from pgvecto
Hello:
We are having issues getting the pgvector extension to work in a database.
* Installed the code
* Created the extension in a database - it says it already exists but it's
not there:
postgres=# \c dbdev
You are now connected to database "dbdev" as user "postgres".
dbdev=# select
Thank you, Guillaume, Tom.
In that case, querying pg_stat_user_tables on replica for last_vacuum,
last_autovacuum, last_analyze, and last_autoanalyze columns makes no sense?
Those specific columns are not transferred from the master? The same goes
for n_* columns? Currently, on my replica, all tho
Hi,
Le ven. 17 janv. 2025 à 15:38, Franjo Stipanovic a
écrit :
> Question regarding autovacuum settings in a PostgreSQL streaming
> replication setup. Specifically, I am curious about whether it is possible
> (and advisable) to have different values for the following settings on the
> master and
Franjo Stipanovic writes:
> Question regarding autovacuum settings in a PostgreSQL streaming
> replication setup. Specifically, I am curious about whether it is possible
> (and advisable) to have different values for the following settings on the
> master and replica databases:
> - autovacuum_vacu
Kamen Kalchev writes:
> Hi everyone, we're planning to upgrade the OS running Postgres from ubuntu
> jammy to ubuntu noble. As part of the OS change, the glibc version will be
> changed from glibc 2.35 to glibc 2.39..
> Can someone confirm if changing the glibc between those versions will
> requir
You will want to ingest
https://www.joeconway.com/presentations/glibc-PostgresConfSEA-2024.pdf
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
On Fri, Jan 17, 2025 at 1:12 AM Kamen Kalchev wrote:
> Hi everyone, we're planning to upgrade the OS running Postgres from ubuntu
> jammy to ubuntu noble. As part of the OS change, the glibc version will be
> changed from glibc 2.35 to glibc 2.39..
>
> Can someone confirm if changing the glibc be
Question regarding autovacuum settings in a PostgreSQL streaming
replication setup. Specifically, I am curious about whether it is possible
(and advisable) to have different values for the following settings on the
master and replica databases:
- autovacuum_vacuum_scale_factor
- autovacuum_analyze_
10 matches
Mail list logo
