On Sat, Oct 21, 2023, 22:57 Achilleas Mantzios <
a.mantz...@cloud.gatewaynet.com> wrote:
> What tools
> would you suggest ? What's your setup ?
I've used reveal.js before and I was pretty happy with it:
https://revealjs.com/
On Tue, Sep 26, 2023, 12:34 Atul Kumar wrote:
> What am I missing here to understand, because as per my understanding
> log_statement and log_min_duration_statement are correlated, postgres
> should log according to log_statement parameter.
>
The two settings are independent. One logs *all* stat
On Fri, Sep 15, 2023, 15:02 Adrian Klaver wrote:
> On 9/15/23 9:55 AM, Martin Mueller wrote:
>
> I am thinking of upgrading from version 13 to version 16.
>
>
>
> I think I can do this by leaving the data alone and just replacing the
> software. My data are extremely simple and consist of severa
On Sun, Sep 3, 2023, 16:25 Amn Ojee Uw wrote:
> Are you saying that JDBC cannot handle or process \gexec, since it is
> PG-15 exclusive?
>
JDBC cannot handle our process \gexec since it is _psql_ exclusive. It's a
command interpreted and evaluated by that client specifically, not by the
Postgres
On Wed, Jul 19, 2023, 22:40 Anthony Apollis
wrote:
> Hi
>
> What list can i post sql related errors etc?
>
This is a good place to start, but you may want to review
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems to make it
easier to get help if you're not already familiar with it.
On Wed, Jul 19, 2023, 17:36 Amn Ojee Uw wrote:
> After this command 'sudo -u postgres psql'
> I get this message :
> *could not change directory to "/home/my_account": Permission denied*
> *psql (12.15 (Debian 12.15-1.pgdg120+1))*
> *Type "help" for help.*
>
> I tried using help, but to no avail.
Thanks, that makes sense. It was going to be my third guess, but it
seemed pretty wide for a TOAST pointer. Reviewing what goes in there,
though, it's reasonable.
I assume that this means for unTOASTed but compressed data, this
counts the compressed size.
Would a doc patch clarifying this (and po
Hello,
The pg_stats.avg_width field is documented [1] as "Average width in
bytes of column's entries" but it's not defined exactly what "entries"
means here with respect to STORAGE (the underlying pg_statistic
documentation doesn't clarify this either). I thought initially this
was the "logical" s
Note that VACUUM FULL and CLUSTER can update ctids. I don't believe regular
VACUUM can, so you should be safe from autovacuum interfering in this
scheme, but the ctid colum documentation [1] states "A primary key should
be used to identify logical rows," so this is not exactly intended usage.
Than
On Thu, Dec 8, 2022 at 2:53 AM David Rowley wrote:
>
> On Thu, 8 Dec 2022 at 19:59, higherone wrote:
> > I know there's a pg_stats_user_indexes that gives statistics about the
> > index scans/fetches, but I don't find any information about how many
> > writes(insert/update/delete) happen on thi
Anything interesting in the Postgres server log when this happens?
On Fri, Oct 15, 2021, 05:21 Nick Renders wrote:
> Hello,
>
> I have been trying to import a Postgres 11 database into Postgres 14,
> but the pg_restore command exits with the following message:
>
> pg_restore: error: coul
Hello,
Does adding a GENERATED STORED column need to rewrite the table (like
adding a column with a DEFAULT before 11)? Neither the ALTER TABLE docs [1]
nor the generated column docs [2] discuss this. The former has a very nice
Tip regarding DEFAULT columns--maybe we should clarify GENERATED STORE
On Thu, Oct 24, 2019 at 2:25 PM Andres Freund wrote:
> Note that the buffer access stats do *not* count the number of distinct
> buffers accessed, but that they purely the number of buffer
> accesses.
You mean, even within a single node? That is, if a node hits a block ten
times, that counts as t
On Wed, Oct 23, 2019 at 12:01 PM Stuart McGraw wrote:
> Why the inconsistency between the array
> type and json type? Are there any cases other than json where the entire
> compound value is set to NULL as a result of one of its components being
> NULL?
That's a great point. It does look like hs
Also, I noticed that in this plan, the root (again, an Aggregate) has 0
Temp Read Blocks, but two of its children (two of the ModifyTable nodes)
have non-zero Temp Read Blocks. Again, this contradicts the documentation,
as these costs are stated to be cumulative. Any ideas?
Thanks,
Maciek
Hello,
I ran across an EXPLAIN plan and had some questions about some of its
details. The BUFFERS docs say
>The number of blocks shown for an upper-level node includes those used by
all its child nodes.
I initially assumed this would be cumulative, but I realized it's probably
not because some o
16 matches
Mail list logo
