Hi,
I am going to upgrade our production database( postgresql 12.10) to postgresql
15.3.
After upgrade to 15.3, Do you have to do re-index?
If I have to do re-index, can I only do re-index on some partitioned tables?
We have a lot of big tables which are partitioned by date, for example, table1
Hi all,
up to version 9.6.22 there was a win32.mak file in the src/interfaces/libpw
folder which could be used to compile a static postgres.lib using nmake. Since
Postgres 10 this file has been removed.
Is it still possilbe to build a static postgres.lib for windows ? And if so,
how do I do it
Hi,
I am trying to understand the evictions statistic in pg_stat_io. I know what
evictions are, so this is not the question.
Given this:
postgres=# select version();
version
--
On Thu, 2023-07-27 at 20:02 +, Hellen Jiang wrote:
> I am going to upgrade our production database( postgresql 12.10) to
> postgresql 15.3.
> After upgrade to 15.3, Do you have to do re-index?
That is not necessary after a PostgreSQL upgrade.
(It may be necessary if you upgrade the operatin
Thank you very much for taking the time to reply to my question.
> The problem is none of the explains you sent match with the description
> above. The last one when you forced the optimizer to go with index scan (SET
> enable_seqscan TO off;) the chosen index seems to be one composed by ms_
Hi, I would like to pgbench the production postgres that is being physical
replicated to a slave. Will I shoot myself in the foot because of the
physical replication if I try pgbench on prodcution postgres.
Thanks
Priess Stefan writes:
> up to version 9.6.22 there was a win32.mak file in the src/interfaces/libpw
> folder which could be used to compile a static postgres.lib using nmake.
> Since Postgres 10 this file has been removed.
Yup. It didn't really work right and there was insufficient interest
in
First of all, my gratitude to Adrian and David for taking the time to
reply to my call for help; a 1k thanks to you kids.
Having stated the above, PostgreSQL provides a default database namely
'postgres'. Taking advantage of this service, I have change the 'psql'
statement to 'psql -d postgre
On 7/27/23 16:45, Adrian Klaver wrote:
On 7/27/23 1:17 PM, Atul Kumar wrote:
Hi,
I have a password Vl=SO*CIz%A83FQF that is working fine like that in the
command prompt but when it is being used in a batch file it is giving me
an error of wrong password, the password is something looks like t
Thanks Tom!
I also need to change the default port from 5433 to 5432 (--with-pgport=5433).
How can I do this using the build.bat toolchain? I don't see the pgport
parameter in the config_default.pl file.
Best,
Stefan
nexus / chili
Stefan Priess
Softwareentwicklung
Tel: +49 6221 18079-10
E-
On 7/28/23 07:26, Priess Stefan wrote:
Thanks Tom!
I also need to change the default port from 5433 to 5432 (--with-pgport=5433).
How can I do this using the build.bat toolchain? I don't see the pgport
parameter in the config_default.pl file.
1) The default port is 5432.
2) Why do you want
On 7/28/23 09:00, Amn Ojee Uw wrote:
First of all, my gratitude to Adrian and David for taking the time to
reply to my call for help; a 1k thanks to you kids.
Having stated the above, PostgreSQL provides a default database namely
'postgres'. Taking advantage of this service, I have change t
On 7/28/23 07:00, Amn Ojee Uw wrote:
First of all, my gratitude to Adrian and David for taking the time to
reply to my call for help; a 1k thanks to you kids.
Having stated the above, PostgreSQL provides a default database namely
'postgres'. Taking advantage of this service, I have change the
On 7/28/23 07:20, Gert Cuykens wrote:
Hi, I would like to pgbench the production postgres that is being physical
replicated to a slave. Will I shoot myself in the foot because of the
physical replication if I try pgbench on prodcution postgres.
Replication or not, why are you running pgbench o
Priess Stefan writes:
> I also need to change the default port from 5433 to 5432
> (--with-pgport=5433). How can I do this using the build.bat toolchain? I
> don't see the pgport parameter in the config_default.pl file.
I don't use MSVC myself, but a quick look at the code suggests that
you wan
Using asynchronous replication. Production is running on a gaming PC at the
moment because it was to slow on a state of the art hypervisor 128 core 1TB
mem and nvme disk server rack... (where de replicated slave is running on)
I would like to know what number this gaming pc is pulling that suppos
231*TB* seems, to me, an unreasonably large number.
On 7/27/23 02:30, kg.postgre...@olympiakos.com wrote:
Hello,
Is there a known issue with temp file reporting? I have a production db
that is reporting 231TB of temp space usage, which can’t be true.
temp_blks_written in pg_stat_statements
On Tue, Jul 18, 2023 at 01:53:23AM +0200, Gert Cuykens wrote:
> Hi, suggest to automatically rename backup_manifest to backup_manifest.old
> like backup_label when postgres start up successfully because it has no use
> anymore for pg_verifybackup after postgres has been started.
Yes, I would agree
Hello,
In my DB I have a large object over 4GB in size.
I need to get its MD5 or SHA256 from within psql query, i.e. without
exporting it to FS first.
“SELECT md5(lo_get(loid));” doesnt work — “large object is too large”.
Is there any other way to do it?
Regards,
Al
19 matches
Mail list logo
