On Wed, Nov 24, 2021 at 10:44:12PM +, Robert Creager wrote:
> I forgot, I had reloaded postgres, but had not re-started our app, so the
> connections wouldn’t have that plan setting on them. Re-doing now.
Are you sure? GUC changes should be applied for existing sessions, right ?
Would you s
I forgot, I had reloaded postgres, but had not re-started our app, so the
connections wouldn’t have that plan setting on them. Re-doing now.
On Nov 24, 2021, at 2:13 PM, Robert Creager
mailto:robe...@spectralogic.com>> wrote:
On Nov 19, 2021, at 11:47 AM, Robert Creager
mailto:robe...@spectr
On Nov 19, 2021, at 11:47 AM, Robert Creager
mailto:robe...@spectralogic.com>> wrote:
On Nov 18, 2021, at 2:42 PM, Tom Lane
mailto:t...@sss.pgh.pa.us>> wrote:
This message originated outside your organization.
Thomas Munro mailto:thomas.mu...@gmail.com>> writes:
This is all guesswork thou
Thanks Thomas! Sorry to say this but ,this was migrated from Oracle to PG
:) and the app team just wants to keep the data type as it is :(
On Wed, Nov 24, 2021 at 5:40 PM Thomas Kellerer wrote:
> aditya desai schrieb am 24.11.2021 um 08:35:
> > Hi Thomas,
> > v_message is of composite data typ
On 11/24/21 13:05, hpc researcher_mspk wrote:
Software/Hardware used:
===
PostgresV14.v
OS: RHELv8.4
Benchmark:HammerDB v4.3
Hardware used: Apple/AMD Ryzen.
RAM size: 256 GB
SSD/HDD: 1TB
CPU(s): 256(0-255)
Thread(s) per core: 2
Core(s) per socket: 64
Socket(s): 2
NU
aditya desai schrieb am 24.11.2021 um 08:31:
> H Michael,
> Please see insert_info function below. Also r_log_message is composite data
> type and it's definition is also given below.
>
> CREATE OR REPLACE FUNCTION insert_info(
> info_array r_log_message[]
> ) RETURNS varchar AS $$
> DECL
aditya desai schrieb am 24.11.2021 um 08:35:
> Hi Thomas,
> v_message is of composite data type r_log_message and it's definition is as
> shown below.
>
> postgres=# \d r_log_message;
> Composite type "public.r_log_message"
> Column | Type | Collation | Nu
Software/Hardware used:
===
PostgresV14.v
OS: RHELv8.4
Benchmark:HammerDB v4.3
Hardware used: Apple/AMD Ryzen.
RAM size: 256 GB
SSD/HDD: 1TB
CPU(s): 256(0-255)
Thread(s) per core: 2
Core(s) per socket: 64
Socket(s): 2
NUMA node(s):8
Command used to count process
