Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

Michael writes: > On Tue, Jan 16, 2018 at 07:05:19PM +0100, Adam Sjøgren wrote: >> This sounds very interesting - we are running PostgreSQL 9.3.20. > Which means that we may be looking at a new bug, 9.3.20 is the latest in > the 9.3 set as of today. Yes; unfortunately we have failed to

Parallel Btree index scan

Hi All, Can you please help me to understand what is parallel btree index scan in Postgres 10. And what is the difference between index scan and index only scan. Thanks, Krithika

Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

On Tue, Jan 16, 2018 at 07:05:19PM +0100, Adam Sjøgren wrote: > This sounds very interesting - we are running PostgreSQL 9.3.20. Which means that we may be looking at a new bug, 9.3.20 is the latest in the 9.3 set as of today. > Did you ever find out exactly what the change that solved the

Re: Extra files in "base" dir not seen in relfilenodes

On Tue, Jan 16, 2018 at 3:04 PM Tom Lane wrote: > Daniel Farina writes: > > I am looking at a database with a wide (~500G) divergence between the > total > > space expended by the database directory and the result of select > > sum(pg_relation_size(oid)) from

Re: Extra files in "base" dir not seen in relfilenodes

Daniel Farina writes: > I am looking at a database with a wide (~500G) divergence between the total > space expended by the database directory and the result of select > sum(pg_relation_size(oid)) from pg_class;. Odd. > I located about 280G of apparent extra space by performing

Extra files in "base" dir not seen in relfilenodes

I am looking at a database with a wide (~500G) divergence between the total space expended by the database directory and the result of select sum(pg_relation_size(oid)) from pg_class;. I located about 280G of apparent extra space by performing an anti-join between files on disk and files in the

Re: SSD filesystem aligned to DBMS

On Tue, 16 Jan 2018 16:50:28 +, Michael Loftis wrote: >Alignment definitely makes a difference for writes. It can also make a >difference for random reads as well since the underlying read may not line >up to the hardware add in a read ahead (at drive or OS Level) and

Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

Hi Jorge, This sounds very interesting - we are running PostgreSQL 9.3.20. Did you ever find out exactly what the change that solved the problem between 9.4.8 and 9.4.11 was? Best regards, Adam Jorge writes: > Hi Adam , I've been seeing this same kind of Error in my clusters for

Re: OPtimize the performance of a query

Hi 2018-01-16 18:57 GMT+01:00 hmidi slim : > I changed the operator like and I'm using the operator = .I got the > results much faster but I still have another question about operator. For > difference should I use '<>' or 'is distinct from' with indexes? >

Re: OPtimize the performance of a query

I changed the operator like and I'm using the operator = .I got the results much faster but I still have another question about operator. For difference should I use '<>' or 'is distinct from' with indexes? 2018-01-16 17:49 GMT+01:00 Pavel Stehule : > Hi > > 2018-01-16

Re: OPtimize the performance of a query

Hi 2018-01-16 17:44 GMT+01:00 hmidi slim : > Sorry I forget the lower command when I wrote the code, it is like this: > lower(g.country_code) like lower('US') > (lower(g.feature_class) like lowwer('P') or lower(g.feature_class) like > lower('L')) > please, don't do top

Re: OPtimize the performance of a query

Sorry I forget the lower command when I wrote the code, it is like this: lower(g.country_code) like lower('US') (lower(g.feature_class) like lowwer('P') or lower(g.feature_class) like lower('L')) 2018-01-16 17:40 GMT+01:00 Martin Moore : > > > >Hi, > > >I have two

OPtimize the performance of a query

Hi, I have two tables in the same database: geoname and test_table. The geoname table contains many columns which are: name, feature_class, feature_code, admin1, admin2,admin3, name and so on. The second table 'test_table' contains only the columns: city, state. There is no join between the two

missing FROM-clause entry for table bbbb

Hi I tried to modify below sql command in postgres syntax--- insert into (id, groupid, ele_id, ro_element_id) ") select .nextval, :groupid, gosp.neteleid, gosp.hodev from net_ele gos, net_gos_prop gosp " where gos.eid in ( :eids ) and gos.id =

SSD filesystem aligned to DBMS

Hi all Sorry, but I'm not sure that this doubt is appropriate for this list, but I do need to prepare the file system of an SSD disk in a way that pointed me to, which would be a way optimized SSD to work. I have a disk: SSD: Samsung 500 GB SATA III 6Gb/s - Model: 850 Evo