Any plan for minor release?

Hello, is there any plan for another minor release? I'm facing troubles with some queries on PostgreSQL 17 and 16 blocking upgrades causing "wrong varnullingrels" error. Per our conversation in CSPUG (Czech language, https://groups.google.com/g/postgresql-cz/c/_jah9d1U1R8/m/HBJszs-2AwAJ) we have f

Re: Load a csv or a avro?

pá 5. 7. 2024 v 11:08 odesílatel sud napsal: > > Hello all, > > Its postgres database. We have option of getting files in csv and/or in avro > format messages from another system to load it into our postgres database. > The volume will be 300million messages per day across many files in batches.

Re: stop

ne 14. 5. 2023 v 17:49 odesílatel Ron napsal: > > On 5/14/23 10:36, Tom Lane wrote: > [snip] > > Another way is to visit the > > List-Unsubscribe: link that appears in the headers of every mail sent > > out by the postgresql mail list servers. > > That requires knowing about a feature which requir

Re: Different execution plan between PostgreSQL 8.4 and 12.11

út 11. 10. 2022 v 11:17 odesílatel gzh napsal: > > Thank you for all your assistance. > > > By communicating with my customer, we have adopted the following solution to > fix the problem. > > > set enable_seqscan = off > This can make some queries fail since there will be no way to gather data wi

Re: Postgres calendar?

út 4. 10. 2022 v 23:02 odesílatel Bruce Momjian napsal: > > Would people be interesting in subscribing to a Postgres calendar that > includes dates for minor releases, final minor release dates for major > versions, commit fests, and even Postgres events? For example, it could > include informati

Re: Database designs

ls/martin/index.htm. > > On Jul 8, 2022, at 6:55 PM, Josef Šimánek wrote: > > > > so 9. 7. 2022 v 0:53 odesílatel Pete Yunker > > napsal: > >> > >> Zahid, > >> > >> This appears to be the most recently archived version. All of th

Re: Database designs

so 9. 7. 2022 v 0:53 odesílatel Pete Yunker napsal: > > Zahid, > > This appears to be the most recently archived version. All of the links on > the page work. > > https://web.archive.org/web/2021070100*/http://databaseanswers.org/data_models/index_all_models.htm I have checked that as well,

Re: PSQL bug?

čt 17. 3. 2022 v 12:06 odesílatel Dominique Devienne napsal: > > On Thu, Mar 17, 2022 at 11:38 AM Pavel Stehule > wrote: > >> Made a typo, [...], and got disconnected. Normal? --DD > > I don't see any problem on master > > OK, good. Must have been fixed already then. Or was a fluke. Thanks > for

Re: what is the solution like oracle DB's datafile

ne 30. 1. 2022 v 18:13 odesílatel Yudianto Prasetyo napsal: > > Hello, > > dafafile this oracle like this example. can be added to another hdd. > > ALTER TABLESPACE lmtbsb > ADD DATAFILE '/u02/oracle/data/lmtbsb02.dbf' SIZE 1M; > > ALTER TABLESPACE lmtbsb > ADD DATAFILE '/u03/oracle/data/l

Re: SELECT with LIKE clause makes full table scan

st 26. 1. 2022 v 11:55 odesílatel Matthias Apitz napsal: > > > Hello, > > We face in a PostgreSQL 11.4 installation on a potent Linux host a > serious performance degree. > > A SELECT with a LIKE clause on a table with ca. 5.200.000 rows on a > column with an Index ignores this and does a full tab

Re: Multiple SELECT statements Using One WITH statement

čt 20. 1. 2022 v 13:48 odesílatel Avi Weinberg napsal: > > Hi, Hello! > > > Can I have multiple select statements using one WITH statement? > > > > WITH t AS ( > > Select A, B from … > > ) > > SELECT A into tableA FROM t where ….; > > > > SELECT B into tableB FROM t where ….; > I think it is

Re: a very naive question about table names in Postgres

pá 31. 12. 2021 v 21:28 odesílatel Martin Mueller napsal: > > I have a very naïve question and don’t know where tp look for the answer. I > use Postgres via AquaData Studio as a giant spreadsheet. I create tables and > give them names. I see the table names and know how to manipulate them wi

Re: insert column monetary type ver 2

so 20. 11. 2021 v 13:45 odesílatel Дмитрий Иванов napsal: > > Good afternoon. > Sorry about the first example. > I can't figure out the problem. Digit group group separator causes an > insertion error, what should I do? > lc_monetary = 'ru_RU.UTF-8' > Digit group group separator is a space. > Fi

Re: Why would Postgres 11 suddenly ignore the recovery.conf file?

Isn't this related to merge into postgresql.conf (https://www.postgresql.org/docs/current/recovery-config.html)? po 4. 10. 2021 v 12:35 odesílatel Dennis Jacobfeuerborn napsal: > > Hi, > I just stopped and restarted a Postgres 11 docker container which so far > has happily streamed the WAL from i

Re: Query takes around 15 to 20 min over 20Lakh rows

po 6. 9. 2021 v 20:14 odesílatel Matthias Apitz napsal: > > > What does the term 'over 20Lakh rows' mean? Thanks AFAIK in India (and surrounding areas) 20 Lakh = 20 * 100 000 = 2 000 000 > matthias > -- > Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 > Publ

Re: DB size

po 26. 4. 2021 v 22:25 odesílatel napsal: > > Hi! > > I've looked around, but could only find very old answers to this question, > and maybe it changed since then... > > I'm struggling to identify the cause of the difference in size between the > sum of all relations (via pg_total_relation_size

Re: Bi-directional Replica updates

ne 15. 11. 2020 v 12:58 odesílatel Job napsal: > > Dear Postgresql Community, > > I have been using the "vintage" Rubyrep to replicate some tables on multiple > Postgresql 9.6 databases. > For performance improving, I'd need to upgrade to Postgresql 12 but, since > sequences are managed differen

Re: New "function tables" in V13 documentation

po 9. 11. 2020 v 21:35 odesílatel Alvaro Herrera napsal: > > On 2020-Nov-09, Adrian Klaver wrote: > > > > If you have suggestion on how to improve the new format, I'm sure we can > > > discuss that. It seems pretty clear to me that we're not going back to > > > the old format. > > > > Improve it

Re: Temporary tables usage in functions

po 9. 11. 2020 v 13:07 odesílatel Yambu napsal: > > Hi > > May I know if a temporary table is dropped at the end of a function? Check https://www.postgresql.org/docs/12/sql-createtable.html#SQL-CREATETABLE-TEMPORARY, especially the "ON COMMIT" part. > > Also may I know if excessive use of tempo

Re: Estimated resources for a 500 connections instance (VM)

Hello. Have you checked https://wiki.postgresql.org/wiki/Number_Of_Database_Connections? For raw estimations you can also check http://pgconfigurator.cybertec.at/ or https://pgtune.leopard.in.ua/#/. út 7. 4. 2020 v 18:25 odesílatel David Gauthier napsal: > psql (9.6.0, server 11.3) on linux >

Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]

út 25. 2. 2020 v 15:35 odesílatel Miles Elam napsal: > How do you see this syntax working in a JOIN query? > > SELECT x.* EXCEPT x.col1, x.col2, y.col1 > FROM tablex AS x > LEFT JOIN tabley AS y; > > The column(s) you want to exclude become ambiguous. > Can you explain how are those column(s)

Re: Upgrade to 12.2 using same data directory

> > > /alias/data/ > > > > J > > > > *From:* Josef Šimánek > *Sent:* Tuesday, February 25, 2020 1:05 PM > *To:* Mihalidesová Jana > *Cc:* pgsql-general@lists.postgresql.org > *Subject:* Re: Upgrade to 12.2 using same data directory > > > > I thin

Re: Upgrade to 12.2 using same data directory

I think that's not possible. What's the reason to reuse old directory? út 25. 2. 2020 v 12:59 odesílatel Mihalidesová Jana < jana.mihalides...@cetin.cz> napsal: > Hi, > > > > Is there possibility to upgrade from 10.6 to 12.2 using exact same data > directory? First problem is with initialing of “

Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]

Just to mention, similar concept can be found in Google BigQuery. https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select-except https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select-replace út 25. 2. 2020 v 11:18 odesílatel Stanislav Motyčka

Re: JIT on Windows with Postgres 12.1

Hello. If I understand it well, JIT is enabled only for builds with "--with-llvm" flag. Seems EDB Windows PG 12.1 installer is not build with llvm (and jit) support. I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled. út 11. 2. 2020 v 22:41 odesílatel Catch All napsal: > I am u

Re: REINDEX VERBOSE unknown option

My patch was partially merged at https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=52dcfda48778d16683c64ca4372299a099a15b96 . Thanks to everyone involved in this discussion. pá 13. 12. 2019 v 2:11 odesílatel Josef Šimánek napsal: > I was thinking about this problem

Re: REINDEX VERBOSE unknown option

po 18. 11. 2019 v 7:42 odesílatel Michael Paquier napsal: > On Sun, Nov 17, 2019 at 04:41:59AM +0100, Pavel Stehule wrote: > > Documentation patch is good idea. > > The documentation is rather clear about the need to of parenthesis > when using the VERBOSE option, and that it is not a mandatory o

Re: REINDEX VERBOSE unknown option

Ahh, I just tried to do the same with reindexdb cli tool and the actual syntax is REINDEX (VERBOSE) TABLE sales; Sorry for unnecessary question. Anyway maybe we can add this to documentation as a example. I can prepare patch for this if welcomed. so 16. 11. 2019 v 18:40 odesílatel Josef Šimánek

REINDEX VERBOSE unknown option

Hello, according to https://www.postgresql.org/docs/11/sql-reindex.html VERBOSE option is valid for REINDEX command for 11.3 PostgreSQL server. Anyway I'm getting error using VERBOSE option. project_production=# REINDEX VERBOSE TABLE sales; ERROR: syntax error at or near "VERBOSE" LINE 1: REINDE

Re: FW: Re: A question about building pg-libphonenumber

Hello. You can take a look at GitHub guides - https://guides.github.com/activities/forking/#making-a-pull-request. Anyway if you would like to just contribute this one-timer, feel free to assign patch here and I'll open pull requests mentioning you as an author and linking this thread in there on

Re: syntax error with v12

Hello, I think this change is mentioned in release notes https://www.postgresql.org/docs/release/12.0/. čt 10. 10. 2019 v 14:51 odesílatel Ivan Kabaivanov < ivan.kabaiva...@gmail.com> napsal: > Hi, everyone. > > First time poster here. > > This snippet (from ovirt-engine-dwh) used to work fine wi

Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade

But the problem in this case is probably this note: > This means that a REINDEX operation on an index pg_upgrade'd from a previous release could potentially fail. You can't REINDEX safely regarding that note. pá 4. 10. 2019 v 16:06 odesílatel

Linked data from upgrade after VACUUM FULL not deleted.

Hello. Few months ago we did successful pg_upgrade --link from 9.6 to 10. I did a VACUUM FULL of all database this weekend and data from 9.6 directory were not released. I have tablespace with only one database. PostgreSQL 10 folder has similar size to actual database size (by https://wiki.postg

Re: a bug jsonb?

ge.png] > > чт, 22 нояб. 2018 г. в 18:04, Josef Šimánek : > >> If I understand well your question, this is expected with JSONB. >> >> see https://www.postgresql.org/docs/current/datatype-json.html for more >> info: >> >> ...jsonb does not preserve white

Re: a bug jsonb?

If I understand well your question, this is expected with JSONB. see https://www.postgresql.org/docs/current/datatype-json.html for more info: ...jsonb does not preserve white space, does not preserve the order of object keys, and does not keep duplicate object keys. If duplicate keys are specifi

Re: Syndicating PostgreSQL mailing list to Discourse

Is there source-code available for rubytalk.org mail-list sync part? st 21. 11. 2018 v 15:53 odesílatel legrand legrand < legrand_legr...@hotmail.com> napsal: > Hello, > > What you are proposing with https://rubytalk.org/ seems very interesting. > > It offers a quick view on mobile of "latests po

Re: COPY from a remote machine in Datastage

Can you copy your csv to postgres server? pá 5. 10. 2018 v 16:19 odesílatel Ravi Krishna napsal: > > Hello, if you need to use COPY command from remote machine and you use > some libpq bindings (aka ruby pg gem for example), you can use functions > associated with COPY command ( > https://www.po

Re: COPY from a remote machine in Datastage

Hello, if you need to use COPY command from remote machine and you use some libpq bindings (aka ruby pg gem for example), you can use functions associated with COPY command ( https://www.postgresql.org/docs/10/static/libpq-copy.html). They should be provided by bindings of postgres library you're u

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

It is licensed under MIT - https://github.com/Microsoft/vscode. 2018-07-16 13:09 GMT+02:00 Tim Clarke : > -1 for VSC not being open source > > Tim Clarke > > > On 16/07/18 11:47, Dmitry Igrishin wrote: >> >> >> пн, 16 июл. 2018 г. в 13:41, Tim Clarke >> >