I was able to pull some stats with pgstattuple and nothing looks
particularly hinky to me.
version: 4
tree_level: 2
index_size: 499589120
root_block_no: 412
internal_pages: 194
leaf_pages: 54572
empty_pages: 0
deleted_pages: 6218
avg_leaf_density: 90.08
leaf_fragmentation: 0.01
For flavor, If I
Meera Nair writes:
> We tried pg_dump write to a pipe with compressed format and faced issue as in
> thread referred here.
> It was on windows client and for postgres 9.2 version. So during pg_restore,
> seek error was seen.
Are you really using PG 9.2.something? If not, then what?
The
> On Dec 1, 2023, at 09:47, Ping Yao wrote:
> Can someone help me understand why my simple DELETE query is so slow to run?
Based on the plan, you're running PostgreSQL with the Citus extension, and the
delay is in Citus-related code. This is probably a question best directed to
either the
Hello All.
First timer here, long time user though. Thank you in advance.
Can someone help me understand why my simple DELETE query is so slow to run?
*System:*
We are running Citus with 4 workers with 256 shards (default), with
replication using pg_autoctl.
*PostgreSQL Version:*
=# select
> On Dec 1, 2023, at 11:02 AM, Tom Lane wrote:
>
> I'd suggest filing a bug against Homebrew's krb5 package.
> Whatever this is, it seems pretty clear that it's not a
> Postgres bug.
Will do, thank you and everyone else for the help and feedback.
John DeSoi, Ph.D.
John DeSoi writes:
>> On Nov 30, 2023, at 7:53 PM, Tom Lane wrote:
>> Ugh, not only Heimdal but a very obsolete version thereof? It borders
>> on negligence for the homebrew PG package to be building against that.
>> They should be pulling in homebrew's MIT Kerberos package and using
>> that,
On 11/30/23 18:57, Meera Nair wrote:
Hi all,
https://www.postgresql.org/message-id/flat/CAKKd065aJ1LuUMw_bhBgmgoM6Ng-cLdBobpzRiU%2BUsdsmW2aOg%40mail.gmail.com#996021734fa788bd1bc737254002ad11
On 12/1/23 01:17, Loles wrote:
Yes, it seems to be caused by systemd.
To be more accurate it is caused by the the file postgresql-generator
located here:
/lib/systemd/system-generators/
That file is installed by the Postgres Debian/Ubuntu package, so it is
the Postgres install that is
On Fri, Dec 1, 2023 at 9:10 AM Meera Nair wrote:
> Hi all,
>
>
> https://www.postgresql.org/message-id/flat/CAKKd065aJ1LuUMw_bhBgmgoM6Ng-cLdBobpzRiU%2BUsdsmW2aOg%40mail.gmail.com#996021734fa788bd1bc737254002ad11
>
> We tried pg_dump write to a pipe with compressed format and faced issue as
> in
> On Nov 30, 2023, at 7:53 PM, Tom Lane wrote:
>
> gssencmode=disable in your connection options; but that's a tad
> inconvenient probably.
Yes, the application uses PHP PDO to connect to PostgreSQL. I don't see any way
to specify that in the connection options.
> Ugh, not only Heimdal but
Hi all,
https://www.postgresql.org/message-id/flat/CAKKd065aJ1LuUMw_bhBgmgoM6Ng-cLdBobpzRiU%2BUsdsmW2aOg%40mail.gmail.com#996021734fa788bd1bc737254002ad11
We tried pg_dump write to a pipe with compressed format and faced issue as in
thread referred here.
It was on windows client and for
Jeff Gerbracht wrote:
> It would be great if there was a way to set exceptions to the 'word'
> delimiter list used in the INITCAP() function.For example, I have
> hyphenated words like blue-green or possessives and contractions like
> don't and cat's tail
> These become Blue-Green,
Yes, it seems to be caused by systemd.
I'll investigate there. If not, I can upgrade PostgreSQL and get rid of
server 14.
Thank you very much Adrian... I'm going to get a cup of coffee because the
topic requires it :D
El vie, 1 dic 2023 a las 6:19, Adrian Klaver ()
escribió:
> On 11/30/23
Hi,
On Thu, 30 Nov 2023 19:07:34 +
Vijaykumar Patil wrote:
> I have two postgres server one is primary and other one replica, I have setup
> replication and configured pacemaker and corosync.
>
> But still I'm facing issue while creating resource. It is showing invalid
> parameters.
>
>
14 matches
Mail list logo