Correction about version:
PostgreSQL 8.3.11
Thanks again!!!
From: Julie Nishimura
Sent: Thursday, May 23, 2019 11:57 PM
To: pgsql-general@lists.postgresql.org; pgsql-general
Subject: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569
of 8
On Wed, May 22, 2019 at 7:55 PM Andres Freund wrote:
> That clearly seems wrong. Could you try build a small reproducer?
Apparently not, I've tried to simulate the same but without any
success, that is n_tup_ins is always correctly set.
However, I've noted that this behavior applies up to februar
On Fri, 24 May 2019 at 19:20, Luca Ferrari wrote:
>
> On Wed, May 22, 2019 at 7:55 PM Andres Freund wrote:
> > That clearly seems wrong. Could you try build a small reproducer?
>
> Apparently not, I've tried to simulate the same but without any
> success, that is n_tup_ins is always correctly set
On Fri, May 24, 2019 at 9:26 AM David Rowley
wrote:
> What does: select stats_Reset from pg_stat_database where datname =
> current_database(); say?
Good guess:
# select stats_reset from pg_stat_database where datname =
current_database();
stats_reset
---
2
On 5/23/19 11:57 PM, Julie Nishimura wrote:
Hello,
We have an issue with fsm_relations utilization reaching 99%, I was able
How are you arriving at the above percentage?
How many tables/indexes do you have in the database(s)?
to vacuum a handful of tables, but it wasn't enough to make a noti
I have been hoping for clearer direction from the community about
specifically btree_gin indexes for low cardinality columns (as well as low
cardinality multi-column indexes). In general there is very little
discussion about this both online and in the docs. Rather, the emphasis
for GIN indexes d
Adrian, this value was set in config file, and alerting comes from monitoring.
Would it be right query to count objects in each database (there are 75 dbs on
this server totaling close to 20 tb):
SELECT
count(1) as object_count
FROM pg_catalog.pg_class c
WHERE c.relkind IN ('r','i')
?
Thanks!
On 5/24/19 10:16 AM, Julie Nishimura wrote:
Adrian, this value was set in config file, and alerting comes from
monitoring.
Yes, but what is the monitoring actually doing to get that value?
Would it be right query to count objects in each database (there are 75
dbs on this server totaling cl
Is there any way in postgresql to have a "snippet" of SQL code which you could
apply to all tables. Something you could add which would ensure that every
table always has a Created, Changed and Deleted column for example. Sort of
like a C include I suppose. Of course if I'm building a DB sche
On 5/24/19 1:15 PM, Ken Lacrosse wrote:
Is there any way in postgresql to have a "snippet" of SQL code which you
could apply to all tables. Something you could add which would ensure
that every table always has a Created, Changed and Deleted column for
example. Sort of like a C include I su
On 5/24/19 11:15 AM, Ken Lacrosse wrote:
Is there any way in postgresql to have a "snippet" of SQL code which you
could apply to all tables. Something you could add which would ensure
that every table always has a Created, Changed and Deleted column for
example. Sort of like a C include I sup
On 5/24/19 1:27 PM, Adrian Klaver wrote:
On 5/24/19 11:15 AM, Ken Lacrosse wrote:
Is there any way in postgresql to have a "snippet" of SQL code which you
could apply to all tables. Something you could add which would ensure
that every table always has a Created, Changed and Deleted column for
On 5/24/19 12:24 PM, Ron wrote:
On 5/24/19 1:27 PM, Adrian Klaver wrote:
On 5/24/19 11:15 AM, Ken Lacrosse wrote:
Is there any way in postgresql to have a "snippet" of SQL code which
you could apply to all tables. Something you could add which would
ensure that every table always has a Created
Thanks guys. VERY informative. I'll be looking at all 3 approaches: INHERITS,
LIKE and Sqitch.
Ken LaCrosse
Senior IT InfoSec and Infrastructure Monitoring Specialist
I.T. | American Recovery Service & Skipbusters
Phone: (800)398-6480 x3758
Email: klacro...@pkwillis.com
www.pkwillis.com
* Visi
14 matches
Mail list logo
