On Sat, 19 Oct 2024 at 23:31, Tom Lane wrote:
> "David G. Johnston" writes:
> > On Sat, Oct 19, 2024 at 10:43 AM Vijaykumar Jain <
> > vijaykumarjain.git...@gmail.com> wrote:
> >> i tried to check the code for auto_explain , there is nothing that helps
>
>
>
> I don't have time now to create an example, but I can point you at:
>
>
> https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE
>
> 5.12.2.2. Partition Maintenance
>
> "As an alternative to creating a new partition, it is sometimes more
> convenient to c
but then if a connection
established is logged in the log, then name resolution is ok ?
or the syscall to md5 is slow , does it work faster for trust ? just saying
:)
--
Thanks,
Vijay
Open to work
Resume - Vijaykumar Jain <https://github.com/cabecada>
o issues in the past.
https://unix.stackexchange.com/questions/290987/resolving-hostname-takes-5-seconds
maybe disabling ipv6 completely resolves this for the time being.
--
Thanks,
Vijay
Open to work
Resume - Vijaykumar Jain <https://github.com/cabecada>
missed the mailing list.
On Tue, 29 Oct 2024 at 23:43, Vijaykumar Jain <
vijaykumarjain.git...@gmail.com> wrote:
>
>
> On Tue, 29 Oct 2024 at 22:00, Daniel Westermann (DWE) <
> daniel.westerm...@dbi-services.com> wrote:
>
>> Delays between "connection received" and "c
On Sat, 2 Nov 2024 at 12:50, Ian J Cottee wrote:
> As the previous errors (thankfully) are not showing now I can't really do any
> more debugging but I'll report back on the results of the memtest.
just for the sake of this thread, i wanted to make a mention of
Summary of Errors reported early
t crash even if that is the case, but just asking ...
lastly is it possible to memcheck run on the machine just to ensure no
memory scares ... if this is running on a vm, or bare metal any
hardware errors around that time ?
most likely it looks like a h/w issue, we used to see things like this on
bare metals which only happened occasionally and then frequently till
we moved away from that setup.
also, does it happen only when the optimiser picks a plan involving
parallel workers for a query?
If you set max_parallel_workers_per_gather to 0, to not
parallelize anything , do you still see the issue ?
Just insights, if not useful, pls ignore.
> Best regards
>
>
> Ian Cottee
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
--
Thanks,
Vijay
Open to work
Resume - Vijaykumar Jain <https://github.com/cabecada>
On Wed, Nov 13, 2024, 4:42 PM Achilleas Mantzios - cloud <
a.mantz...@cloud.gatewaynet.com> wrote:
>
> Exactly! In the later versions, security gets more and more refined and
> strengthened. So ppl should think about moving away from "public" , and
> start implementing finer grained schemes of sec
-- Forwarded message -
From: Kaare Rasmussen <>
Hi
A simple question before design.
Would there be performance issues having perhaps a million users, each
having several roles? I could imagine a user would have on average 10-20
roles.
I tried to grant select permissions to 5000
On Wed, Nov 13, 2024, 5:00 PM Vijaykumar Jain <
vijaykumarjain.git...@gmail.com> wrote:
>
>
> On Wed, Nov 13, 2024, 4:42 PM Achilleas Mantzios - cloud <
> a.mantz...@cloud.gatewaynet.com> wrote:
>
>>
>> Exactly! In the later versions, security gets more a
q_tup_read from pg_stat_user_tables where relname =
't';
-[ RECORD 1 ]-+--
relname | t
seq_scan | 8
last_seq_scan | 2024-10-15 19:41:50.931282+00
age | -00:05:14.066944
seq_tup_read | 500
but how do i log this seq scan here for this sq
then validating
constraint to reduce blocking.
But yeah monitoring locks for the statement should give me good enough hint
of what will happen.
Thanks for your reply. It helps.
On Wed, Oct 16, 2024, 1:54 AM Adrian Klaver
wrote:
> On 10/15/24 12:50, Vijaykumar Jain wrote:
> &g
On Sat, 9 Nov 2024 at 23:11, Murthy Nunna wrote:
> I am trying to code bash function and call it from psql. But it is failing.
> How can I get this to work. Creating a separate script instead of a function
> works, but I do not want to do that. I have too many variables to be passed
> back and
https://github.com/google/pg_page_verification
Thanks,
Vijay
Open to work
Resume - Vijaykumar Jain <https://github.com/cabecada>
On Sat, Apr 19, 2025, 9:00 PM Greg Sabino Mullane
wrote:
> On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider
> wrote:
>
>> but i wanted to confirm with so
201 - 215 of 215 matches
Mail list logo
