a candidate in that case.
In the same sense java is prefered over PHP, since we dont intent to interfere
with CMS code, but if some killer PHP app does the job, then it will be the
one selected.
Thanx
Achilleas Mantzios.
---(end of broadcast)---
TIP 1
).
Does any one have done anything similar with (long term success),
or does anyone sees any potential problems with the later approach?
Thanx a lot for any thoughts.
--
Achilleas Mantzios
---(end of broadcast)---
TIP 1: if posting/reading through Usenet
the most out of it?
When is a stable (release) version of 9.1 be available?
Has any one faced any issues migrating from 9.0 to 9.1
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
of DBmirror (which is in use for a very specific set of problems)
So i am asking what would be better by your perspective to do?
Go for 9.1? or stick to 9.0?
Where is a stable (release) version of 9.1 be available?
Has any one faced any issues migrating from 9.0 to 9.1
Achilleas Mantzios
Thanx, i think i'll just stick with 9.0 and try to take full advantage of it
and when we are comfortable with all those features then move to 9.1
From: Merlin Moncure mmonc...@gmail.com
To: Achilleas Mantzios mantzios.ach...@yahoo.com
Cc: pgsql-general@postgresql.org pgsql-general
16, 2011 11:05 AM
To: Achilleas Mantzios
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL 9.0 or 9.1 ?
It could be worth considering 9.1. Probably by the time you get
production ready version, 9.1 will be already stable (few months I
guess).
The usual answer
, like java, there is a boolean
data type and a Boolean class wrapper.
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des sinistres et des contentieux pour le service juridique
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
be faster for indexing? I assume the
bigint wins here, right?
Thanks in advance,
Antonio
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Στις Friday 22 July 2011 13:25:21 ο/η Achilleas Mantzios έγραψε:
bigint by all means. floating point arithmetic is somewhat more
bloated/fuzzy/straight forward than integer
,
Mario
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of the patient and a phone that forwards the
data towards the hosting. If somebody can be interested I pray him to ask me
for more information writing just to my email address. Thanks a lot!
David J.
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
.
---
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
- compare table sizes
- may need vaccum ?
If all three match that may be good enough ?
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general
Στις Thursday 01 September 2011 15:50:21 ο/η Scott Marlowe έγραψε:
On Thu, Sep 1, 2011 at 3:48 AM, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
md5 has size limitations, the second approach seems more practical.
Really? I was not aware of size limits of md5, what
do i can perfome this insert?
thanks
p
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
on PG, I am
especially looking for books on PG internals, architecture, Backup
Recovery and HA.
Looking forward for the information.
Regards,
VB
--
Adam Cornett
adam.corn...@gmail.com
(678) 296-1150
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list
don't understand why queries 1 and 3 give different results. They
seems to be the same... Could someone explain the difference?
--
Best regards,
Alexander Pyhalov,
system administrator of Computer Center of Southern Federal University
--
Achilleas Mantzios
--
Sent via pgsql-general
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
able to use it .
Please note that I am not able to take the complete databases backup
because the database server is down and restarts when we start backups.
Any help will be appreciated.
Thanks
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general
VIEW view1 AS
SELECT
attribute1 as a1,
text null as a2,
text 'test' as a3
FROM
table;
Thanks
-Lauri Kajan
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
each assert()
current_time := '2012-01-01'::timestamp
SELECT assert(5, (SELECT count(*) FROM expired_accounts)::integer);
--
Eric Radman | http://eradman.com
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
/_out objects needed anymore?
can I overlook the errors when importing the old dump?
thanks for your time
robert
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
Στις Wednesday 19 October 2011 16:46:55 ο/η Tom Lane έγραψε:
Achilleas Mantzios ach...@matrix.gatewaynet.com writes:
tsearch2 support is included in the 9.1 distribution. No need for any
additional packages.
However, if you need to use the old functions, then you will have to
install
, and modifies bind's
config files
accordingly.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
to get 100 last rows from a and 100 last rows from b do:
(SELECT * FROM a ORDER BY time LIMIT 100) UNION ALL (SELECT * FROM b ORDER BY
time LIMIT 100);
omitting the ALL modifier, you may end up with less rows, since UNION
normally returns only
distinct rows.
thanks.
--
Achilleas Mantzios
/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Achilleas Mantzios
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
of text.
How to do it ?
Maybe you should a look at array_agg. It is an aggregate function operating on
a set of values and returning the resulting array.
http://www.postgresql.org/docs/9.0/interactive/functions-aggregate.html
pasman
--
Achilleas Mantzios
IT DEPT
--
Sent
-01-23 10:42:55.268 UTC 11551 [unknown] [unknown]
LOG: incomplete startup packet
I think it's harmless, it's been there for years. It might be related
to the init script that starts the database server.
--
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing list (pgsql-general
...
Believe me, I was an ex- IBM MVS sysprog (+10 yrs ago) and struggled to get
back into the BSD/linux world. One cannot think unix/mainframe at the same
time, the concepts are so different, they are nearly mutually exclusive.
--
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing list
' in postgresql.conf and send the
postmaster the -HUP signal, and then watch the postgresql log for the queries
that the perl script is issueing. Then replay those queries by hand and
examine them.
Also you can always check pg_stat_activity table.
Best,
-at
--
Achilleas Mantzios
IT DEPT
--
Sent
transaction
logs that got built up during development. What is the way to do that?
I am currently using 8.3 and 8.4.
Is there the possibility that the logs saved in /var/log also contain
security details?
/voipfc
--
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing list (pgsql
the job more than well.
Also, our replication is the most fine-grained situation i can think of.
(even rows being lazily replicated based on the FK dependency graph, and many
other nice tricks)
-
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
programming.
Could you guys please guide me from where I should start?
Thanks.
-
Achilleas Mantzios
IT DEPT
query's results gave correctly, but it's now the last one i.e. '2012-08-19
01:01:54'
Any ideas? Missing the obvious?
TIA,
Thalis K.
-
Achilleas Mantzios
IT DEPT
/ |
ratestogo.comhttp://www.ratestogo.com/ |
asiahotels.comhttp://www.asiahotels.com/
-Ryan Kelly
-
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Î Î±Ï 31 ÎÏ
γ 2012 09:19:26 Chris Angelico wrote:
On Thu, Aug 30, 2012 at 4:42 PM, Achilleas Mantzios
ach...@smadev.internal.net wrote:
I have found useful the use of variable assignment in psql, e.g.
#!/bin/sh
# lets say you have some var with a value, or even populate some var
On Παρ 31 Αυγ 2012 09:37:05 Craig Ringer wrote:
On 08/30/2012 02:42 PM, Achilleas Mantzios wrote:
I have found useful the use of variable assignment in psql, e.g.
If you're going to to that, why not drive psql as a coprocess:
because it is completely irrelevant with what the OP asked
On Î Î±Ï 31 ÎÏ
γ 2012 09:19:26 Chris Angelico wrote:
On Thu, Aug 30, 2012 at 4:42 PM, Achilleas Mantzios
ach...@smadev.internal.net wrote:
I have found useful the use of variable assignment in psql, e.g.
#!/bin/sh
# lets say you have some var with a value, or even populate some var
On Παρ 31 Αυγ 2012 09:37:05 Craig Ringer wrote:
On 08/30/2012 02:42 PM, Achilleas Mantzios wrote:
I have found useful the use of variable assignment in psql, e.g.
If you're going to to that, why not drive psql as a coprocess:
because it is completely irrelevant with what the OP asked
space and for many web sites it's hard to
appreciate the difference between Postgres and MySQL (unless your DB
crash and burn).
That's what most people perceive as the mainstream if you don't have
a big marketing dept lying.
-
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing
On Î¤ÎµÏ 05 ΣεÏÏ 2012 23:44:08 Chris Angelico wrote:
On Wed, Sep 5, 2012 at 7:40 PM, Achilleas Mantzios
ach...@smadev.internal.net wrote:
(single master, 80+ slaves in 80+ vessels in the 7 seas (80+ = 80 and
growning))
Cool!! How do your nodes communicate with each other
),
badge_photo,
PRIMARY KEY (badge_number)
);
What datatype should I use for the badge_photo (bytea?), and what are the
commands to insert the picture accessing the server remotely through psql, and
to retrieve the photos as well, please?
Thanks,
Nelson
-
Achilleas
lang.
On Πεμ 09 Μαΐ 2013 10:34:35 Nelson Green wrote:
On Thu, May 9, 2013 at 10:20 AM, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
why not bytea?
Hi Achilleas,
Actually I was asking if bytea is the correct datatype, and if so, would
someone mind providing a simple example of how
and an application server like Apache. I have to know that
because I'm designing a simple deployment diagram and I just need it for finish.
Thanks in advance.
Regards, Karel Riverón
Student Scientific Council
Informatics Science University
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt
and an application server like Apache. I have to know that
because I'm designing a simple deployment diagram and I just need it for finish.
Thanks in advance.
Regards, Karel Riverón
Student Scientific Council
Informatics Science University
-
Achilleas Mantzios
IT DEV
IT DEPT
Patrick also you may build postgresql by hand and apply the patch manually from
: /usr/ports/databases/postgresql93-server
Although being in a non-english speaking company, i have not tried this neither
at work or at home.
Hope that helps.
regards, tom lane
--
Achilleas
multithreaded,
this doesn’t happen. It sounds like something that neither side can really fix, but if I’m wrong and any devs would like a core file, I can provide one.
[1]
http://www.postgresql.org/message-id/camflbnhq6641ymbij2-7ozksgmgfne5v3ggfkvyxojy8umr...@mail.gmail.com
--
Achilleas Mantzios
) presentation I found about using ZoL in production
(albeit, not with PostgreSQL) and the current status of the project:
http://lanyrd.com/2013/linuxcon-north-america/scqmfb/
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
The appropriate list for this is the jdbc list: pgsql-j...@postgresql.org
-
Achilleas Mantzios
IT DEPT
some RAM is greatly
appreciated :-) If more information is needed I will gladly provide it.
Frank
-
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
On Δευ 05 Νοε 2012 13:14:37 Achilleas Mantzios wrote:
ipcs in FreeBSD is a little ... tricky.
ipcs -M
ipcs -m
ipcs -am
could be your friends
On Δευ 05 Νοε 2012 11:22:46 Frank Broniewski wrote:
Hi,
I am running a PostgreSQL server on FreeBSD. The system has 32GB memory
the connection of my 5GB missing in top? I wonder if this
might be the maintenance_work_mem, which is set to 4GB?
Many thanks,
Frank
Am 2012-11-05 12:14, schrieb Achilleas Mantzios:
ipcs in FreeBSD is a little ... tricky.
ipcs -M
ipcs -m
ipcs -am
could be your friends
On Δευ
-hosting.lu/monitor/munin/metrico/bilbo.metrico/memory.html
Am 2012-11-05 15:21, schrieb Achilleas Mantzios:
How do you measure that smth is missing from top? What values do you add?
I am currently running 8.3 but we shouldn't be so far apart top-wise.
What is the reading under SIZE and RES
)
- i believe that the documentation on how to store C strings as varchar is
almost absent, i just followed the comments
in postgres.h
-
Achilleas Mantzios
IT DEPT
.
There are some scripts floating around that read values from sysctl vm.stats.vm
and format them nicely to tell you how much memory is used up and free. Try
the one referenced here:
http://www.cyberciti.biz/faq/freebsd-command-to-get-ram-information/
-
Achilleas Mantzios
IT DEPT
there, if you decide to do so.
I would like to follow this.
Thanx!
Frank
Am 2012-11-07 09:26, schrieb Achilleas Mantzios:
Vick,
fantastic script, thanx! FreeBSD sysctl system is awesome!
On Τρι 06 Νοε 2012 14:33:43 Vick Khera wrote:
On Mon, Nov 5, 2012 at 10:11 AM, Frank Broniewski b
.
There are some scripts floating around that read values from sysctl vm.stats.vm
and format them nicely to tell you how much memory is used up and free. Try
the one referenced here:
http://www.cyberciti.biz/faq/freebsd-command-to-get-ram-information/
-
Achilleas Mantzios
IT DEPT
:28, schrieb Achilleas Mantzios:
On Τετ 07 Νοε 2012 09:42:47 Frank Broniewski wrote:
Hey, this is really cool. I directly tried the script and there's a line
from the output that caught my eye:
mem_gap_vm: + 8812892160 ( 8404MB) [ 26%] Memory gap: UNKNOWN
is this the shared
by different servers at the same time (of course, only one
instance of PostgreSQL on only one server can be running on such a
setup, and there are a lot of other precautions that need to be satisfied).
-
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
:
select * from pg_namespace ;
Regards,
Xiaobo Gu
-
Achilleas Mantzios
IT DEPT
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is suggesting about being scared to use this
in production environments.
That would be very cool if it was much more active and stable.
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
the app programmer prone to errors.
The most elegant solution IMHO is the 2nd but i am concerned that setting the
database-wide session_replication_role to smth different than the default might
just
hide some future risks.
What are your thoughts on that?
Thank you a lot for any input.
-
Achilleas
- /usr/local/pglog/pg_xlog/
I've exhausted everything I can think of to try to solve this one. Has anyone
got any ideas on how to go about debugging this?
Thanks,
Dan
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt
on freebsd-[questions|stable]
as well.
Yes I think that might be a good plan :)
Dan
On 20 March 2013 12:30, Achilleas Mantzios ach...@matrix.gatewaynet.com
wrote:
Did you do a detailed du during the supposed problem and after the reboot
and make a diff of those
to fimd any invlolved
/obj/u/lorax1/usr9/src/sys/KCI64 amd64
[root@d04]# uptime
9:50AM up 74 days, 17:36, 1 user, load averages: 0.21, 0.18, 0.17
[root@d04]# psql --version
psql (PostgreSQL) 9.2.3
[root@d04]#
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt
Khera wrote:
On Wed, Mar 20, 2013 at 10:34 AM, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
regarding journaling, there is the counter argument that you do not need to do
the same job twice,
in the sense that we already spend a considerable amount of time retaining the
WAL
or anything), but it certainly
suggests that it's *something* related to PG or our usage of it.
Any difference in the architecture of the two systems? (x86, amd64, etc..)
Any difference in the respective output of
% pg_config
?
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt
SIGNATURE-
iEYEAREDAAYFAlF5UHAACgkQvJuQZxSWSsjm+ACeOT2v7EF90tFr7K892UxIAqnl
WpwAoKPkIMC7HTTtvOMj/XbtOVGXe0Fl
=2bjH
-END PGP SIGNATURE-
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt
9.1.11 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit
/proc/cpuinfo says: 8 CPUs, identified as Intel(R) Xeon(R) CPU E5-2609 0 @
2.40GHz
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql
-
PostgreSQL 9.1.11 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit
/proc/cpuinfo says: 8 CPUs, identified as Intel(R) Xeon(R) CPU E5-2609 0 @
2.40GHz
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql
but BSD in a server role?
shaking head
Jan
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 11/04/2014 13:05, Alban Hertroys wrote:
On 11 Apr 2014, at 8:04, Achilleas Mantzios ach...@matrix.gatewaynet.com
wrote:
Basically it goes beyond what ppl would describe as OS holly wars.
If one chooses to go by FreeBSD, then he better be prepared to handle the
burden, both the part
, this is not easy.
Fair enough.
You are welcome :)
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
'health'
order by PublishDate desc
limit 100;
I'm not sure what case WHEN 'health''' THEN 'health' ELSE '%' end
does. I follow everything just fine until I get to the 'health'''
condition. What does the single quotation mark mean? I can't seem to
find it in the documentation.
-David
--
Achilleas
of column health and the
literal value '')
'health' is one of the accepted values of the page table's
Classification column.
Many thanks,
-David
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
.nabble.com/Why-isn-t-Java-support-part-of-Postgresql-core-tp5819025.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
, generally speaking invoices have invoice_no's while general docs
have doc_no's , right?
So I think, the above scenario could be indeed be found a lot of times in
systems designed with no OO in mind.
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general
On 03/10/2014 05:54, Jim Nasby wrote:
On 10/2/14, 9:00 AM, Tom Lane wrote:
Achilleas Mantzios ach...@matrix.gatewaynet.com writes:
Was there ever any discussion.thought about being able to follow a non-strict
by name
column mapping between inherited tables and father tables?
No. You could
common unless you use ZFS or similarly
high-end FS.
Regarding file filesys based backups, apart from pg_basebackup which is a nice utility but built on top of the existing Continuous Archiving philosophy, the very feature was already implemented
since 8.*
--
Achilleas Mantzios
Head of IT DEV
Avast logo <https://www.avast.com/antivirus>
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
www.avast.com <https://www.avast.com/antivirus>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 04/11/2015 17:53, Rob Sargent wrote:
On 11/04/2015 03:03 AM, Achilleas Mantzios wrote:
Sorry for being kind of late to the party (I was in 2015.PgConf.EU !!), and not
having read
most of the replies, what we have been successfully doing for this problem for
our app
is do it this way
t is a typo on my part.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
. and
known technical details about postgresql checkpoints.
i can not foud in the web answers for my question.
i would apreciate your answer. thanks a lot
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
nstallations in the seven seas communicating over satellite by a hacked version of uucp and replicated via
a heavily hacked version of DBmirror.
So while I think that a CoC might help beginners stay, I don't think that this
is a major part, neither do I think that the ppl themselves will easily c
ern cloud-inspired paradigms out there, our traditional
architecture might not of much interest any more, still I would love to make
the above happen some time.
Best Regards,
CN
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-ge
schemata.
On Tue, May 31, 2016 at 10:18 AM, Achilleas Mantzios <ach...@matrix.gatewaynet.com
<mailto:ach...@matrix.gatewaynet.com>> wrote:
On 31/05/2016 10:45, CN wrote:
I have a feeling that slight enhancement to commands "SET ROLE" or "SET
--- 1 postgres dba98304 Feb 10 13:35 0023
the members directory has 15723 files:
ls -l|wc -l
15723
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 10/02/2016 12:40, Karsten Hilbert wrote:
On Wed, Feb 10, 2016 at 10:34:53AM +0200, Achilleas Mantzios wrote:
PG on tankers:
About checksums in our office master DB that's a fine idea, too bad that
pg_upgrade doesn't cope with them
I am sure you have considered "failing over"
DB.
About checksums in our office master DB that's a fine idea, too bad that
pg_upgrade doesn't cope with them
(and upgrading without pg_upgrade is out of the question)
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
the ICU patch is ready? I
mean any risk without making a dump and import before the switch.
If this is okay for sure, what should I do later when the ICU is
available? Do I have to reindex everything with the ICU patched database?
Thank you.
M.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
on available for FreeBSD supported versions.
Would you please let em know if Postgres is supported on both FreeBSD x86
and x86_64.
Thanks in advance,
Preeti
--
thanks and regards,
Meera R Nair
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 24/02/2016 09:20, John R Pierce wrote:
On 2/23/2016 10:57 PM, Achilleas Mantzios wrote:
Of course it is. You can install PostgreSQL via packages, via ports or manually. I prefer the manual way and have been doing so for many years. FreeBSD peculiarities will start to bite (maybe,
maybe
postgres on identical jails,
i.e. same user, same port? Was FreeBSD IPC ever jailified? Or did the recent
switch to mmap resolve this?
I'm running pg 9.4.6 in a FreeNAS (FreeBSD 9.3) jail without any hassle, and
very good performance, installed from ports via pkg install ...
--
Achilleas
guess.
Just write an AFTER INSERT OR UPDATE TRIGGER ON config,
which checks for integrity.
cheers,
Chris
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
solution and keep
us posted, many ppl might benefit from this.
Regards,
Alexey
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
where vslwhid=vvslid and
itoar(defid) ~ tmppars;
RETURN tmp;
END;
$function$
# select get_machdef_sister_defids_maxrh(479,319435);
get_machdef_sister_defids_maxrh
-
10320
(1 row)
Time: 111.318 ms
Is this expected ?
--
Ach
Hello David
On 29/03/2016 14:04, David Rowley wrote:
On 29 March 2016 at 20:01, Achilleas Mantzios
<ach...@matrix.gatewaynet.com> wrote:
We are using PostgreSQL 9.3. Shouldn't the optimizer use a single call to
get_machdef_sister_defids in get_machdef_sister_defids_maxrh ??
It shouldn't
=
Thank you!
---
Cal Heldenbrand
Web Operations at FBS
Creators of flexmls <http://flexmls.com>® and Spark Platform
<http://sparkplatform.com>
c...@fbsdata.com <mailto:c...@fbsdata.com>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
1 - 100 of 168 matches
Mail list logo