Naked EXISTS vs SELECT EXISTS very different performance.

Hi everyone. Can someone tell me why these two equivalent queries, one involving a "naked" EXISTS versus one involving an EXISTS inside a SELECT statement perform so differently? I can see that the slow one scans the entire child table while the fast one only scans children that have the same pare

Re: Unexpected behavior sorting strings

Many thanks! That clarifies things well. Jimmy On Wed, Apr 8, 2020, at 11:49 AM, Adrian Klaver wrote: > On 4/8/20 7:35 AM, Jimmy Thrasher wrote: > > Am I missing something about how sorting works? > > I believe you are looking for 'C' collation: > > test=# sel

Unexpected behavior sorting strings

n this down further: ``` supercatdev=# select '> N' < '< S'; ?column? -- t (1 row) ``` Am I missing something about how sorting works? Metadata: - postgresql 9.5.19, running on Ubuntu 16LTS - encoding, collate, and ctype are all UTF8 or en_US.UTF-8, as appropriate Thanks! Jimmy

Re: PostgreSQL10.x client Vs. PostgreSQL 11.x server

Hi Deepti, As Peter pointed out (and I should have clarified), the server-side features of each version should work regardless of client. So the pg11 client will support all of the features of pg10 server (should be fully compatible). Best regards, Jimmy Jimmy Angelakos Senior PostgreSQL

Re: PostgreSQL10.x client Vs. PostgreSQL 11.x server

new release, but for the above reasons you should try to match server and client versions. Best regards Jimmy Jimmy Angelakos Senior PostgreSQL Architect 2ndQuadrant - PostgreSQL Solutions for the Enterprise https://www.2ndQuadrant.com/ On Fri, 13 Mar 2020 at 08:19, Deepti Sharma S wrote

Re: parsing xml with PG 9.2.4

w.postgresql.org/docs/9.2/functions-xml.html#FUNCTIONS-XML-PROCESSING Best regards, Jimmy On Mon, 17 Feb 2020 at 16:32, Mario Vlahovic wrote: > > Hello Developers, > I hope you can help me. I'm having troubles parsing some data from my psql > table, which I need for furth

Re: pg full text search very slow for Chinese characters

It is all default values. I just check maintenance_work_mem and indeed it is 64MB. At first I gave 2GB ram to docker and later I increased ram to 4GB. It did not make much difference when ram increased from 2GB to 4GB. I will try increasing maintenance_work_mem and see if it helps. 发件人: Michael

pg full text search very slow for Chinese characters

). I switched to Elasticsearch and it turned out that Elasticsearch is extremely efficient for my case. It took Elasticsearch 3 hours to index all 303049 rows. Jimmy Huang jimmy_hu...@live.com

how to know that one query use the data in the os cache

I use postgresql for windows server 2012 R2. I use select pg_prewarm('tablename','read','main'); to load data into the os cache. How can I know the database used the data in the os cache when I use the sql, select * from tablename, to query. explain(analyze true, buffers true) select * from table

Re:Re: how to clean the cache from databases and operating system

tember 2018 at 08:25, jimmy wrote: 1、When I execute the firse sql query, like below: select * from tablename; there are some datas that will be loaded into the database cache. How to clean the data from cache. 2、When I execute second sql query like below: SELECT pg_prewarm(

how to clean the cache from databases and operating system

1、When I execute the firse sql query, like below: select * from tablename; there are some datas that will be loaded into the database cache. How to clean the data from cache. 2、When I execute second sql query like below: SELECT pg_prewarm('tablename', 'buffer') . Data will be lo

Re:Re: how to know whether query data from memory after pg_prewarm

But I use windows server 2012R. pgfincore can not run on the windows. Is there some replacements in windows system? At 2018-09-19 15:44:06, "Cédric Villemain" wrote: >Le 19/09/2018 à 05:29, Thomas Munro a écrit : >> On Wed, Sep 19, 2018 at 1:35 PM jimmy wrote: >>

Why the sql is not executed in parallel mode

Why the sql is not executed in parallel mode, does the sql has some problem? with sql1 as (select a.* from snaps a where a.f_date between to_date('2018-03-05', '-MM-dd') and to_date('2018-03-11', '-MM-dd') ), sql2 as (select '1' as pId, PM_TO as pValue, type_code as typeCode,

how to know whether query data from memory after pg_prewarm

I use select pg_prewarm('table1','read','main') to load data of table1 into the memory. when I use select count(1) from table1 group by aa to query data. I find the speed of query is not fast, I wonder whether it query data from memory. And it is slower than Oracle, both of Oracle and Postgresql

Re:Re: How to install pgAgent on windows for postresql-bigsql-10.5

Is EnterpriseDB opensource and free. Has this database some limits and restrictions ? At 2018-09-06 15:57:30, "Dave Page" wrote: Hi On Thu, Sep 6, 2018 at 6:23 AM, jimmy wrote: I use PostgreSQL-10.5-1-win64-bigsql.exe to install postgresql database. How to install pgAgent

How to install pgAgent on windows for postresql-bigsql-10.5

I use PostgreSQL-10.5-1-win64-bigsql.exe to install postgresql database. How to install pgAgent on windows for postresql-bigsql-10.5. I have been searching some articles to install pgAgent. But they do not work. I found there has not any version of pgAgent for windows in the website 'www.pgadmin.o

Re: PostgreSQL 9.6 Temporary files

2018-03-20 15:00 GMT+01:00 Adrian Klaver : > On 03/20/2018 03:16 AM, Jimmy Augustine wrote: > >> Thanks all for your response, >> >> $du -h $MY_DATA/base/$BASE_OID/ returns 162GB but when I execute this >> query: >> >> |SELECT stats.relname AS

Re: PostgreSQL 9.6 Temporary files

G (relname) WHERE stats.schemaname = current_schema ORDER BY live_rows ASC; I obtain 80GB in total_table_size (half of my database), where are missing data at? 2018-03-19 19:32 GMT+01:00 Adrian Klaver : > On 03/19/2018 10:27 AM, Jimmy Augustine wrote: > >> I tried this query and my dat

Re: PostgreSQL 9.6 Temporary files

2018-03-19 18:25 GMT+01:00 Andreas Kretschmer : > On 19 March 2018 18:21:42 CET, Jimmy Augustine > wrote: > >2018-03-19 18:15 GMT+01:00 Adrian Klaver : > > > >> On 03/19/2018 10:12 AM, Jimmy Augustine wrote: > >> > >> > >>>

Re: PostgreSQL 9.6 Temporary files

I tried this query and my database size is equal to 162GB. 2018-03-19 18:17 GMT+01:00 Melvin Davidson : > > > On Mon, Mar 19, 2018 at 1:12 PM, Jimmy Augustine > wrote: > >> >> >> 2018-03-19 18:09 GMT+01:00 Adrian Klaver : >> >>&g

Re: PostgreSQL 9.6 Temporary files

2018-03-19 18:15 GMT+01:00 Adrian Klaver : > On 03/19/2018 10:12 AM, Jimmy Augustine wrote: > > >> On 03/19/2018 09:31 AM, Jimmy Augustine wrote: >> >> Dear Friends, >> >> I am newbie to postgresql. >>

Re: PostgreSQL 9.6 Temporary files

Hi, I used this command and I found the same value in total_size column. 2018-03-19 18:01 GMT+01:00 Melvin Davidson : > > > On Mon, Mar 19, 2018 at 12:45 PM, Adrian Klaver > wrote: > >> On 03/19/2018 09:31 AM, Jimmy Augustine wrote: >> >>> Dear Friends, >

Re: PostgreSQL 9.6 Temporary files

2018-03-19 18:09 GMT+01:00 Adrian Klaver : > On 03/19/2018 10:04 AM, Jimmy Augustine wrote: > >> >> >> 2018-03-19 17:45 GMT+01:00 Adrian Klaver > <mailto:adrian.kla...@aklaver.com>>: >> >> On 03/19/2018 09:31 AM, Jimmy Augustine wrote: >>

Re: PostgreSQL 9.6 Temporary files

2018-03-19 17:45 GMT+01:00 Adrian Klaver : > On 03/19/2018 09:31 AM, Jimmy Augustine wrote: > >> Dear Friends, >> >> I am newbie to postgresql. >> I have 162 GB on my database but when I check size of all tables, I >> approximately obtain 80 GB. >> I al

Re: PostgreSQL 9.6 Temporary files

Hi Andreas thanks for your response, 2018-03-19 17:44 GMT+01:00 Andreas Kretschmer : > On 19 March 2018 17:31:20 CET, Jimmy Augustine > wrote: > >Dear Friends, > > > >I am newbie to postgresql. > >I have 162 GB on my database but when I check size of all tables, I

PostgreSQL 9.6 Temporary files

where are they at? Can I delete some of them? All values come from pgAdmin 4 and checked by my own SQL queries(postgresql-9.6). I already run vacuum full and there is few dead tuples. Best regards, Jimmy AUGUSTINE

Re: Unsubscribe

Me as well. Thanks Get Outlook for iOS From: Marek Przywara Sent: Monday, November 20, 2017 3:07:49 PM To: pgsql-ad...@postgresql.org; pgsql-general@lists.postgresql.org; pgsql-gene...@postgresql.org Subject: Unsubscribe Please unsubscribe