Hi,
So I'd call this an oracle_fdw bug. It needs to postpone what it's
doing here to the first normal FDW function call in a session.
Thanks a lot for looking so quickly into this!
I've opened an issue with oracle_fdw:
https://github.com/laurenz/oracle_fdw/issues/215
d 4 core dumps!
Below is the back trace from gdb from each of the cores.
Let me know if there's anything else I can do or check!
Thanks :)
Chris.
[centos@asia data]$ ls -l core*
-rw---. 1 centos centos 152059904 Nov 19 17:43 core.30430
-rw---. 1 centos centos 152059904 Nov 19
I'm pretty sure this isn't as simple as you think it is, I'd suggest
having a good read of:
https://stackoverflow.com/a/201378/216229
Chris
On 16/11/2017 07:56, Nick Dro wrote:
I beleieve that every information system has the needs to send emails.
Currently PostgreSQL
Forwarded Message
Subject:standby stop replicating, then picked back up
Date: Tue, 7 Nov 2017 13:04:18 -0700
From: chris kim
To: pgsql-in-gene...@postgresql.org
Hello,
I had a standby hang for a while, not replicating, but then it fixed
itself but I&#
I just tried to build Postgres ODBC from source (psqlodbc-10.00..tar.gz)
I type "./configure"
Then get this message:
configure: error: odbc_config not found (required for unixODBC build)
So it must be looking for a file called "odic_config"? It's not 100%
clear wha
nts above 1).
If you read and count ms carefully you will find that ar_tran_inv is
scanned 6 times and each of these times is taking about 25ms. 25x6 is half
of your query time right there and then you have the overhead in the joins
on top of that. Quick eyeball estimates is that this is where
folks are working on this, is there an ETA on a fix?
Is there anything I can do to help?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
arriage.parties)
join people p2 on p2 = any(marriage.parties) and p2.id <> p1.id
>
>
> --
> Veni, Vidi, VISA: I came, I saw, I did a little shopping.
>
> Maranatha! <><
> John McKown
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ation slots provide standby feedback and may further delay
vacuuming when the standby is offline.
> --
> Michael
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-ge
loss.
I would appreciate the communities help in the following:
1. Determine if data from the incremental backups can be restored or
recovered.
2. Determine if data can be recovered from individual files backed up from
main Postgres data directory.
Thanks in advance
Chris
On Wed, Jul 5, 2017 at 3:51 PM, Bill Moran wrote:
> On Wed, 5 Jul 2017 13:28:29 +0200
> Chris Travers wrote:
>
> > On Wed, Jul 5, 2017 at 1:00 PM, PT wrote:
> >
> > > 2x the working size for a frequently updated table isn't terrible
> bloat.
> > &g
until you know how frequently autovacuum runs on
> that table and how long it takes to do its work.
>
Given the other time I have seen similar behaviour, the question in my mind
is why free pages near the beginning of the table don't seem to be re-used.
I would like to try to ver
her interpretations of the
declarative that are not at all equivalent. The hoops we have to jump
through to make this work in an imperative way in SQL are sometimes rather
amusing.
>
> Kind Regards,
> Jason
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Wed, Jul 5, 2017 at 7:18 AM, Chris Travers
wrote:
> Hi;
>
> First, I haven't seen major problems of database bloat in a long time
> which is why I find this case strange. I wanted to ask here what may be
> causing it.
>
> Problem:
> ==
> Database is
ve chained generators and you really need to watch what is
parallelizable and what is not, and what is running on the partitions and
what is running post-gathering/shuffling. Spark has no real facility for
parallelising a comprehension.
>
> Kind Regards,
> Jason
>
>>
--
Bes
y important to understand the imperative side of the data flow in
that case (what is partitioned and what is not).
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ently which is the
problem here? But why doesn't Postgres re-use any of the empty disk pages?
More importantly, is there anything that can be done to mitigate this issue
other than a frequent vacuum full?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Fle
ts 0 rows, it can handle the conflict.
>
For that, you could use xmin. That tracks the transaction where the row
first became visible.
Best Wishes,
Chris Travers
>
> Rob
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
xt: http://www.postgresql-archive.
> org/Unable-to-understand-index-only-scan-as-it-is-not-
> happening-for-one-table-while-it-happens-for-other-tp5968835.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing l
r data only in one table.
Did you notice the "Out of memory!" you got there?
I guess that's the problem now...
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
step. I guess you are running this on some test
data, so the file will be small enough to open it with an editor.
You cap paste piece by piece into a Postgres prompt (psql or pgadmin or whatever
you're using).
You can then see at what point you get an error (and hopefully understand
wha
ect too. Just make sure that in ora2pg.conf
you put the lines:
ORACLE_DSN dbi:Oracle:host=myhost;sid=mysid
ORACLE_USER myuser
ORACLE_PWD mypass
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.
l and have used it successfully in the past:
http://ora2pg.darold.net/
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you should increase shared_memory to 40GB. General philosphy is to allocate 80%
of system memory to shared_memory
Uhm...
80% is too much, likely:
https://www.postgresql.org/docs/9.5/static/runtime-config-resource.html
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general
Sorry,
my mistake (I'm a bit nervous...)
that's not work_mem, but shared_buffers
Hi.
The resident set size of the worker processes includes all shared memory blocks
they touched.
So it's not that each of those workers allocated their own 3GB...
(in Linux at lea
Postgres version?
9.6.1
Have you considered upgrading to 9.6.2?
There were some fixes, including WAL related:
https://www.postgresql.org/docs/9.6/static/release-9-6-2.html
Not exactly regarding what you see, though...
Bye,
Chris.
--
Sent via pgsql-general mailing
Hi,
Tom Lane just pointed out that 9.6 is able to optimise this (at least
the synthetic example).
Anyway, my real problem could be beautifully improved by subselect-trick!
Thanks a lot!
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=9118d03a8
Hi,
thanks!
I've just tested with 9.6 and the test runs fast with or without expensive().
So the above patch does indeed improve this case a lot!
Bye,
Chris.
--
Sent via pgsql-general mailin
feel the planner is right and
there
must be a reason for this :)
Could someone help me understand this behaviour?
Thanks & Bye,
Chris.
-- ***
select version();
-- setup: create a time wasting function and a ta
On 15/03/2017 19:18, Andres Freund wrote:
Hi,
On 2017-03-15 18:29:06 +, Chris Withers wrote:
Shame the decoding has to be done on the server-side rather than the client
side.
Why?
Requiring compiled extensions to be installed on the server is always
going to be a pain, especially in
ver-side rather than the
client side.
Chris
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e the
number of matching rows and the set of|tag1|value that have a|tag2|value
of|t2val1|?
The closes I can get is:
|#selectcount(*),json_agg(tags)fromthing wheretags->'tag2'?'t2val1';count
|json_agg
---+--2|[{"tag1":["val1","val2"],"tag2":["t2val1"]},{"tag1":["val3","val1"],"tag2":["t2val1"]}](1row)|
...but I really want:
|count |tag1 ---+-2|["val1","val2","val3"](1row)|
cheers,
Chris
Thanks, this is closer, but regex really scares me for something like
this...
On 28/02/2017 17:19, Yasin Sari wrote:
Hi Chris,
Maybe there is an another better solution;
1. sending values into jsonb_array_elements to getting elements
(lateral join)
2. distinct to eliminate duplicates
3
e the
number of matching rows and the set of|tag1|value that have a|tag2|value
of|t2val1|?
The closes I can get is:
|#selectcount(*),json_agg(tags)fromthing wheretags->'tag2'?'t2val1';count
|json_agg
---+--2|[{"tag1":["val1","val2"],"tag2":["t2val1"]},{"tag1":["val3","val1"],"tag2":["t2val1"]}](1row)|
...but I really want:
|count |tag1 ---+-2|["val1","val2","val3"](1row)|
cheers,
Chris
discussed here on Feb 28- Mar 1 in Malmo. Those in the area who are
interested can book online at
https://edument.se/education/categories/sql/advanced-postgresql/book
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com
interested and in the Southern Sweden or Copenhagen areas,
please feel free to register at
https://www.eventbrite.com/e/postgresql-at-10-tb-and-beyond-tickets-30841174784
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http
se
plans are from two different queries.
There's also a user_name = 'dd' that has become a user_name = 'rdoyleda' ...
Ravi, could you please send the current query you're testing and the explain
analyze of that query on 9.5 and 9.6?
Bye,
Chris.
--
Sent vi
=1177.25..1177.26 rows=1 width=0)
[...]
I'm not seeing the "(actual ... )" part here.
THe plan you show is from an explain, not an explain analyze...
Can you provide the explain analyze output?
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgres
did NOT yet show the
complete actual query + plan.
All we saw is the explain analyze of the call to the procedure
function_cloud_view_orari(), but we
don't know what's happening inside the procedure.
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgres
On 12/12/2016 14:33, Adrian Klaver wrote:
On 12/11/2016 11:34 PM, Chris Withers wrote:
On 01/12/2016 12:12, Francisco Olarte wrote:
On Thu, Dec 1, 2016 at 12:56 PM, Chris Withers
wrote:
So, first observation: if I make room nullable, the exclude
constraint does
not apply for rows that have a
My recommendation. See them as tools in a toolkit, not a question of what
is best.
For places where you have SQL statements as primary do SQL or PLPGSQL
functions.
For places where you are manipulating values (parsing strings for example)
use something else (I usually use pl/perl for string mani
.
Thank you,
Chris
t a
loss to why. The indices and two explains follow below. Thanks in advance
for the help.
Cheers,
Chris
Indexes:
"blocks_pkey" PRIMARY KEY, btree (cloudidx, blkid)
"blocks_blkid_idx" btree (blkid)
"blocks_cloudidx_idx" btree (cloudidx)
"bl
27;;
>
> Result should be :
>Array_1 = {{1,2,3,4,5}};
>
Forgot to reply all (in case someone searches the archives later):
Array_1 :== Array_1 || Array[Array_2]
>
>
>
> --
> Regards :
> Venktesh Guttedar.
>
>
--
Best Wishes,
Chris Travers
Efficito
ray_1 = [][];
> Array_2 = '{1,2,3,4,5}';
>
> Result should be :
>Array_1 = {{1,2,3,4,5}};
>
>
> --
> Regards :
> Venktesh Guttedar.
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
column?
--
t
(1 row)
# SELECT '[{"tag1":"v1"}, {"tag1": "v2"}, {"tag1": "v3"}]'::jsonb @>
'[{"tag1": "v1"}]'::jsonb;
?column?
--
t
(1 row)
So, should I go for a tag name that
On 01/12/2016 12:12, Francisco Olarte wrote:
On Thu, Dec 1, 2016 at 12:56 PM, Chris Withers wrote:
So, first observation: if I make room nullable, the exclude constraint does
not apply for rows that have a room of null. I guess that's to be expected,
right?
I would expect it, give
inginfo.c:268
07:56:20 EST LOG: 0: disconnection: session time: 0:01:59.960 user=xxx
database=xx host=xxx.xxx.xxx.xxx port=57736
What is happening here? Is it of concern? Will tuning the DB memory parameters
help avoid this?
Thanks,
Chris
; --
> GPG key ID E4071346 @ eu.pool.sks-keyservers.net
> E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
e final file in RAM.
LOBs work best when you need a streaming interface (seek and friends) while
bytea's are otherwise much more pleasant to work with.
>
> Thanks very much for your insights,
>
> Rich
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org
> > 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/pgsq
/www.postgresql.org/docs/9.5/static/app-pgrewind.html
>
>
>
> Subhankar Chattopadhyay
> Bangalore, India
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/p
On Dec 7, 2016 5:07 PM, "Karsten Hilbert" wrote:
>
> On Wed, Dec 07, 2016 at 07:57:54AM -0800, Rich Shepard wrote:
>
> > I have used '-- ' to enter comments about tables or columns and am
curious
> > about the value of storing comments in tables using the COMMENT key
word.
> > When is the latter
his is pgdg postgres 9.5
>
1262 is 'pg_database'::regclass::oid
I don't know for sure but things I would worry about given the performance
profile are:
1. NUMA swap insanity
2. Accumulation of dead tuples leading to what should be very short
operations taking longer.
No idea of that is helpful but where I would probably start
> Thanks,
> Torsten
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
of the btree gist index backing the exclude constraint?
cheers,
Chris
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://www.thomas-guettler.de/
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
Hey Tom,
I appreciate you're busy, but did you ever get a chance to look at this?
On 19/09/2016 08:40, Chris Withers wrote:
On 16/09/2016 15:29, Tom Lane wrote:
Chris Withers writes:
On 16/09/2016 14:54, Igor Neyman wrote:
So, what is the value for "end ts", when the rec
Hey Tom,
I appreciate you're busy, but did you ever get a chance to look at this?
On 19/09/2016 08:40, Chris Withers wrote:
On 16/09/2016 15:29, Tom Lane wrote:
Chris Withers writes:
On 16/09/2016 14:54, Igor Neyman wrote:
So, what is the value for "end ts", when the rec
use an answer from StackOverflow without
full understanding the details...
Chris
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
order?
- have the load only apply the foreign key constraint at the end of each
table import?
cheers,
Chris
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ystem is slowed down until the credits recover. I could imagine that this way
some cyclic load patterns
emerge, if there is constant load on the machines.
Nhan, what instance types are you running?
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
ystem is slowed down until the credits recover. I could imagine that this way
some cyclic load patterns
emerge, if there is constant load on the machines.
Nhan, what instance types are you running?
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
ystem is slowed down until the credits recover. I could imagine that this way
some cyclic load patterns
emerge, if there is constant load on the machines.
Nhan, what instance types are you running?
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
w to use it.
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have another application that consumes all of the huge pages; they aren't
for pgsql. :) I've modified the configuration file from "try" to "off" and
munmap is no more. Mischief managed.
Thanks for your help.
On Tue, Oct 11, 2016 at 6:15 PM, Tom Lane wrote:
&g
]@[unknown] LOG: incomplete
startup packet
On Mon, Oct 10, 2016 at 5:21 PM, Tom Lane wrote:
> Chris Richards writes:
> > Setting up postgresql-9.5 (9.5.4-1.pgdg14.04+2) ...
> > Creating new cluster 9.5/main ...
> > config /etc/postgresql/9.5/main
> > data /
:1048576 kB
DirectMap4k: 83776 kB
DirectMap2M: 4110336 kB
DirectMap1G: 6291456 kB
On Mon, Oct 10, 2016 at 5:21 PM, Tom Lane wrote:
> Chris Richards writes:
> > Setting up postgresql-9.5 (9.5.4-1.pgdg14.04+2) ...
> > Creating new cluster 9.5/main ...
> > config /et
st
10 ?S 0:00 /usr/lib/postgresql/9.5/bin/postgres -D
/var/lib/postgresql/9.5/main -c
config_file=/etc/postgresql/9.5/main/postgresql.conf
Cheers,
Chris
On Mon, Oct 10, 2016 at 5:21 PM, Tom Lane wrote:
> Chris Richards writes:
> > Setting up postgresql-9.5 (9.5.4-1.
he
server.
Thanks,
Chris
h-ish unless you have a small value for
max_connection...
- 8.4.8 was released in 2011, the latest 8.4 release is 8.4.22, you'r missing
lots of patches (and 8.4 was EOLed more
than two years ago)
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On 16/09/2016 15:29, Tom Lane wrote:
Chris Withers writes:
On 16/09/2016 14:54, Igor Neyman wrote:
So, what is the value for "end ts", when the record is inserted (the range just
started)?
It's open ended, so the period is [start_ts, )
I've not looked at the GiST
of the indexed fields, or
just "value" ?
Yeah, it's a temporal table, so "updates" involve modifying the period
column for a row to set its end ts, and then inserting a new row with a
start ts running on from that.
Of course, the adds are just inserting new rows.
che
On 16/09/2016 12:00, John R Pierce wrote:
On 9/16/2016 3:46 AM, Chris Withers wrote:
when you do updates, are you changing any of the indexed fields, or
just "value" ?
Yeah, it's a temporal table, so "updates" involve modifying the period
column for a row to set its e
es. Profiling my python
code suggests that most of the time is being taken by Postgres (9.4 in
this case...)
What can I do to speed things up? Is there a different type of index I
can use to achieve the same exclude constraint? Is there something I can
do to have the index changes only done on
On 16/09/2016 14:54, Igor Neyman wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Withers
Sent: Friday, September 16, 2016 6:47 AM
To: John R Pierce ; pgsql-general@postgresql.org
Subject: Re: [GENERAL
On 16/09/2016 12:00, John R Pierce wrote:
On 9/16/2016 3:46 AM, Chris Withers wrote:
when you do updates, are you changing any of the indexed fields, or
just "value" ?
Yeah, it's a temporal table, so "updates" involve modifying the period
column for a row to set its e
of the indexed fields, or
just "value" ?
Yeah, it's a temporal table, so "updates" involve modifying the period
column for a row to set its end ts, and then inserting a new row with a
start ts running on from that.
Of course, the adds are just inserting new rows.
che
minutes. Profiling my python
code suggests that most of the time is being taken by Postgres (9.4 in
this case...)
What can I do to speed things up? Is there a different type of index I
can use to achieve the same exclude constraint? Is there something I can
do to have the index changes only d
>
> https://www.postgresql.org/docs/current/static/sql-insert.html
> <https://www.postgresql.org/docs/current/static/sql-insert.html> has
> more
> info.
>
>
> Thanks Chris!
>
> But the problem is that test2 table has 180 rows with different j_id and
&g
On 16/09/16 07:45, Patrick B wrote:
> Hi guys,
>
>
> I got the test1 table with three columns:
>
> id(BIGINT) - j_id(BIGINT) - comments(CHARACTER VARYING)
>
>
> *This needs to be done 180 times:*
>
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123321,'test-1
> - comments'
with the regexp is
run in parallel on 6 workers... this gives me a speed-up of a factor 4-5
(machine has 8 logical CPUs) and
the whole table fits in cache. For a use case as this, the parallel query
feature in 9.6 is so good it's almost
like cheating ;)
Bye,
Chris.
--
Sent via p
r
this colo between time x and y, etc).
I've deliberately tried to be abstract here as I'm trying to ask a
question rather than proposing a solution that might have problems, if
there's any more information that would help, please let me know!
cheers,
Chris
--
Sent via pgsql-
On Tue, Aug 16, 2016 at 3:11 PM, Merlin Moncure wrote:
> On Sun, Aug 14, 2016 at 5:58 AM, Chris Travers
> wrote:
>
> >>
> >> All this seems to be a huge change which will definitely not appear any
> >> time soon.
> >
> > I am willing to b
ou may load data from this
table to denormalized olap table once a day and build index there to speed-up
queries.
What kind of index is recommended here? The kind of queries would be:
- show me a list of tag types and the count of the number of events of
that type
- show me all events tha
r
this colo between time x and y, etc).
I've deliberately tried to be abstract here as I'm trying to ask a
question rather than proposing a solution that might have problems, if
there's any more information that would help, please let me know!
cheers,
Chris
--
Sent via pgsql-
On Sun, Aug 14, 2016 at 3:42 PM, Karsten Hilbert
wrote:
> Hello Chris,
>
> I am getting closer but ...
>
> > > > Sure. What I prefer to do is to allow for a (cacheable) lookup on
> the
> > > > basis of some criteria, either:
> > > > 1. F
bably end
you right back at the same amount of overhead as a temporary function.
>
> On Sun, Aug 14, 2016 at 10:42 AM, Chris Travers
> wrote:
>
>> If all you want is a temporary function, you *can* create it in the
>> pg_temp namespace though that seems hackish.
>>
On Sun, Aug 14, 2016 at 12:35 PM, Karsten Hilbert
wrote:
> On Fri, Aug 12, 2016 at 01:32:33PM +0200, Chris Travers wrote:
>
> >>> My preference is stored procedures plus service locators
> >>
> >> Would you care to elaborate a little on the latter (service lo
ure in foreseeable
> future :(.
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ers depending on environment and requirements but it is
a decent starting point.
>
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
>
On Fri, Aug 12, 2016 at 11:32 AM, Karsten Hilbert
wrote:
> På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers <
> chris.trav...@gmail.com[chris.trav...@gmail.com]>:
>
> > My preference is stored procedures plus service locators
>
> I know your work on the
be used to create a mapping layer generally.
But again, if you are primarily worried about development time, then that
is more important, usually, than information management as a whole.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Fri, Aug 12, 2016 at 10:58 AM, Andreas Joseph Krogh
wrote:
> På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers <
> chris.trav...@gmail.com>:
>
>
>
>
>>
>> Of course you *can* use them well. I remember talking about this with
>> one author o
On Fri, Aug 12, 2016 at 9:59 AM, Andreas Joseph Krogh
wrote:
> På fredag 12. august 2016 kl. 05:27:42, skrev Chris Travers <
> chris.trav...@gmail.com>:
>
>
>
> On Thu, Aug 11, 2016 at 10:20 PM, Andreas Joseph Krogh > wrote:
>>
>> På torsdag 11. august
--
> *Andreas Joseph Krogh*
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andr...@visena.com
> www.visena.com
> <https://www.visena.com>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On 04/08/2016 00:20, Tom Lane wrote:
Chris Withers writes:
I'm writing some multi-process code in Python and trying to make sure I
open a new connection for each process. Here's the really cut down code:
...
What's really surpising to me is the output on a m
ket(self->pgconn);:
https://github.com/psycopg/psycopg2/blob/master/psycopg/connection_type.c#L898
Is there something I'm missing about file descriptors on Macs or is
something bad happening here?
Chris
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Jul 28, 2016 at 8:09 PM, Edson Richter
wrote:
> Em 28/07/2016 13:07, Chris Travers escreveu:
>
>
>
> On Thu, Jul 28, 2016 at 3:38 PM, Scott Marlowe
> wrote:
>
>> On Wed, Jul 27, 2016 at 9:51 AM, Geoff Winkless
>> wrote:
>> > O
On Thu, Jul 28, 2016 at 6:32 PM, Alex Ignatov
wrote:
>
> On 28.07.2016 18:41, Igor Neyman wrote:
>
>> -Original Message-
>> From: Alex Ignatov [mailto:a.igna...@postgrespro.ru]
>> Sent: Thursday, July 28, 2016 11:26 AM
>> To: Igor Neyman ; Rakesh Kumar <
>> rakeshkumar46...@gmail.com>
>>
n index and table updates)?
>
> As someone who has gotten more than one bug fix from pgsql in less
> than 48 hours, I feel sorry for anyone who finds a bug in a MySQL
> version they are running in production.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
1 - 100 of 2251 matches
Mail list logo
