Re: [GENERAL] Postgres as In-Memory Database?

Em 20/11/2013 01:30, Jeff Janes escreveu: On Tuesday, November 19, 2013, Edson Richter wrote: Em 19/11/2013 22:29, Jeff Janes escreveu: On Sun, Nov 17, 2013 at 4:46 PM, Edson Richter > wrote: Yes, those optimizations I was talking about: having database server sto

Re: [GENERAL] Postgres as In-Memory Database?

On Tuesday, November 19, 2013, Edson Richter wrote: > Em 19/11/2013 22:29, Jeff Janes escreveu: > > On Sun, Nov 17, 2013 at 4:46 PM, Edson Richter > 'edsonrich...@hotmail.com');> > > wrote: > > >> Yes, those optimizations I was talking about: having database server >> store transaction log in

[GENERAL] Scrolling/Updating Cursors

My apologies for posting what is almost certainly somewhat of a repeat question but I have searched and attempted everything I can think of and cannot figure it out myself. The basic question is… Is it possible to get a scrollable cursor that, within a transaction, can insert/update/delete rows

Re: [GENERAL] Postgres as In-Memory Database?

Em 19/11/2013 22:29, Jeff Janes escreveu: On Sun, Nov 17, 2013 at 4:46 PM, Edson Richter mailto:edsonrich...@hotmail.com>> wrote: Yes, those optimizations I was talking about: having database server store transaction log in high speed solid state disks and consider it done while bac

Re: [GENERAL] Postgres as In-Memory Database?

On Sun, Nov 17, 2013 at 4:46 PM, Edson Richter wrote: > Yes, those optimizations I was talking about: having database server store > transaction log in high speed solid state disks and consider it done while > background thread will update data in slower disks... > > There is no reason to wait fo

[GENERAL] Re: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml

Kevin Grittner-5 wrote > gajendra s v < > svgajendra@ > > wrote: > >> I have added one column with xml type ,after adding I am getting >> following error. >> >> org.postgresql.util.PSQLException: ERROR: could not identify an equality >> operator for type xml > > The UNION operation requires com

Re: [GENERAL] org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml

gajendra s v wrote: > I have added one column with xml type ,after adding I am getting > following error. > > org.postgresql.util.PSQLException: ERROR: could not identify an equality > operator for type xml The UNION operation requires comparing all columns in the result record to remove duplic

Re: [GENERAL] Regex files are missing

Thanks for your help! I updated to version 9.3 and now it's working. Janek Sendrowski -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres as In-Memory Database?

Dear Bricklen and Andrew 2013/11/19 bricklen > On Mon, Nov 18, 2013 at 11:16 PM, Stefan Keller > wrote: > >> >> > I don't think there's any evidence that the Postgres developers ignore >> > useful optimisations. What you're arguing is that the optimisation >> > you have in mind isn't covered.

Re: [GENERAL] Postgres as In-Memory Database?

On Mon, Nov 18, 2013 at 11:16 PM, Stefan Keller wrote: > > > I don't think there's any evidence that the Postgres developers ignore > > useful optimisations. What you're arguing is that the optimisation > > you have in mind isn't covered. > > No; my point is that I - and others like Stonebraker,

Re: [GENERAL] Postgres as In-Memory Database?

On 11/17/2013 07:02 PM, Stefan Keller wrote: 2013/11/18 Andreas Brandl > wrote: > What is your use-case? It's geospatial data from OpenStreetMap stored in a schema optimized for PostGIS extension (produced by osm2pgsql). BTW: Having said (to Martijn) that using Po

Re: [GENERAL] ERROR: out of memory DETAIL: Failed on request of size ???

Hello I reported similar problem week ago - Postgres releases work_mem (assigned for every SELECT in union) after query finishing. So large SELECT UNION ALL SELECT UNION ALL .. queries require lot of memory. My customer reported significant problems for 100 unions. He had to migrate to 64bit pg w

Re: [GENERAL] expression index not used within function

LPlateAndy wrote: > Just wondering what kind of execute statement (within a function) i should > use to force the planner to use the index for the following?: You cannot force anything. The best you can do is to provide an index that *can* be used and keep your statistics accurate. > SELECT pcode

[GENERAL] pg_upgrade ?deficiency

Hello all, I am upgrading a 8.4 cluster to 9.1 and am seeing the following: SQL command failed CREATE TEMPORARY TABLE info_rels (reloid) AS SELECT c.oid FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON c.relnames