ave given us no information
whatsoever)?
cheers
andrew
--
Andrew Dunstan
EDB:https://www.enterprisedb.com
On 2022-11-30 We 11:36, Tom Lane wrote:
> Andres Freund writes:
>> On November 30, 2022 3:47:32 AM PST, Andrew Dunstan
>> wrote:
>>> I think Alvaro's point is that it would have been better to work out
>>> these wrinkles before turning on JIT by defaul
that it would have been better to work out
these wrinkles before turning on JIT by default. Based on anecdotal
reports from the field I'm inclined to agree.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
On 2022-08-21 Su 17:15, Tom Lane wrote:
> Andrew Dunstan writes:
>> On 2022-08-20 Sa 23:20, Tom Lane wrote:
>>> Kevin McKibbin writes:
>>>> What's limiting my DB from allowing more connections?
>> The first question in my mind from the above is wh
Postgres configuration
> settings are at issue at all.
The first question in my mind from the above is where this postgres
instance is actually listening. Is it really /var/run/postgresql? Its
postmaster.pid will tell you. I have often seen client programs pick up
a system libpq which is compiled with a different default socket directory.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
been out of support for nearly 2 years. You should be looking to
upgrade.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
ng I always advise against, as it hurts clarity, but
that's a matter of style rather than performance.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
fy that these fix the issue.
>> > If you already have Postgres installed from our installer you should
>> > be able to upgrade using Stackbuilder. Otherwise, you can download
>> > from our usual download sites.
>> >
>> > cheers
&g
On 9/13/21 4:36 PM, Andrew Dunstan wrote:
> On 9/13/21 11:53 AM, l...@laurent-hasson.com wrote:
>>> -Original Message-
>> > From: Andrew Dunstan
>>> Sent: Monday, September 13, 2021 11:36
>>> To: l...@laurent-hasson.com; Julien
ate
the replica as a physical replica (using pg_basebackup for example), and
then using the extension's utility program pglogical_create_subscriber
to convert the physical replica to a logical replica, which you then
upgrade and switch over to.
Of course, test it out before doing this for real.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
On 9/13/21 11:53 AM, l...@laurent-hasson.com wrote:
>
>> -Original Message-
> > From: Andrew Dunstan
>> Sent: Monday, September 13, 2021 11:36
>> To: l...@laurent-hasson.com; Julien Rouhaud
>> Cc: Tom Lane ; Ranier Vilel
On 9/13/21 10:32 AM, l...@laurent-hasson.com wrote:
>
> Hello all,
>
> Any further update or guidance on this issue at this time?
>
Wait for a new installer. Our team is working on it. As I have
previously advised you, please be patient.
cheers
andrew
--
Andrew Dun
ION WHEN OTHERS THEN
>
> RETURN val;
>
> END;
>
> $$ LANGUAGE plpgsql COST 1 IMMUTABLE;
>
>
>
> I couldn’t find a reference to such capabilities in Postgres and
> wondered if I missed it, and if not, is there any plan to add such a
> feature?
>
>
>
Not
On 9/2/21 11:34 AM, Julien Rouhaud wrote:
> On Thu, Sep 2, 2021 at 11:22 PM Andrew Dunstan wrote:
>> Here are a couple of pictures of profiles made with a tool called
>> sleepy. The bad profile is from release 13.4 built with the latest
>> gettext, built with vcpkg. The goo
ight difference between the versions used in the
11.13 installer and the 13.4 installer. We need to dig into performance
more (e.g. why does the test take much longer on an NLS enabled build
even when we are using 'initdb --no-locale'?) But I'm pretty confident
now that this is t
rlier, I have reproduced
this issue with a vanilla build which has no installer involvement
whatsoever.
I'm pretty sure the reason you are not seeing this with the 2ndQuadrant
installer is quite simple: it wasn't build with NLS support.
Let me repeat what I said earlier. I will get to the bottom of this.
Please be patient and stop running after red herrings.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
On 8/26/21 10:47 AM, l...@laurent-hasson.com wrote:
> Hello all,
>
> Any update on this issue?
Please don't top-post.
We are working on the issue. Please be patient.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
On 8/22/21 5:59 PM, l...@laurent-hasson.com wrote:
>
>> -Original Message-
> > From: Andrew Dunstan
>> Sent: Sunday, August 22, 2021 17:27
>> To: Tom Lane ; l...@laurent-hasson.com
>> Cc: Justin Pryzby ; Ranier Vilela
>&
started in Release 12 is correct,
I should be able to find it by bisecting between the branch point for 12
and the tip of that branch. That's a little over 20 probes by my
calculation.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
On 6/10/21 2:23 PM, Andrew Dunstan wrote:
> On 6/10/21 2:00 PM, Tom Lane wrote:
>> "Dean Gibson (DB Administrator)" writes:
>>> On 2021-06-10 09:54, Ranier Vilela wrote:
>>>> Your cmd lacks =
>>>> =>pg_dumpall -U Admin --exclude-databa
that we use for pg_dump's --exclude-* options, so we need
to check if they have similar issues.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
_dump works OK, but of course you don't get the roles dumped.
> Fortunately, I kept script files that have all the database setup, so
> I just ran them to create all the relationships, & then used the
> pg_dump output. Worked flawlessly.
This was added in release 12 specifically with RDS in mind:
pg_dumpall --exclude-database
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
On 6/6/21 7:49 PM, Dean Gibson (DB Administrator) wrote:
> On 2021-05-29 13:35, Andrew Dunstan wrote:
>> On 5/29/21 3:59 PM, Dean Gibson (DB Administrator) wrote:
>>> Meanwhile, I've been doing some checking. If I remove "CAST(
>>> license_status AS
ever want
to do in my experience. Why not use the substr() function to get the
first character?
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
On 5/28/21 10:27 PM, Jan Wieck wrote:
>
>
> On Fri, May 28, 2021, 17:15 Andrew Dunstan <mailto:and...@dunslane.net>> wrote:
>
>
>
>
> AIUI he did an RDS upgrade. Surely that's not doing a dump/restore? I
> assume you would know better than
gt;> Index Cond: (territory_id =
>> "_GovtRegion".territory_id)
>> Heap Fetches: 1550706
>
> How did you load the database? pg_dump -> psql/pg_restore?
>
> If so, did you perform a VACUUM FREEZE
3.2, followed by the related table & view
> definitions. With one exception, table definitions are from the FCC
> (Federal Communications Commission); the view definitions are my own.
>
>
>
Have you tried reproducing these results outside RDS, say on an EC2
instance running vanilla PostgreSQL?
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
rks about the meaning of this are off topic, thanks
>
>
Postgres provides exactly such a trigger. See
https://www.postgresql.org/docs/12/functions-trigger.html
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
ation is
> running select queries? Is it AUTOVACUUM?
>
Suggest you read this part of The Fine Manual:
<https://www.postgresql.org/docs/current/explicit-locking.html>
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
>
IMNSHO postcodes, zip codes, telephone numbers and the like should never
be numeric under any circumstances. This isn't numeric data (what is the
average postcode?), it's textual data consisting of digits, so they
should always be text/varchar. The index here should just be on the
plain text column, not cast to numeric.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
can also usually be improved. The
default settings are deliberately very conservative.
cheers
andrew
-- Andrew Dunstan EDB: https://www.enterprisedb.com
ctually create such an index if it
doesn't already exist. Maybe we should have a warning when setting up an
FK constraint if the referencing fields aren't usefully indexed.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
ted before
the rest of the query.
So if you haven't already, start by putting MATERIALIZED before each CTE
clause:
with foo as MATERIALIZED (select ...),
bar as MATERIALIZED (select ...),
...
and see if that changes anything.
cheers
andrew
--
Andrew Dun
mi-reliable rule of thumb.
cheers
andrew
--
Andrew Dunstanhttps://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
ngs on a postgres forum at all it belongs on pgsql-general. More
likely, you should be asking in the pgwatch2 forums, not Postgres forums.
cheers
andrew
--
Andrew Dunstanhttps://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
35 matches
Mail list logo
