Hi Team,
We are facing an issue with few of the transactions which are running from SAP
end. Below is the case statement.
Issue -: We are seeing that , the session which are generated from SAP report
end to PostgreSQL Database, it starts with the "Open Cursor " Cursor Name "
with Hold - Select
On Thu, 2022-02-24 at 12:48 +, Catalin Maftei wrote:
> on a project I have large tables, with more than 2-5.000.000 rows, and the
> system is starting to be slow,
> This tables have many dependencies functions, procedures and views.
>
> I want to partition this tables.
>
> I think for this
On Thu, 2022-02-24 at 18:16 +0100, Wim Bertels wrote:
> it seems that \set does not interpret an 'enter' interactively the same
> as an 'enter' in a short script made with \e
>
> * case 1:
> postgres=# \set x 1
> postgres=# select :x;
> ?column?
> --
> 1
Ok.
> * case 2:
> post
Hello,
starting with an explanation first... i have some sort of 'cold
backup' system: it rsyncs a postgres dump (size: ~1.5TB) from the main
system (created with 'pg_dump $dbname > db.sql) to the backup system
(10TB hdds in a raid10), and then automatically imports that dump
(psql $dbname < $db.s
