Yoni Sade schrieb am 21.01.2024 um 19:07:
> It would be useful to have the ability to define for a role default
> vCPU affinity limits/thread priority settings so that more active
> sessions could coexist similar to MySQL resource groups
>
Alfredo Alcala schrieb am 23.06.2023 um 11:30:
> I need to move some databases from a MySQL server to Postgresql.
>
> Can someone tell me the migration procedure, tools, and recommendations?
Despite its name, "ora2pg" can also migrate MySQL to Postgres
https://ora2pg.darold.net/
Tomas Vondra schrieb am 07.06.2023 um 21:20:
Also, which other projects did this transition? Is there something we
could learn from them? Were they restricted to much smaller list of
platforms?
Firebird did this a while ago if I'm not mistaken.
Not open source, but Oracle was historically
Pavel Stehule schrieb am 24.11.2022 um 07:03:
> There are many Oracle users that find global indexes useful despite
> their disadvantages.
>
> I have seen this mostly when the goal was to get the benefits of
> partition pruning at runtime which turned the full table scan (=Seq
Tom Lane schrieb am 18.11.2022 um 16:06:
Do we need new syntax actually? I think that a global unique index
can be created automatically instead of raising an error "unique
constraint on partitioned table must include all partitioning
columns"
I'm not convinced that we want this feature at
David G. Johnston schrieb am 27.07.2022 um 21:21:
And then there is the issue of file ownership.
Assuming we want better documentation for this specific issue for
back-patching what would that look like?
Going forward should our installer be creating the postgres user for
consistency with
Joel Jacobson schrieb am 05.05.2021 um 17:30:
> Could it be an idea to exploit the fact that DELIMITER E'\n' is currently an
> error?
>
> ERROR: COPY delimiter cannot be newline or carriage return
>
> That is, to change E'\n' to be a valid delimiter, which would simply read
> each line
>
Michael Paquier schrieb am 05.03.2021 um 08:38:
> On Fri, Mar 05, 2021 at 12:32:43AM -0700, bchen90 wrote:
>> NVD link:
>>
>> https://nvd.nist.gov/vuln/detail/CVE-2021-20229#vulnCurrentDescriptionTitle
>
> This link includes incorrect information. CVE-2021-20229 is only a
> problem in 13.0 and
Andrey Borodin schrieb am 22.01.2021 um 08:32:
> Replication is running under superuser and e.g. one can add system catalog to
> subscription.
> Or exploit this fact other way. Having superuser you can just COPY FROM
> PROGRAM anything.
It was my understanding that the replication process
Alexander Korotkov schrieb am 20.01.2021 um 18:13:
> We have a bug report which says that jsonpath ** operator behaves strangely
> in the lax mode [1].
That report was from me ;)
Thanks for looking into it.
> At first sight, we may just say that lax mode just sucks and
> counter-intuitive
Stephen Frost schrieb am 02.12.2020 um 18:58:
> We should either remove it, or remove the comments that it's deprecated,
> not try to make it more deprecated or try to somehow increase the
> recommendation to not use it.
(I am writing from a "user only" perspective, not a developer)
I don't see
ROS Didier schrieb am 24.11.2020 um 09:09:
> I would like to know if it is possible to migrate Oracle multitenant
> database (with multiple PDB) to PostgreSQL ?
Postgres' databases are very similar to Oracle's PDBs.
Probably the biggest difference is, that you can't shutdown
a single database
Andy Fan schrieb am 28.09.2020 um 02:54:
> Well, that's very interesting. Specific to my user case,
> SELECT * FROM p WHERE pkey = to_date('2018-12-13', '-mm-dd)';
Why use to_date() at all for a constant value?
Can't you use a standard ANSI date literal (date '2018-12-13')?
Alternatively,
Magnus Hagander schrieb am 18.08.2020 um 11:38:
> It might be a slightly larger percentage on Windows who use it, but
> I'm willing to bet it's still quite low.
I have seen increasingly more questions around ICU collations on Windows due to
the fact that people that migrate from SQL Server to
Jaime Casanova schrieb am 11.08.2020 um 20:39:
As a follow-up to bug #16570 [1] and other previous discussions
on the mailing-lists, I'm checking out PG13 beta for Windows
from:
https://www.enterprisedb.com/postgresql-early-experience
and it ships with the same obsolete ICU 53 that was used
Dave Page schrieb am 04.08.2020 um 10:06:
> Correct - updating ICU would mean a reindex is required following any
> upgrade, major or minor.
>
> I would really like to find an acceptable solution to this however as
> it really would be good to be able to update ICU.
>
What about providing a newer
Konstantin Knizhnik schrieb am 05.07.2020 um 19:31:
I am surprised that you are saying you didn't feel big interest. My
reading of the thread is the opposite, that there was quite some
interest, but that there are technical challenges to overcome. So you
gave up on that work?
No, I have not
Fabien COELHO schrieb am 24.06.2020 um 14:18:
> I would like to create an "all defaults" row, i.e. a row composed of the
> default values for all attributes, so I wrote:
>
> INSERT INTO t() VALUES ();
>
> This is forbidden by postgres, and also sqlite.
>
> Is there any good reason why this
Surafel Temesgen schrieb am 23.06.2020 um 13:59:
>> Did you try the xmltable function?
>
> yes i know it but i am proposing changing given xml data in to
> relational form and insert it to desired table at once
Well, xmltable() does change the XML data to a relational form and
the result can
ROS Didier schrieb am 11.02.2020 um 11:23:
> In the Oracle world we use the product "golden gate" to execute
> transactions from a source database (Oracle, Mysql) to a PostgreSQL
> instance.
>
> This allows 2 Oracle and PostgreSQL databases to be updated at the
> same time in real time.
>
> I
Tom Lane schrieb am 22.01.2020 um 16:05:
> Craig Ringer writes:
>> So I don't really see the point of doing anything with 2PC xacts
>> within Pg proper. It's the job of the app that prepares the 2PC xacts,
>> and if that app is unable to resolve them for some reason there's no
>>
> First and foremost is to define what an orphaned transaction is. At
> this stage, I believe any prepared transaction that has been there
> for more than X time may be considered as an orphan. X may be defined
> as an integer in seconds (a GUC perhaps). May be there are better
> ways to define
Tom Lane schrieb am 13.01.2020 um 15:19:
> what it is is attaching DISTINCT to a window function itself.
> I'd still ask whether it's well-defined though, or even minimally
> sensible. Window functions are generally supposed to produce one
> row per input row --- how does that square with the
Merlin Moncure schrieb am 28.08.2019 um 18:22:
My test case here is the query: pgsql-hackers
That search term is the first hit on DuckDuckGo:
https://duckduckgo.com/?q=pgsql-hackers+ExecHashJoinNewBatch=h_=web
Searching for "postgres ExecHashJoinNewBatch" returns that ot position 4
ROS Didier schrieb am 27.08.2019 um 12:47:
> In my business, one of the things blocking the migration from Oracle
> to PostgreSQL is not having the equivalent of Oracle Real Application
> Testing .
>
> This product captures a charge in production and replay it in a test
> environment.
>
> this
Donald Shtjefni schrieb am 31.05.2019 um 13:35:
> I was wondering why there is not a type Range of time without time zone, I
> think it may be useful for someone, Is good if i do PR.
you can easily create one:
create type timerange as range (subtype = time);
Thomas
Tom Lane schrieb am 12.02.2019 um 17:12:
Yeah, see 527b5ed1a et al.
The part about having a unified release-note archive somewhere else is
still WIP. The ball is in the web team's court on that, I think.
The Bucardo team has already done that:
https://bucardo.org/postgres_all_versions.html
>> I have a access to too old 11.2 Oracle. There I had to modify query
>> because there is not boolean type. I replaced bool by int, but I got a
>> error
>> ORA-19224:XPTY-004 .. expected node()*, got xs:string - it doesn't work
>> with/without string() wrappings.
>>
>The problem is in last line
> This proposal is about recording additional statisticsofwait
events.
> The pg_stat_activity view is very useful in analysis for performance
> issues.
> But it is difficult to get information of wait events in detail,
> when you need to deep dive into analysis of performance.
> It is because
> Please cite actual instances of such reports. Vague queries like this help
nobody.
There were several questions on SO
https://stackoverflow.com/questions/49815460
https://stackoverflow.com/questions/47499766
https://stackoverflow.com/questions/47741077
30 matches
Mail list logo