...@hogranch.com wrote:
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 for setting up and controlling
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/
Robin St.Clair
On 04/09/2014 20:44, Nelson Green wrote:
On Thu, Sep 4, 2014 at 9:48 AM, François Beausoleil
franc...@teksol.info mailto:franc...@teksol.info wrote:
Hello Nelson,
Le 2014-09-04 à 10:39, Nelson Green nelsongree...@gmail.com
mailto:nelsongree...@gmail.com a écrit
On 13/08/2014 17:23, Jeff Janes wrote:
On Wed, Aug 13, 2014 at 1:07 AM, pinker pin...@onet.eu
mailto:pin...@onet.eu wrote:
btw. 512MB if we assume up to 600 connection is a reasonable value?
Reasonable value for what?
For normal server load.
512MB is
-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's a
cautionary tale.
I
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
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
. 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
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
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
it,
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
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.Clair
On 18/11/2013 02:16, Hengky Liwandouw wrote:
Dear Friends
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 like date
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-general@postgresql.org)
To make changes
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 message in context:
http://www.nabble.com
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,
Robin
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)---
TIP 3: Have you checked our extensive FAQ
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,
Robin
---(end of broadcast
:).
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: In versions below 8.0, the planner will ignore your desire
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
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.
--
regards,
Robin
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
?
--
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
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 planner will ignore
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 environment.
Yeah, the built-in geometric types are all 2D
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 broadcast
. 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,
Robin
the source rpms and build them yourself?
--
regards,
Robin
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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...
/index.php3/stat/3/srodzaj/2/search/rrdtool-1.2.13-1.fc3.rf.src.rpm
Download the source and try. rpmbuild
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)---
TIP 5
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 checked our
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 in advance.
(B
(BTablespace wasn't supported until 8.0
(B
(B
(B
(Bregards,
(BRobin
Postgresql is 7.4.7.
(B Thanks in advance.
(B
(BTablespace wasn't supported until 8.0
(B
(B
(B
(Bregards,
(B Robin
(B
(B---(end of broadcast)---
(BTIP 2: you can get off all lists at once with the unregister command
(B(send &
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
--- 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 Apache. What I mean by deep integration
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,
rather
is 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 datatypes
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
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
unsubscribe pgsql-general
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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)---
TIP 1
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
unsubscribe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
unsubscribe
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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 for me when going from 7.3 to 7.4
regards,
Robin
---(end of broadcast)---
TIP 7: don't
) 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?
Regards,
Robin
---(end of broadcast
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') makes the procedure fly.
Regards,
Robin
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() to use timestamp without
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
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)
Index Cond: 'now'::text)::timestamp(6
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)
- Nested Loop (cost=0.00..173069.64 rows=152524 width=24) (actual
time=0.274..0.358 rows=5
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
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 table and the second
field is a value.
Can
?
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 lists at once with the unregister command
(send unregister
: '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
---(end of broadcast
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
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
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 de la 4eme année
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]
59 matches
Mail list logo