Hi Manuel
Sorry for the late reply saw this email just today. Anyways how about using
something like?
postgres=# SELECT
postgres-# pg_size_pretty(pg_database_size('postgres')) AS
database_size,
postgres-# pg_size_pretty(pg_total_relation_size('accounts')) AS
table_size,
postgres-# pg_
I've been able to observe that the performance degradation with TRUNCATE
appears to happen when other ancillary processes are running that are also
heavy users of temporary tables. If I used an exclusive tablespace, would
that improve things?
Cheers
Jim
On Wed, 31 Jul 2024 at 19:27, Jim Vanns w
(resending to general since I believe I originally sent it to hackers by
mistake)
I've reached the limit of my understanding and attempts at correcting my
code/use of temporary tables in the face of multixact members and have come
to ask for your help! Here's a brief description of my software;
P
On Wed, Jul 31, 2024 at 9:28 AM Igor Korot wrote:
> Hi, ALL,
> In the https://www.postgresql.org/docs/8.1/libpq.html#LIBPQ-CONNECT
> it gives the "options" parameter", but it doesn't specify what options
> are available.
>
>
You are looking at the 8.1 docs. Don't do that.
Feel free to report ba
Hi, ALL,
In the https://www.postgresql.org/docs/8.1/libpq.html#LIBPQ-CONNECT
it gives the "options" parameter", but it doesn't specify what options
are available.
Could someone please reference this?
I am specifically looking for the "KeepAlive" option...
Thank you.
