Re: [GENERAL] Database block lifecycle

On 13/08/2014 17:23, Jeff Janes wrote: On Wed, Aug 13, 2014 at 1:07 AM, pinker > wrote: >> >> btw. 512MB if we assume up to 600 connection is a reasonable value? >> > >>Reasonable value for what? > > For normal server load. 512MB is being q

Re: [GENERAL] Employee modeling question

Robin St.Clair On 04/09/2014 20:44, Nelson Green wrote: On Thu, Sep 4, 2014 at 9:48 AM, François Beausoleil mailto:franc...@teksol.info>> wrote: Hello Nelson, Le 2014-09-04 à 10:39, Nelson Green mailto:nelsongree...@gmail.com>> a écrit : > Good morning, &g

Re: [GENERAL] Any advantage of using SSL with a certificate of authority?

, and knows where to look for it. 3. Maintenance becomes a problem I only use self signed certs for testing. Robin St.Clair On 26/11/2013 19:34, Andrew Sullivan wrote: On Tue, Nov 26, 2013 at 02:18:58PM -0500, Vick Khera wrote: Using self-signed certs you can give them longevity of 10+ years

Re: [GENERAL] compliance with 21 cfr part 11

belong in the database, go and look at where the likes of Sybase ASE and DB2 do it. If you do it up front, you are continually maintaining it. Few systems control appropriate access to data; that is a harder and proprietary trick. Robin St.Clair On 05/12/2013 00:07, Rob Sargent wrote: On 12

Re: [GENERAL] Could use some advice on search architecture

nary data representation Red - 1 ( 0001) Orange - 2 ( 0010) Yellow - 4 ( 0100) Green - 8 ( 1000) Blue - 16 (0001 ) Indigo - 32 (0010 ) Violet - 64 (0100 ) This way, you can encode several colours in 1 value Red or Green or Indigo = 1 + 8 + 32 = 41 = 0010 1001 Robin -- 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] Could use some advice on search architecture

bottom post On 19/04/2014 12:46, R. Pasch wrote: On 19-4-2014 9:38, Robin wrote: Well, given that there are known limited attributes, this is the type of application that really really suits a column oriented database, such as Sybase IQ (now sold by SAP). Its a neat product that scales

Re: [GENERAL] Could use some advice on search architecture

ng processed 1. Using PostgreSQL - 177 seconds 2. Using MonetDB - 8 seconds 3. Using a remote MonetDB server through MonetDB FDW - 1 second I think its worth investigating further Robin St.Clair

Re: [GENERAL] Natural key woe

ance costs in multi-user systems, it did have benefits in terms of making it easier to restrict the need for row locking to the underlying data table. Robin St.Clair On 13/05/2014 10:44, Oliver Kohll - Mailing Lists wrote: I'm sure no one else on this list has done anything like this, but here

Re: [GENERAL] changing the /tmp/ lock file?

ur backends? -- regards, Robin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[GENERAL] Problem compiling on CentOS

This is a CentOS5 installation, only special I can think of is that it runs as Xen domU, and I have the same problem on the dom0, no non Xen available at the moment. -- regards, Robin ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Problem compiling on CentOS

On 6/20/07, Robin Ericsson <[EMAIL PROTECTED]> wrote: `-mcpu=' is deprecated. Use `-mtune=' or '-march=' instead. Ok solved. This is what the configure-script barfs on. Hacking the spec-file to change this flag removes this problem. --

[GENERAL] entry log

should one instead create a log table and log changes, etc? Hints and tips are appreciated :) -- regards, Robin ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] entry log

as updated when you don't know what was updated anyway :). I guess that could be solved with triggers, each table have a trigger that fires on update and runs a stored procedure. -- regards, Robin ---(end of broadcast)--- TIP 9:

[GENERAL] history table

Hi, I want to save history for a few tables using triggers on update and creation. What's the best approach to do this in a webapp environment where I want to save which webapp user that is doing the change, not the postgresql user? -- regards,

Re: [GENERAL] history table

ase which user is logged in to the webapp? A session parameter? There will be connection pooling, but if I know how to solve the previous question I don't think it's hard to get it working with the pool. -- regards, Robin ---(end of broadcast)---

Re: [GENERAL] history table

include > the userid from your webapp as the value for that column. Your history > table can then be updated by just copying the entire row from the base > table whenever an insert or update occurs. Yes, I think this will be the easiest way, thanks! -- regards, Ro

[GENERAL] After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist

thought lets add the language I miss. doing: createlang -d ledgersmb -U ledgersmb plpgsql I keep getting: createlang: language installation failed: ERROR: permission denied for language c So, I wonder what is the best and quickest way to fix this Flaw? Thanks, Robin -- View this messa

Re: [GENERAL] Open Source CRM - Options?

; used for this kind of profiling/personalisation, and would appreciate > any pointers readers of this newsgroup might be able to offer. I think the important question is whether the op means CMS or CRM (quite different). -- regards, Robin -- Sent via pgsql-general mailing list (pgsql-gener

Re: [GENERAL] Full Text Index Scanning

I was looking for an answer to the same problem posted a while back (sorry, not sure how to join that thread): Thanks. pg_trgm looks interesting, but after installing the pg_trgm.sql, I get error messages when following the documentation. sggeeorg=> create index test_idx on test using gist(column

Re: [GENERAL] prelimiary performance comparison pgsql vs mysql

and sort is well setup, but what about thread caching? Knowing that will once in a while you will have a connection burst you can tell mysql to cache thread so that it can save time next time it needs them. -- Robin Ericsson http://robin.vill.ha.kuddkrig.nu/ ---(end of

Re: [GENERAL] LWM 2004 Readers' Choice Nomination

Christopher Browne wrote: The poll isn't about "OSS"; it's a popularity contest for proprietary software that runs on Linux. It's interesting to see that MySQL is only third at the moment. regards, Robin ---(end of broadcast)

Re: [GENERAL] truncate/create slowness

unsubscribe pgsql-general ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] 8.0.2beta1 RPMs

itself? I.e, files will be at the same places if I upgrade from FC packages? regards, Robin -- Robin Ericsson http://robin.vill.ha.kuddkrig.nu/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [GENERAL] [HACKERS] plPHP in core?

core, that newer php that have that change also bundles libsqlite. php php-mysql php-pgsql ... regards, Robin ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's data

Re: [GENERAL] [HACKERS] plPHP in core?

Martijn van Oosterhout wrote: On Tue, Apr 05, 2005 at 11:17:48AM +0200, Robin Ericsson wrote: Martijn van Oosterhout wrote: I suppose the choice comes down to either PHP splitting the DB access (like other languages) or PostgreSQL splitting out pl/PHP. Most major distributions (Fedora Core, Debian

[GENERAL] Deep integration of PostgreSQL with Apache

the web server. It looks like the Apache server and PostgreSQL server architectures are quite similar to make this feasible. Any thoughts? Best regards, Robin Boerdijk __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection

Re: [GENERAL] Deep integration of PostgreSQL with Apache

--- Thomas Hallgren <[EMAIL PROTECTED]> wrote: > Robin Boerdijk wrote: > > Hi, > > > > Apologies if this has been discussed before, but I was wondering if > > there have been any efforts in the past to provide a deep > integration > > of PostgreSQL with

Re: [GENERAL] Deep integration of PostgreSQL with Apache

> >> Apologies if this has been discussed before, but I was wondering > if > >> there have been any efforts in the past to provide a deep > integration > >> of PostgreSQL with Apache. What I mean by deep integration is that > the > >> PostgreSQL server logic runs inside the Apache server processes,

Re: [GENERAL] Problem in creating a table

UNT.sql:14: ERROR: syntax error at or near (B> "(" at character 52 (B> # (B> (B> I really don't know what is wrong with it and do appreciate it if anyone would (B> point out it. The version of Postgresql is 7.4.7. (B> Thanks

Re: [GENERAL] Problem in creating a table

; point out it. The version of Postgresql is 7.4.7. (B> Thanks in advance. (B (BTablespace wasn't supported until 8.0 (B (B (B (Bregards, (BRobin (B (B---(end of broadcast)--- (BTIP 2: you can get off all lists at once with the unreg

Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?

i have an already running application that i need to load balance. There isn't one tool that is the best, all three work very good based on where they are used and what they are used for. -- regards, Robin ---(end of broadcast)--

Re: [GENERAL] PostgreSQL and Munin

d "tar.gz" archive ? Download the source rpms and build them yourself? -- regards, Robin ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL and Munin

On 10/19/06, DANTE Alexandra <[EMAIL PROTECTED]> wrote: Hello Robin, hello List, Can I use it on RHEL4-AS ? I also tried to find the rpm sources on the Red Hat web site, without success... Download the source and try. rpmbuild --rebuild *.src.rpm. If it doesn't work at least you

[GENERAL] simple coordinate system

Hi, I'm planning a simple coordinate system, where objects are described as x, y and z. Are there any contribs or extensions available that can help me with datatypes, calculation of length between two points, etc? -- regards, Robin ---(end of broa

Re: [GENERAL] simple coordinate system

. It is for geographic stuff, so maybe overkill, but maybe not. There are are also geometry types native to Postgres that you can find in the docs I was thinking about PostGIS, but it seemed overkill for my purpose. Therefore I asked in the first place :) -- regards,

Re: [GENERAL] simple coordinate system

e looked at those, I was thinking that point looked like a good type, but it's only 2d, so maybe I need a hint on how to use this in a 3d environment. -- regards, Robin ---(end of broadcast)--- TIP 9: In versions below 8.0, the pla

Re: [GENERAL] simple coordinate system

On 3/16/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Robin Ericsson" <[EMAIL PROTECTED]> writes: > Yes, I've looked at those, I was thinking that point looked like a > good type, but it's only 2d, so maybe I need a hint on how to use this > in a 3d environ

[GENERAL] query gone haywire :)

ze result attached as explain-analyze.txt Explain without analyze when using IN(2,3) attached as explain.txt Regards, Robin Hash Join (cost=1.93..175359.44 rows=152524 width=24) (actual time=0.972..1.085 rows=5 loops=1) Hash Cond: ("outer".template_id = "inner".id) -&

Re: [GENERAL] PostGreSQL upgrade failed (Debian Packages), need

; >> > > > >The Debian package does that automatically. On some days... > > > > > Really? WOW! I wonder if Gentoo does that. That is pretty > remarkable. Gentoo tells you that you need to dump and remove the cluster before it evens tries to upgrade, atleast did f

[GENERAL] unsubscribe

unsubscribe ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[GENERAL] unsubscribe

unsubscribe ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Messages to pgsql-general list not being posted

On 7/19/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote: Both are in my pgsql-general maildir, message ids: [EMAIL PROTECTED] [EMAIL PROTECTED] I find those as well. regards, Robin ---(end of broadcast)--- TIP 3: Have you check

[GENERAL] dynamic parameters in procedure

do I loop the input-parameters? I plan to call it like this: SELECT * FROM get_table('{"field1=1", "field2=3"}'); Do I make any sense? :) regards Robin ---(end of broadcast)--- TIP 2: you can get off all lis

[GENERAL] Join a varchar array

em on different rows but I would prefer to get them back as an array. regards Robin ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Join a varchar array

On Thu, 2004-06-17 at 11:38, Richard Huxton wrote: > Robin Ericsson wrote: > > Hi, > > > > I have a field in which I save the follow: > > {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}} > > > > The first field is a reference to an id in another ta

Re: [GENERAL] query gone haywire :)

On Fri, 2004-10-08 at 10:11 -0400, Tom Lane wrote: > Robin Ericsson <[EMAIL PROTECTED]> writes: > > -> Index Scan using idx_d_entered on data (cost=0.00..18024.04 > > rows=50360 width=16) (actual time=0.210..0.247 rows=1 loops=1) > >

Re: [GENERAL] [PERFORM] query problem

On Wed, 2004-10-13 at 18:01 +0200, Robin Ericsson wrote: > Using exact timestamp makes the query go back as it should in speed (see > explain below). However I still have the problem using a stored > procedure or even using the "ago"-example from above. Well, changing ago

Re: [GENERAL] [PERFORM] query problem

Sorry, this should have been going to performance. Regards, Robin ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[GENERAL] not using index through procedure

;SELECT entered FROM data WHERE ago($1) < data.entered ' LANGUAGE 'sql' VOLATILE; and call it like this: select * from get_machine_status('60 seconds'); makes the query not use index, I guess it some basic problem I'm having, maybe I should make this into a view instead?

Re: [GENERAL] not using index through procedure

a procedure? I've tried different approaches, with moving the ago outside the procedure, having the procedure take timestamp as argument instead of interval, but still no luck. However, remove the $1 argument all together and replace that with ago('60 seconds') m

Re: [GENERAL] COALESCE() or NVL()

00 >> > Bill | 4300 >> > Ginger | 4900 >> > NULL VALUES| <--- I expected 100 here. >> > (5 rows) SELECT name, NVL(salary, 0) + 100 AS dream FROM emp; NVL() takes two values: the column/variable, and the value to use if NULL. -- Robin Thomas [EMAIL PROTECTED]

Re: [GENERAL] demande d'aide

Postgres fait partie de RedHat linux. Postgres ne se compare pas facilement a MYSQL car il est un vrai RDBMS (relational database). MYSQL est une emulation partielle. Patrick Robin chriqi abdelkarim wrote: > bonjour; > tout d'abord, je me presente. je suis un étudiant marocain

[GENERAL] pg_dump return failed sanity check

led sanity check, type with oid 457690 was not found Thanks Patrick -- Patrick Robin [EMAIL PROTECTED] Walt Disney Feature Animation 500 South Buena Vista Street Burbank,California 91521-4817

Re: [GENERAL] Help : Sum 2 tables based on key from other table

Cleko has an entire book on this subject - Thinking in Sets: Auxiliary, Temporal & Virtual Tables in SQL <http://en.wikipedia.org/wiki/Special:BookSources/9780123741370>. This blog <http://joecelkothesqlapprentice.blogspot.co.uk/>(based on his solutions) is worth a look. Robin St.Cla

Re: [GENERAL] Help : Sum 2 tables based on key from other table

indices prior to updating and then rebuilding them. Robin St.Clair On 18/11/2013 10:04, Hengky Liwandouw wrote: Thanks a lot Ken, I will try it soon. But when the table becomes huge (how big 'huge' in postgres ?), how to optimize such command ? I have index on all important field

[GENERAL] Newbie timestamp question

wn in the Postgres manual: '1999-01-08 04:05:06' for Postgres to accept the value or can I just pass an integer as 19990108040506 for the timestamp? Thanks in advance. Robin Kopetzky Black Mesa Computers/Internet Services Grants, NM -

Re: [GENERAL] Newbie timestamp question

Thank you for all your help. I built two simple functions (extract_timestamp, build_timestamp) to tear apart a timestamp and put it back together to make the job easier. Thanks again! 'Sparky' ---(end of broadcast)--- TIP 8: explain analyze is

[GENERAL] repmgr

I havent been able to find much about repmgr on postgres 9.3 Is repmgr still a significant value add given the newer replication features built in? Thanks. =R -- Robin R Chauhan CEO, Pathway Intelligence Inc ro...@pathwayi.com Office: 778-588-6217 Ext. 201 Cell: 604-865-0517 http://pathwayi.com/

Re: [GENERAL] repmgr

: > On 11/10/2014 4:10 PM, Robin Ranjit Singh Chauhan wrote: > >> I havent been able to find much about repmgr on postgres 9.3 >> >> Is repmgr still a significant value add given the newer replication >> features built in? >> > > repmgr is a management tool f