On 4/1/22 20:34, Shaozhong SHI wrote:
I have a script running to iterate over 4-5 million rows. It keeps
showing up in red in PgAdmin. It remains active.
How long does iteration over 4-5 million rows usually take?
What /*exactly*/ are you doing?
--
Angular momentum makes the world go 'r
On 4/1/22 18:34, Shaozhong SHI wrote:
I have a script running to iterate over 4-5 million rows. It keeps
showing up in red in PgAdmin. It remains active.
How long does iteration over 4-5 million rows usually take?
Given that there is no real information provided in the problem
descriptio
I have a script running to iterate over 4-5 million rows. It keeps showing
up in red in PgAdmin. It remains active.
How long does iteration over 4-5 million rows usually take?
Regards,
David
If you get a chance, showing the `top` output might be useful as well. For
instance if you are low on memory, it can slow down the allocation of
buffers. Another thing to look at is `iostat -x -y` and look at disk util
%. This is an indicator, but not definitive, of how much disk access is
going
On 3/31/22 23:48, Daniele Varrazzo wrote:
On 3/31/22 18:22, Daniele Varrazzo wrote:
Are arm packages available at all? If so, what is the right procedure
to install them?
On Fri, 1 Apr 2022 at 06:07, Adrian Klaver wrote:
From here:
https://apt.postgresql.org/pub/repos/apt/dists/
I see t
Hello,
I've found in our server ( PostgreSQL 13.5 on x86_64-pc-linux-gnu, compiled
by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit ) following error:
2022-03-31 09:29:58 CEST [15490]: [1-1]
user=app,db=main,host=192.168.1.231,app=[unknown] ERROR: could not access
status of transaction 302
On Fri, Apr 1, 2022 at 5:08 PM Daniele Varrazzo
wrote:
> On Fri, 1 Apr 2022 at 17:00, Magnus Hagander wrote:
> >
> > On Fri, Apr 1, 2022 at 4:52 PM Daniele Varrazzo <
> daniele.varra...@gmail.com> wrote:
> >>
> >> On Fri, 1 Apr 2022 at 16:28, Magnus Hagander
> wrote:
> >>
> >> > Stretch also go
On Fri, 1 Apr 2022 at 17:00, Magnus Hagander wrote:
>
> On Fri, Apr 1, 2022 at 4:52 PM Daniele Varrazzo
> wrote:
>>
>> On Fri, 1 Apr 2022 at 16:28, Magnus Hagander wrote:
>>
>> > Stretch also goes end of life on June 30 2022, so just a few months away.
>> > You definitely shouldn't be using th
On Fri, Apr 1, 2022 at 4:52 PM Daniele Varrazzo
wrote:
> On Fri, 1 Apr 2022 at 16:28, Magnus Hagander wrote:
>
> > Stretch also goes end of life on June 30 2022, so just a few months
> away. You definitely shouldn't be using that.
>
> The platform is part of the Python binary packages build chai
On Fri, 1 Apr 2022 at 16:28, Magnus Hagander wrote:
> Stretch also goes end of life on June 30 2022, so just a few months away. You
> definitely shouldn't be using that.
The platform is part of the Python binary packages build chain; they
are purposely on the old side of the spectrum in order t
On Fri, Apr 1, 2022 at 8:48 AM Daniele Varrazzo
wrote:
> > On 3/31/22 18:22, Daniele Varrazzo wrote:
> > > Are arm packages available at all? If so, what is the right procedure
> > > to install them?
>
> On Fri, 1 Apr 2022 at 06:07, Adrian Klaver
> wrote:
> >
> > From here:
> >
> > https://apt.
Re: hubert depesz lubaczewski
> Soo... plot thickens.
>
> Looks that pg 12 supplied by pgdg required libllvm9:
>
> =$ apt-cache show postgresql-12 | grep -E '^(Package|Version|Depends):'
> Package: postgresql-12
> Version: 12.9-2.pgdg20.04+1
> Depends: ..., libllvm9 (>= 1:9~svn298832-1~), ...
>
On Thu, 2022-03-31 at 15:20 -0400, Digimer wrote:
> I've been looking up locking, and perhaps I'm being dense, but I'm struggling
> to figure out
> how to create a lock to make a table read-only for a short period of time.
> I want to set a table to be read-only, so that any other clients that tr
13 matches
Mail list logo
