Search Postgresql Archives

Re: How to do faster DML

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to do faster DML
From: Ron Johnson <ronljohnsonjr@xxxxxxxxx>
Date: Sun, 4 Feb 2024 18:15:10 -0500
In-reply-to: <CAKna9VZB09CBVq2eV3ohSMTgXEcOSbUdYnfqzBtLm5qmuU9_dQ@mail.gmail.com>
References: <CAKna9VbS8qeUj1NpzodAxgOEJGp+g0zE9BfEsoGvYgL7Jr+CnQ@mail.gmail.com> <CAKna9VbKVzw_rojHg1wPMhNAh3KZX7Rw-aY6ZOuaqLa3mGqDqw@mail.gmail.com> <CANzqJaAYq+LNYuQijmrP5Zu+QNSO9eMXc2V=fEZme7HZDp5Y3w@mail.gmail.com> <CAKna9VZB09CBVq2eV3ohSMTgXEcOSbUdYnfqzBtLm5qmuU9_dQ@mail.gmail.com>

On Sat, Feb 3, 2024 at 11:09 AM Lok P <loknath.73@xxxxxxxxx> wrote:

[snip]

show maintenance_work_mem; - 4155MB
show work_mem; - 8MB
show shared_buffers ; -22029684

Those are pretty small values. What are your server specs?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- How to do faster DML
  - From: Lok P
- Re: How to do faster DML
  - From: Lok P
- Re: How to do faster DML
  - From: Ron Johnson
- Re: How to do faster DML
  - From: Lok P

Prev by Date: select from composite type
Next by Date: Re: Question on partitioning
Previous by thread: Re: How to do faster DML
Next by thread: Re: How to do faster DML
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux