public inbox for [email protected]
help / color / mirror / Atom feedRe: Performance issues during pg_restore -j with big partitioned table
3+ messages / 2 participants
[nested] [flat]
* Re: Performance issues during pg_restore -j with big partitioned table
@ 2025-04-04 15:02 Adrian Klaver <[email protected]>
2025-04-04 15:09 ` Re: Performance issues during pg_restore -j with big partitioned table Dimitrios Apostolou <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Adrian Klaver @ 2025-04-04 15:02 UTC (permalink / raw)
To: Dimitrios Apostolou <[email protected]>; [email protected]
On 4/4/25 06:13, Dimitrios Apostolou wrote:
> On Wed, 2 Apr 2025, Dimitrios Apostolou wrote:
>
> Bug? This happened on a postgres compiled from last week's master branch.
Are you talking about the dev version?
> The dump I'm trying to restore is from postgres 17.4.
>
>
> Thanks
> Dimitris
>
>
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Performance issues during pg_restore -j with big partitioned table
2025-04-04 15:02 Re: Performance issues during pg_restore -j with big partitioned table Adrian Klaver <[email protected]>
@ 2025-04-04 15:09 ` Dimitrios Apostolou <[email protected]>
2025-04-04 15:23 ` Re: Performance issues during pg_restore -j with big partitioned table Adrian Klaver <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Dimitrios Apostolou @ 2025-04-04 15:09 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: [email protected]
On Fri, 4 Apr 2025, Adrian Klaver wrote:
> On 4/4/25 06:13, Dimitrios Apostolou wrote:
>> On Wed, 2 Apr 2025, Dimitrios Apostolou wrote:
>>
>
>> Bug? This happened on a postgres compiled from last week's master branch.
>
> Are you talking about the dev version?
In this thread, yes. My mistake I didn't mention it from the start. I
compiled it in order to see if the problems I mentioned in my previous
thread were fixed.
Dimitris
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Performance issues during pg_restore -j with big partitioned table
2025-04-04 15:02 Re: Performance issues during pg_restore -j with big partitioned table Adrian Klaver <[email protected]>
2025-04-04 15:09 ` Re: Performance issues during pg_restore -j with big partitioned table Dimitrios Apostolou <[email protected]>
@ 2025-04-04 15:23 ` Adrian Klaver <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Adrian Klaver @ 2025-04-04 15:23 UTC (permalink / raw)
To: Dimitrios Apostolou <[email protected]>; +Cc: [email protected]
On 4/4/25 08:09, Dimitrios Apostolou wrote:
> On Fri, 4 Apr 2025, Adrian Klaver wrote:
>
>> On 4/4/25 06:13, Dimitrios Apostolou wrote:
>>> On Wed, 2 Apr 2025, Dimitrios Apostolou wrote:
>>>
>>
>>> Bug? This happened on a postgres compiled from last week's master
>>> branch.
>>
>> Are you talking about the dev version?
>
> In this thread, yes. My mistake I didn't mention it from the start. I
> compiled it in order to see if the problems I mentioned in my previous
> thread were fixed.
Since it still has not established that an actual problem exists in
previous versions, this is premature. Especially as dev has not even
reached alpha AFAIK.
To get at a solution more detailed information is needed. I would also
suggest testing using something less the 1000 large partitions.
Information needed for any given report:
1) Postgres version being dumped from.
2) The complete pg_dump command.
3) The Postgres version being restored to.
4) The complete pg_restore command.
5) The error messages.
Also have you tried a schema only dump/restore?
>
>
> Dimitris
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-04-04 15:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-04 15:02 Re: Performance issues during pg_restore -j with big partitioned table Adrian Klaver <[email protected]>
2025-04-04 15:09 ` Dimitrios Apostolou <[email protected]>
2025-04-04 15:23 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox