On Fri, 2021-07-09 at 06:35 +1000, Steve Baldwin wrote:
> Hi all,
>
> If I'm seeing instances like this in our logs, what should I look for:
>
> 2021-07-06 22:15:34.702
> UTC,"bcaas_api","bcaas",8124,"10.122.45.33:46386",60e4d5e6.1fbc,222,"COMMIT",2021-07-06
> 22:15:02 UTC,37/0,0,LOG,0,"dur
On Fri, 2021-07-09 at 20:04 +0100, Phil Endecott wrote:
> =# create tablespace tempspace location "/db_temp";
> =# alter table requests set tablespace tempspace;
>
> That didn't work; I think disk space had actually reached zero:
>
> PANIC: could not write to file "pg_wal/xlogtemp.19369": No spa
On Sun, Jul 11, 2021 at 6:06 PM David Rowley wrote:
> select abs(generate_series(-3,-1));
>
> abs() is simply called once per output value of the generate_series
> SRF. That seems fairly equivalent to me to what's going on in your
> example case.
>
>
Fair point. Both of these are premised on tw
At Fri, 9 Jul 2021 10:49:46 -0600, Jeff Ross wrote in
> Hello,
>
> I'm working with an RDS instance running 12 that has an old
> subscription that I can't seem to drop.
...
> It shows up here:
>
> mirror_admin@metro_logical> select * from pg_subscription;
>oid │ subdbid │ subname
On Mon, 12 Jul 2021 at 12:58, David G. Johnston
wrote:
>
> On Sun, Jul 11, 2021 at 5:43 PM David Rowley wrote:
>>
>> Isn't this implied by "Each subscript is itself an expression"?
>> There's nothing special here with the SRF. That just produces 3 rows
>> and passes the subscript as 1, 2 then 3.
On Sun, Jul 11, 2021 at 5:43 PM David Rowley wrote:
> Isn't this implied by "Each subscript is itself an expression"?
> There's nothing special here with the SRF. That just produces 3 rows
> and passes the subscript as 1, 2 then 3.
>
>
One can indeed infer that if the expression chosen for subscr
On Mon, 12 Jul 2021 at 11:52, David G. Johnston
wrote:
> A post over in Reddit had an expression form I've never seen before:
>
> select (array[1,2,3,4]::integer[])[generate_series(1, 3)];
> Looking at subscripting in the SQL syntax this example doesn't seem to be
> documented.
>
> https://www.p
> On Jul 11, 2021, at 5:52 PM, David G. Johnston
> wrote:
>
>
> Hey,
>
> A post over in Reddit had an expression form I've never seen before:
>
> select (array[1,2,3,4]::integer[])[generate_series(1, 3)];
> ===
> 1
> 2
> 3
>
> Looking at subscripting in the SQL syntax this example doesn't
Hey,
A post over in Reddit had an expression form I've never seen before:
select (array[1,2,3,4]::integer[])[generate_series(1, 3)];
===
1
2
3
Looking at subscripting in the SQL syntax this example doesn't seem to be
documented.
https://www.postgresql.org/docs/current/sql-expressions.html#SQL-E
Hi,
during the adoption of Centos 8 on our servers we ran into problems with
Postgresql (13.3), glibc (delivered by the Centos) and performance of
sorting. Because of that we're planning to use the ICU collations
(en-x-icu), but the current implementation is quite complicated to adopt as
there isn
Hi,
Could you suggest me how should I teduce the heap blocks to optimise the
query ?
Regards.
On Thursday, July 8, 2021, Atul Kumar wrote:
> Hi,
>
> I have one query like below :
>
>
> SELECT
> m.iMemberId "memberId",
>
11 matches
Mail list logo
