Hi,
I have strange behaviour when EXPLAIN returns parallel execution plan but the
query execution is not parallel. The query looks as
SELECT
plpgsql_function(...parameters…)
FROM table as t
WHERE id=1
UNION ALL
SELECT
plpgsql_functi
I have a Postgresql 10 database with about 300k tables in 23k schemas. I am
trying to upgrade to Postgresql 13 using pg_upgradecluster. This is failing
while attempting dump all the schemas:
pg_dump: error: query failed: ERROR: out of shared memory
HINT: You might need to increase max_locks_per_
‐‐‐ Original Message ‐‐‐
On Monday, November 30, 2020 12:36 PM, Laurenz Albe
wrote:
> On Mon, 2020-11-30 at 12:05 +, Laura Smith wrote:
>
> > How have others approached the problem of storing and querying filesystem
> > paths ?
> > I'm talking about *nix/*nux style paths, e.g. /home
I want to set up a large table on postgresql 12.4, using declarative
partitioning to partition by record creation date. I'd like to have recent
records in small partitions but old records in a few larger partitions, so
I want merges. The merges should be concurrent, in the sense that they lock
out
Le 30/11/2020 à 06:11, Muthukumar.GK a écrit :
HiTeam,
We need to migrate tables,Records,Procedure and function from SQL
server to Postgresql. Kindly let me know, Is there any tool or
easiest way available to migrate from SQL Server to Postgresql.
Please let me know if there are any limita
On Mon, 2020-11-30 at 12:05 +, Laura Smith wrote:
> How have others approached the problem of storing and querying filesystem
> paths ?
> I'm talking about *nix/*nux style paths, e.g. /home/foo/bar
> A text column with a GIN index is an obvious possibility, but I'm interested
> to hear what a
Hi,
How have others approached the problem of storing and querying filesystem paths
?
I'm talking about *nix/*nux style paths, e.g. /home/foo/bar
A text column with a GIN index is an obvious possibility, but I'm interested to
hear what approach others have taken ?
Laura
Am Mon, Nov 30, 2020 at 10:11:38AM + schrieb Dirk Mika:
> > Or views in schemas per locale. Selecting the search path
> > per locale pulls in the right view.
>
> And one view per locale would mean that I would have to
> create a whole schema including all views for each locale I
> want to supp
> > pá 20. 11. 2020 v 15:28 odesílatel Dirk Mika
> > napsal:
> >
> > > Let's assume there is an app that accesses the same database from
> > > different countries. And in this app data should be displayed ordered. And
> > > the sort order is not identical in all countries.
> > >
> > > Does the ap
