[GENERAL] Large amount of serialization errors in transactions

Hi! I have a problem understanding how transactions with serializable isolation level works in postgresql. What exactly may cause a serialization error? My problem is a system where process one adds data to a database. Shortly afterwards, process two reads and possibly modifies the same data (k

Re: [GENERAL] Large amount of serialization errors in transactions

quot; Til: "Vegard Bønes" , pgsql-general@postgresql.org Sendt: 10. mai 2013 20:35:05 Emne: Re: [GENERAL] Large amount of serialization errors in transactions Vegard Bønes wrote: > I have a problem understanding how transactions with serializable > isolation level works in postgresql

[GENERAL] better performance on poorer machine?

Hi, I have a database on a test server with queries that perform terribly. Trying to fix this problem, I copied the database (using pg_dump) to my laptop, and reran tests there. The same queries perform perfectly on my laptop. I have tried to use the same postgresql.conf, and run ANALYZE and ev

Re: [GENERAL] better performance on poorer machine?

time! VG - Original Message - Fra: "Alban Hertroys" Til: "Vegard Bønes" Kopi: pgsql-general@postgresql.org Sendt: 13. mai 2014 17:49:28 Emne: Re: [GENERAL] better performance on poorer machine? On 13 May 2014 16:48, Vegard Bønes wrote: > I have a databas

[GENERAL] SQL names for C constants

Hi! I am writing a serverside function in plpgsql, which returns a part of a large object. To solve this problem I can do something like this: fd := lo_open( some_oid, 262144 ); PERFORM lo_lseek( fd, index, 0 ); RETURN loread( fd, read_size ); This works well enough, but I do feel slightly u