Anders Kildemand ezt írta (időpont: 2023. okt. 26., Cs,
14:38):
> What's the situation with Property Graph Queries in Postgres?
>
If the underlying question is how to utilize graph database functionality
in PostgreSQL, there are similar extensions that may be worth exploring:
- Apache AGE is a P
Michael Corey ezt írta (időpont: 2023.
szept. 20., Sze, 20:48):
> ... All of the DDL is just the setup for the test case. I ran those steps
> in both databases to setup the exact same environment. The COMMIT is not
> needed for the test out of habit I put it in my setup. The main issue is
> in
> But how is that corruption happening - I mean it is a docker image,
> freshly fetched from the registry.
Hi Torsten,
Maybe you have to increase the "*--stop-timeout" value ; ( or
"*stop_grace_period"
in docker-compose )
https://github.com/docker-library/postgres/issues/544#issuecomment-455738
>
> No we want to generate murmur3 format only.
>
If you need a server-side murmur3 function
- one alternative is the https://github.com/markokr/pghashlib extension.
psql (15.2 (Debian 15.2-2))
Type "help" for help.
db=# create extension hashlib;
CREATE EXTENSION
db=#
select hash_string('', 'm
Hi,
Theory: Maybe the search doesn't always work ...
Is this a known problem?
My use case:
in https://www.postgresql.org/list/ -> "Search the Archives"
search for the "large database backup"
->
https://www.postgresql.org/search/?m=1&q=large+database+backup&l=&d=365&s=r
-> "Your search for large
> if the above product is affected by the CVE
You will find the "Known PostgreSQL Security Vulnerabilities in Supported
Versions"
here: https://www.postgresql.org/support/security/
For the PostgreSQL JDBC Driver:
please check https://jdbc.postgresql.org/security/
or the fixed CVE lists:
https://g
> ERROR: could not find function "pl_profiler_enable" in file
maybe obsolete function?
-- Drop obsolete function
DROP FUNCTION pl_profiler_enable(bool);
https://github.com/bigsql/plprofiler/blob/master/plprofiler--3.5--4.0.sql
Regards,
Imre
shashidhar Reddy ezt írta (időpont: 2022.
okt. 29.,
> Ran analyze on both. Running the same query I'm getting different plans,
one x10 slower.
theory:
the "statistics target" is too low ?
THEN
different random sample --> different statistics ---> different plan,.
*"For large tables, ANALYZE takes a random sample of the table contents,
rather tha
_MakeValid enhancements )
And "Bookworm" Debian12 expected >= mid-2023.
so not easy ...
Imre
David G. Johnston ezt írta (időpont: 2022.
júl. 20., Sze, 18:31):
> On Wed, Jul 20, 2022 at 9:21 AM Imre Samu wrote:
>
>> > My general impression is that the packaging, at
> My general impression is that the packaging, at least for Debian,
> doesn’t actually understand how the PostGIS project handles versioning
support.
> But i may be missing something
"PostGIS Pre-built Binary Distributions for various OS"
---> https://trac.osgeo.org/postgis/wiki/UsersWikiPackages
rg/list/pgsql-pkg-debian/
Regards,
Imre
Marc Millas ezt írta (időpont: 2022. júl. 19., K,
20:20):
> Hi,
>
> from your message, I understand that for debian 11, I can NOT get any
> 3.0.x version.
> right ?
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mok
> I would like to install postgis 3.04 on a debian 11
> postgres 12.
> I may use whatever repo.
> I install postgres from postgresql.org...
As I see - from the official postgresql.org debian11 repo,
you can only install the "postgresql-12-postgis-3" package ( now:
Postgis=3.2.1 )
docker run -it
>From the original post
"-This whole system will uphold any precision, certainly ones within a very
large range limit, controlled by the already available type for large
positive integers, the BIGINT. It can thereby enumerate digits within the
range of
(+/-)1 to (+/-)9,223,372,036,854,775,807. This
> According to the apt list for PostgreSQL there is nothing for the s390
system for version 13 and 14.
Multiple postgres docker images exist for "OS/ARCH=linux/s390x"
- "postgres:14.3-bullseye"( debian )
- "postgres:15beta1-bullseye" ( debian )
- "postgres:15beta1-alpine3.16" ( alpine )
-
st=0.00..3.00 rows=1 width=0)
(actual time=0.026..0.027 rows=1 loops=1)
|
| *Index Cond: (jsonb_path_query_array(jsonb_col,
'$."employee".*."date_of_birth"'::jsonpath, '{}'::jsonb, false) @>
to_jsonb('1971-02-02'::text))* |
| P
Hi Shaheed,
> WHAT GOES HERE
imho check the: *jsonb_path_query_array( jsonb_col,
'$.employee.*.date_of_birth' ) *
may example:
CREATE TABLE jsonb_table (
id serial primary key,
jsonb_col JSONB
);
INSERT INTO jsonb_table(jsonb_col)
VALUES
('{"stuff": {},"employee": {"8011": {"date_
> Give me a couple million bucks, and I’ll hire some of the Postgres devs
to build a new database.
> We could crib some of the low-level code from Postgres, but everything
above the low level would need to be rewritten.
You can check the EdgeDB experiments:https://www.edgedb.com/
*"What is Edg
> Question: are there other ways to give PostgreSQL a hint
What you your pg version?
Maybe with pg_hint_plan extension ( https://github.com/ossc-db/pg_hint_plan
)
"pg_hint_plan makes it possible to tweak PostgreSQL execution plans using
so-called "hints" in SQL comments, like /*+ SeqScan(a) */."
> We face in a PostgreSQL 11.4 installation on a potent Linux host a
> ...
> Why is this (ignoring the Index) and what could be done?
IMHO: 11.4 is very old. ( Release date: 2019-06-20 ) and missing a lot of
patches.
The latest patch release is 11.14 ( see
https://www.postgresql.org/docs/11/rele
> Have checked select * from pg_hba_file_rules results are consistent with
pg_hba.conf
> any ip and user still can login in db
Any proxy? port/ip - forwarding running in the background?
in the next time check the "client_addr".
- SELECT usename, client_addr FROM pg_stat_activity where client_ad
> ... I have about 2 million images ...
> folder structure
The "Who's On First" gazetteer with ~ 26M geojson records - using 3-number
chunks subfolder structure.
"Given a Who's On First ID its (relative) URI can be derived by splitting
the ID in to 3-number chunks representing nested subdirectori
Hi Dmitry,
pg12:
> Execution Time: 44.123 ms
pg14:
> JIT:
> Functions: 167
> Options: Inlining true, Optimization true, Expressions true, Deforming
true
> Timing: Generation 9.468 ms, Inlining 55.237 ms, Optimization 507.548
ms, Emission 347.932 ms, Total 920.185 ms
> Execution Time: 963.25
> Phoronix has some very useful benchmarks:
>
https://www.phoronix.com/scan.php?page=news_item&px=Linux-5.14-File-Systems
> Ext4 is much better than XFS with SQLite tests and almost equal with
> MariaDB test. PostgreSQL is a relational database (let's forget the
> object part for now) and the IO pa
Hi Mubashir,
> ... researching on using databases to implement network control
infrastructure. ...
> Are there any postgres extensions/features that implement conditional
tables
like this?
https://dl.acm.org/doi/10.1145/3472716.3472848 "Sarasate: a strong
representation system for networking
> it killed my 200+ days uptime FreeBSD box :( .
> As I describe above, those attachments are nowhere as files.
> They are email attachments. Also we got about half TB of them.
it is possible - that some image is a "decompression bomb" ?
*"Because of the efficient compression method used in Port
> 3. What is the status of making the internal parser of PostgreSQL less
coupled to the core, and easier to cherry-pick from outside?
imho:
One of the current solutions is: https://github.com/lfittl/libpg_query C
library
"C library for accessing the PostgreSQL parser outside of the server.
Th
> uuid character varying(45) NOT NULL,
Just a comment.
IF this is a real UUID ( RFC 4122, ISO/IEC 9834-8:2005 ) ;
THEN you can use the built in "UUID Type"
https://www.postgresql.org/docs/11/datatype-uuid.html
*"UUID would be the fastest because its 128 bits -> 16 bytes and
comparisons are don
>I would like to import (lots of) Apache parquet files to a PostgreSQL 11
cluster
imho: You have to check and test the Parquet FDW ( Parquet File Wrapper )
- https://github.com/adjust/parquet_fdw
Imre
Softwarelimits ezt írta (időpont: 2019. nov. 5.,
K, 15:57):
> Hi, I need to come and ask h
Hi,
Maybe - you can re-use this backup tricks.
"Speeding up dump/restore process"
https://www.depesz.com/2009/09/19/speeding-up-dumprestore-process/
for example:
"""
*Idea was: All these tables had primary key based on serial. We could
easily get min and max value of the primary key column, and
from the original article:
> For example, the PostgreSQL speeds depend on the Django ORM code
> that makes the SQL and sends the query and then turns it into the model
instance.
> I don't know what the proportions are between that and
> the actual bytes-from-PG's-disk times. But I'm not sure I care
> We have upgraded our database from 9.6 to 11
This is now the latest PG ? PG11.5?
( for example - in PG11.5 fixed: * "Fix failure to resolve deadlocks
involving multiple parallel worker processes"*
https://www.postgresql.org/docs/current/release-11-5.html )
> populated by the osm2pgsql program
> because of specs of blockchain component.
Based on this schema (
https://grisha.org/blog/2017/12/15/blockchain-and-postgres/ AND
https://github.com/blkchain/pg_blkchain )
and
IF (your) blockchain component is using BYTEA everywhere ( binary data
type : https://www.postgresql.org/docs/9.6/dat
> origin_metro | character varying(5)| | |
> destination_metro | character varying(5)| | |
> Partition key: LIST (month_day)
>
>
>
> On Wed, Jul 24, 2019 at 5:16 AM Imre Samu wrote:
>
>> >*Can we know why this is happening?*
>*Can we know why this is happening?*
Please give us - more info about your system:
- PG version?
- number of partitions?
- any other important?
for example - in PG 11.2 Changes:
"Improve planning speed for large inheritance or partitioning table groups
(Amit Langote, Etsuro Fujita)"
https://www.
> I am working on postgres database version 9.3
> ...and now my running database become hacked by someone.
imho:
The 9.3 version is End of Life (EoL) ;
Final Release:9.3.25 (November 8, 2018)
https://www.postgresql.org/support/versioning/
Please upgrade for newer versions ( with the latest
> is there any reason why I am getting worse results using pgsql11.2 in
writing comparing it with pgsql 10.6?
>... And Yes both are compiled.
Why 10.6?
according to release notes
"14th February 2019: PostgreSQL 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21
Released!" https://www.postgresql.org/about/ne
> Is there any other repository with the last version of postgresql-10
armhf packages ?
Postgre Docker images (alpine based)
-arm32v5:https://hub.docker.com/r/arm32v5/postgres/
- arm32v6: https://hub.docker.com/r/arm32v6/postgres/ (for Raspberry PI
1 )
- arm32v7: https://hub.docker.com/
> Is there a table definition script available that is widely used for
TPC-H in Postgresql to get results that can be compared?
There are multiple "PostgreSQL + TCP-H" projects on the github -
Maybe you can reuse some ideas ...
https://github.com/search?q=%22TPC-H%22+postgresql&type=Repositories
38 matches
Mail list logo
