On 2/28/25 17:49, Thomas Munro wrote:
On Sat, Mar 1, 2025 at 9:03 AM Joe Conway wrote:
On 2/28/25 09:16, Laurenz Albe wrote:
> On Thu, 2025-02-27 at 16:54 +0300, Alexey Borschev wrote:
>> I see poor performance of text sorting of collate "en_US.utf8" in PG 17.4.
>
> I&
r using the new builtin
collation provider -- it will perform almost as well as the 'C' locale.
Something like:
CREATE DATABASE builtincoll LOCALE_PROVIDER builtin
BUILTIN_LOCALE 'C.UTF-8' TEMPLATE template0;
--
Joe Conway
PostgreSQL Contributors Team
R
On 10/6/24 14:13, Tom Lane wrote:
Joe Conway writes:
This is not surprising. There is a performance regression that started
in glibc 2.21 with regard to sorting unicode. Test with RHEL 7.x (glibc
2.17) and I bet you will see comparable results to ICU. The best answer
in the long term, IMHO
to sorting unicode. Test with RHEL 7.x (glibc
2.17) and I bet you will see comparable results to ICU. The best answer
in the long term, IMHO, is likely to use the new built-in collation just
released in Postgres 17.
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon W
additional, If someone else has grafana template implemented, please
share with me or some link to do that ,
See:
https://github.com/CrunchyData/pgmonitor
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
ng). As noted in the docs:
This parameter can be changed at any time; the
behavior for any one transaction is determined by
the setting in effect when it commits. It is
therefore possible, and useful, to have some
transactions commit synchronously and others
asynchronously.
--
Joe Conway
R
On 7/27/22 10:46, Tom Lane wrote:
Joe Conway writes:
Then (completely untested) I *think* you could create the "partition"
initially as a free standing unlogged table, load it, index it, switch
to logged, and then attach it to the partitioned table.
I'm still of the opinion
tions into larger buckets to minimize the
overall number of partitions.
--
Joe Conway
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
On 12/8/19 1:14 PM, Lars Aksel Opsahl wrote:
> Do you or anybody know if there are any plans for a function call that
> support the calling structure below or something like it and that then
> could finish in 1 second ? (If you are calling a void function, the
> return value should not be any probl
On 01/18/2018 04:12 AM, Svensson Peter wrote:
> When I then install postgis extension in a database it writes a huge
> amount of logs which slow down the server a lot.
> Not only table creation and functions are logged, even all inserts in
> spatial_ref_sys are written to the audit-log.
>
> LO
10 matches
Mail list logo
