e convenient to have datatypes for.
Being an open-source project I guess one must show initiative and start a
discussion on -hackers to see what interesst there's in having one in core. I
for one hope there will be.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 90
På tirsdag 14. november 2017 kl. 00:44:11, skrev Peter Geoghegan mailto:p...@bowt.ie>>:
On Mon, Nov 13, 2017 at 2:05 PM, Andreas Joseph Krogh
wrote:
> When sorting on text, we're usually doing so using an multi-column index,
like for instance "CREATE INDEX xxx ON my_tab
På mandag 13. november 2017 kl. 22:28:40, skrev Peter Geoghegan mailto:p...@bowt.ie>>:
On Mon, Nov 13, 2017 at 12:48 PM, Andreas Joseph Krogh
wrote:
> Thanks.
As the person that worked on abbreviated keys, I'd like to hear about
how you get with this. How much faster is it for
should be quite a bit of debug output from that that
specifically mentions abbreviated keys.
Thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På mandag 13. november 2017 kl. 21:40:47, skrev Peter Geoghegan mailto:p...@bowt.ie>>:
On Mon, Nov 13, 2017 at 11:48 AM, Andreas Joseph Krogh
wrote:
> Ok, so I have to explicitly specify like this:
>
> create table test(id serial primary key, name varchar collate "nb_NO
På mandag 13. november 2017 kl. 19:07:53, skrev Peter Geoghegan mailto:p...@bowt.ie>>:
On Mon, Nov 13, 2017 at 12:27 AM, Andreas Joseph Krogh
wrote:
> In PG-10, with ICU enabled, is abbreviated keys now enabled?
Yes. ICU will use abbreviated keys on every platform, including Window
Hi.
In PG-10, with ICU enabled, is abbreviated keys now enabled?
If so, using locale=nb_NO.UTF-8, do I have to use a ICU-specific locale to
take advantage of abbreviated keys?
Thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:a
so did a few more databases using the same steps and they all appeared to
be smaller. Is that normal?
Yep.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
Hi.
There was a while ago a proposed patch for adding
$subject; https://commitfest.postgresql.org/8/454/
Is this being worked on? Any progress in btree-support?
--
Andreas Joseph Krogh
anup job can know the difference between such an INSERT-entry
in origo_email_message_file_operation caused by ROLLBACK and and INSERT-entry
caused by an in-progress insertEmail() operation.
Does anyone have a robust mechanism for cleaning up files in such scenarios?
Thanks.
-- Andre
På søndag 25. juni 2017 kl. 23:02:32, skrev Adrian Klaver <
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>:
On 06/25/2017 01:34 PM, Andreas Joseph Krogh wrote:
> På søndag 25. juni 2017 kl. 17:04:02, skrev Adrian Klaver
> mailto:adrian.kla...@aklaver.com>>:
nment
for developing PG-extentions, not linking Qt in from an extention.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
ing with large objects and streaming to clients
(JDBC). The only solution (I've found) which doesn't explode in memory-usage is
using LOs (OIDs). Note that we're dealing with multi-gigabytes objects, which
need to be "transactional safe" (hence stored in the DB).
--
successfully using logical decoding, correct?
> > I wish PG in some future version will address these quirks so one can
operate on LOs more smoothly.
You're welcome to help...
Every time issues arise regarding LOs there seems to be little interest to
improve matters, and if it do
På torsdag 22. juni 2017 kl. 15:25:20, skrev Achilleas Mantzios <
ach...@matrix.gatewaynet.com <mailto:ach...@matrix.gatewaynet.com>>:
On 22/06/2017 13:38, Andreas Joseph Krogh wrote:
På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios <
ach...@matrix.gatewaynet.
På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios <
ach...@matrix.gatewaynet.com <mailto:ach...@matrix.gatewaynet.com>>:
On 22/06/2017 11:21, Andreas Joseph Krogh wrote:
Hi.
1. Why should one prefer built-in logical replication in pg-10 to pglogical,
does it do anythi
pglogical replicate large objects? I
cannot find any notes about large-objects under "Limitations and
Restrictions":
https://www.2ndquadrant.com/en/resources/pglogical/pglogical-docs/
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <ma
e you made any progress making it work for btree?
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
his indicates that the folder_id column, which is part of the index, isn't
actually "part of the index", meaning it's not used in the index for some
reason.
Can you tell me how to craft an index so that folder_id = ANY
('{44965,2470520}'::bigint[]) is part of t
ge-repo. Maybe you'll have more luck asking that other places than a
PG-mailing-list.
--
Andreas Joseph Krogh
of failure just to replace them back.
Is it doable? How?
What about just re-installing the previous version the same way you installed
the "patch-release"-version?
--
Andreas Joseph Krogh
Ping...
Any feedback is welcome, thanks.
På torsdag 12. januar 2017 kl. 13:13:34, skrev Andreas Joseph Krogh <
andr...@visena.com <mailto:andr...@visena.com>>:
Hi PostgresPro-guys.
I've asked this before but didn't get any response, so I'll try again. I know
ou give an example with definition of index
and explain-plan?
It would be interesting to see how this performs vs. contrib/intarray.
Thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
p often is't enough
because often there is some other dimention which is *very* relevant to limit
the results (like what folder, or account, to search for email-messages in,
instead of searching for all in the system).
Thanks.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +
ified);
Am I missing something?
Yes, you've not shown us:
1. The query
2. The schema
3. Complete EXPLAIN-output
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På lørdag 07. januar 2017 kl. 18:25:42, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>:
Andreas Joseph Krogh writes:
> På lørdag 07. januar 2017 kl. 17:48:49, skrev Tom Lane <mailto:t...@sss.pgh.pa.us>>:
> If you've got just one problem query, it might be worth your ti
På lørdag 07. januar 2017 kl. 17:48:49, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>:
Andreas Joseph Krogh writes:
> I wonder; In general, is there any downside of having join_collapse_limit =
14
> on modern hardware (32 cores, 64GB RAM), and geqo_threshold=16 ?
> I'm aw
s and performance was acceptable again.
I wonder; In general, is there any downside of having join_collapse_limit = 14
on modern hardware (32 cores, 64GB RAM), and geqo_threshold=16 ?
I'm aware of it increasing planning-time, but is this really an issue in
practice?
Thanks.
-- Andreas Joseph
//www.jetbrains.com/datagrip/
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På tirsdag 20. desember 2016 kl. 11:42:56, skrev Achilleas Mantzios <
ach...@matrix.gatewaynet.com <mailto:ach...@matrix.gatewaynet.com>>:
On 20/12/2016 12:27, Andreas Joseph Krogh wrote:
På tirsdag 20. desember 2016 kl. 11:02:27, skrev Achilleas Mantzios <
ach...@matrix.gatewaynet.
På tirsdag 20. desember 2016 kl. 11:02:27, skrev Achilleas Mantzios <
ach...@matrix.gatewaynet.com <mailto:ach...@matrix.gatewaynet.com>>:
On 20/12/2016 11:43, Andreas Joseph Krogh wrote:
[snip]
BEGIN;
ALTER TABLE person ADD CONSTRAINT person_pk PRIMARY KEY (entity_id);
alter table
OUP BY person.id which now should use
GROUP BY person.entity_id, and not having to also list all other columns
selected from the person-table.
How do I proceed with this?
Thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
You can leave authentication to something else. For example authenticate
the users by having them connect to pgBouncer first.
-Joseph
On Fri, Dec 16, 2016 at 11:17 AM, Andomar wrote:
> We run a master server and a hot standby server. Reporting users login to
> the standby server to ru
Yes, I have a tendency to use emacs sub-shells (and occasionally M-x
sql-postgres)--
I thought I'd reproduced the behavior in an xterm, but I was just
trying again and I don't see it. It does seem that the dumbness of my
dumb terminal is a factor.
If I understand the way this works, it could be
But on the other hand, if you've got a blank PAGER envar and a "\pset
pager something", the pset should win (just as it does now).
On Tue, Dec 6, 2016 at 1:53 PM, Joseph Brenner wrote:
> Well, my take would be that if you've taken the trouble to set an
> empty stri
Well, my take would be that if you've taken the trouble to set an
empty string as the PAGER that means something, and it probably means
you don't want any pager to be used.
But then, I would say that.
On Tue, Dec 6, 2016 at 12:13 PM, Tom Lane wrote:
> Joseph Brenner writes:
>
;
sh: 1: nadatech: not found
So the empty PAGER value case is the only one that doesn't seem
covered already. (I'm talented about finding these things...)
On Tue, Dec 6, 2016 at 9:51 AM, Tom Lane wrote:
> Joseph Brenner writes:
>> Looking back on the order of events, I th
tion, so I
didn't worry about it.
So yeah, some better messaging when PAGER is mangled wouldn't hurt, if
that's possible. Falling back to "pager off" would make sense to me.
On Mon, Dec 5, 2016 at 9:28 PM, Joseph Brenner wrote:
> Well yeah, trying to run a PAGER
#x27;postgres' always worked.
On Mon, Dec 5, 2016 at 9:03 PM, David G. Johnston
wrote:
> On Mon, Dec 5, 2016 at 9:53 PM, Joseph Brenner wrote:
>>
>> And I guess I did that intentionally, my .bashrc has
>>
>> # I use emacs shells, I got a "pager"
And I guess I did that intentionally, my .bashrc has
# I use emacs shells, I got a "pager" already:
export PAGER=''
On Mon, Dec 5, 2016 at 8:52 PM, Joseph Brenner wrote:
> Wait, that's not quite right. The user 'postgres' has no PAGER envar,
> but
Wait, that's not quite right. The user 'postgres' has no PAGER envar,
but user 'doom' has an empty value:
PAGER=
On Mon, Dec 5, 2016 at 8:50 PM, Joseph Brenner wrote:
>> So what does:
>>
>> env | grep PAGER
>>
>> show?
>
>
> So what does:
>
> env | grep PAGER
>
> show?
Nothing. I have no PAGER settting (I don't normally use one).
On Mon, Dec 5, 2016 at 5:33 PM, Adrian Klaver wrote:
> On 12/05/2016 05:13 PM, Joseph Brenner wrote:
>
>
>> I just went around temporarily undoing th
16:17:04 PST [18517-3] doom@doom LOG: statement: set
client_encoding to 'unicode'
Because I also had this line:
\encoding unicode
On Sun, Dec 4, 2016 at 9:51 AM, Tom Lane wrote:
> Joseph Brenner writes:
>>> So what happens when you specify the port in your psql conn
4# (change requires restart)
/etc/postgresql/9.4/main/postgresql.conf
port = 5432# (change requires restart)
On Sun, Dec 4, 2016 at 7:06 AM, Adrian Klaver wrote:
> On 12/03/2016 09:38 PM, Joseph Brenner wrote:
>>>
>>> So is the 9.4 instance the pr
but the 2016 Jaguar XF MPG gets 24 mpg.
-- Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
Samuel,
Please note that the accepted convention in this forum is to bottom post.
Please do not top post.
The accepted convention in this forum is to not have purple signature:-)
-- Andreas Joseph Krogh
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5434"?
On Sat, Dec 3, 2016 at 9:11 PM, Adrian Klaver wrote:
> On 12/03/2016 07:38 PM, Joseph Brenner wrote:
>>
>> Our story thus far: I've now got three different pg in
;
yo
doom=# \! ls -lad p*
drwxr-xr-x 1 doom doom 12 Nov 16 12:29 perl5
On Sat, Dec 3, 2016 at 7:48 PM, David G. Johnston
wrote:
> On Saturday, December 3, 2016, Joseph Brenner wrote:
>>
>>
>> doom=# select 'hello' as world;
>> doom=#
>>
>> Noth
d libpq?
ldd /usr/lib/postgresql/9.4/bin/psql | egrep libpq
libpq.so.5 => /usr/lib/x86_64-linux-gnu/libpq.so.5 (0x7fe9db2ea000)
ldd /usr/lib/postgresql/9.6/bin/psql | egrep libpq
libpq.so.5 => /usr/lib/x86_64-linux-gnu/libpq.so.5 (0x7fa7337ec000)
On Sat, Dec 3, 2016 at 4:51
ling is that can't be the
problem, but I'll probably look into some more (Tom Lane seems to feel
there might be an issue there).
On Sat, Dec 3, 2016 at 4:46 PM, Adrian Klaver wrote:
> On 12/03/2016 02:55 PM, Joseph Brenner wrote:
>>
>> The version in the Debian stable
Yes, and sorry about the re-post. I thought my original message was
hung-up in moderation, so I was doing an unsub/resub fandango to get
email addresses to match.
On Sat, Dec 3, 2016 at 12:13 PM, Adrian Klaver
wrote:
> On 12/03/2016 12:08 PM, Joseph Brenner wrote:
>>
>> I'm
> Any unusual errors in the logs? Or maybe a "\o /somefile" in your
~doom/.psqlrc?
No, nothing much in the logs after "autovacuum launcher started", and
I don't have a .psqlrc file.
On Sat, Dec 3, 2016 at 6:56 AM, Julien Rouhaud
wrote:
> On Wed, Nov 30, 2016 at 0
-D /usr/local/pgsql/data >
/var/lib/postgresql-9.6.1/logfile 2>&1 &
On Sat, Dec 3, 2016 at 7:23 AM, rob stone wrote:
>
> On Wed, 2016-11-30 at 20:48 -0800, Joseph Brenner wrote:
>> I'm trying to get a new build of 9.6.1 working on a machine
>> running Debi
he same way as login 'doom' or login
'postgres':
/usr/local/pgsql/bin/psql --dbname=doom --username=doom
On Sat, Dec 3, 2016 at 7:10 AM, Adrian Klaver wrote:
> On 11/30/2016 08:48 PM, Joseph Brenner wrote:
>>
>> I'm trying to get a new build of 9.6.1 wo
I'm trying to get a new build of 9.6.1 working on Debian
stable and I'm seeing some odd behavior where things work
correctly if I run psql when logged in as user 'postgres',
but if I'm logged-in as user 'doom' (my usual login), I don't
seem to have any select privileges. Even this fails
silently:
I'm trying to get a new build of 9.6.1 working on a machine
running Debian stable (jessie) and I'm seeing some odd
behavior where things work correctly if I run psql when
logged in as postgres, but if I run it as user 'doom' (my
usual login), I don't seem to have any select privileges.
Even this fa
e problem with "no" seems to be the same.
One can always specify 'simple' as the config, eliminating any "stop-wprd
smartness":
andreak=> select to_tsquery('simple', 'a:*');
to_tsquery
'a':*
(1 row)
-- Andreas Joseph Krogh
På tirsdag 15. november 2016 kl. 08:48:37, skrev Oleg Bartunov <
obartu...@gmail.com <mailto:obartu...@gmail.com>>:
On Tue, Nov 15, 2016 at 10:37 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: This item isn't valid, is it?
* There isn't phrase
search was introduced, this isn't really true, or am I
missing something?
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
AND folder_id = ANY(
ARRAY[2,3]::BIGINT[]) ORDER BY received_timestamp DESC LIMIT 10;
Thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På onsdag 09. november 2016 kl. 15:54:13, skrev Adrian Klaver <
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>:
On 11/08/2016 06:45 PM, Andreas Joseph Krogh wrote:
> På onsdag 09. november 2016 kl. 03:02:54, skrev John R Pierce
> mailto:pie...@hogranch.com>
enance_work_mem is used by vacuum and create index operations
(including implicit index creation such as add foreign key).
There is no such thing in PG.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
+ dopt.outputBlobs = false;
+ break;
Then this IF sets it back to TRUE:
+ if (dopt.include_everything && !dopt.schemaOnly && !dopt.outputBlobs)
dopt.outputBlobs = true;
...making it impossible to turn off dumping of blobs.
-- Andr
is working.
Are there some plans to make dumping large tables (typically LOs) benefit from
parallelism?
Thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
t getting this in master is of
course the best.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh <
andr...@visena.com <mailto:andr...@visena.com>>:
På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge <
guilla...@lelarge.info <mailto:guilla...@lelarge.info>>:
2016-03-08 21:06 GMT+01
På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge <
guilla...@lelarge.info <mailto:guilla...@lelarge.info>>:
2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh mailto:andr...@visena.com>>: På tirsdag 08. mars 2016 kl. 21:03:01, skrev
David G. Johnston mailto:david.g.
På tirsdag 18. oktober 2016 kl. 12:39:03, skrev Magnus Hagander <
mag...@hagander.net <mailto:mag...@hagander.net>>:
On Thu, Oct 13, 2016 at 7:35 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På torsdag 13. oktober 2016 kl. 16:09:34,
skrev Bruce Momjian mailt
På torsdag 13. oktober 2016 kl. 16:09:34, skrev Bruce Momjian mailto:br...@momjian.us>>:
On Thu, Oct 13, 2016 at 10:14:08AM +0200, Andreas Joseph Krogh wrote:
> I would assume that having pg_largeobject in a separate tablespace is more
and
> more common these days, having real-
velopment of pg_upgrade to cope with this
configuration or somehow motivate to getting this issue fixed?
Would any of the PG-companies (2ndQ, EDB, PgPro) take a stab at this?
Any feedback welcome, thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
gle Drive link on your email
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På onsdag 24. august 2016 kl. 18:36:16, skrev Francisco Olarte <
fola...@peoplecall.com <mailto:fola...@peoplecall.com>>:
On Wed, Aug 24, 2016 at 6:26 PM, Scott Marlowe wrote:
> On Wed, Aug 24, 2016 at 6:05 AM, Andreas Joseph Krogh
>> Are there any plans to lift this restr
Hope some -hackers read this...
Are there any plans to lift this restriction?
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
ght make
sense depending on how much control you have on your DB, domain-model, code,
developers etc.
I don't have any pointers describing this separation tho, try asking Mr.
Google, that's what I'd do.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909
e when evaluating ORMs or having an
opinion about them. Being in the latter, I more understand you concerns.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers <
chris.trav...@gmail.com <mailto:chris.trav...@gmail.com>>:
On Fri, Aug 12, 2016 at 9:59 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 12. august 2016 kl. 05:27:42,
skrev Chris Travers
På fredag 12. august 2016 kl. 05:27:42, skrev Chris Travers <
chris.trav...@gmail.com <mailto:chris.trav...@gmail.com>>:
On Thu, Aug 11, 2016 at 10:20 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På torsdag 11. august 2016 kl. 19:13:08,
skrev support
På torsdag 11. august 2016 kl. 19:13:10, skrev Artur Zakirov <
a.zaki...@postgrespro.ru <mailto:a.zaki...@postgrespro.ru>>:
On 07.08.2016 11:05, Andreas Joseph Krogh wrote:
> På søndag 07. august 2016 kl. 08:27:06, skrev Oleg Bartunov
> mailto:obartu...@gmail.com>>:
>
X or
framework Y popus up doesn't mean the PG-project should maintain drivers for
them or support them.
So - yes, it would be great if all the drivers for all languages would be made
as reliable and clearly documented as the most supported ones.
-- Andreas Joseph Krogh
CTO / Partner
11-20 15:41:04.936
200744 | 66655 | 2013-01-28 21:47:44.561
1445927 | 888665 | 2015-09-29 00:26:56
123671 | 83509 | 2012-11-21 14:16:26.448
1129928 | 66658 | 2015-05-09 08:39:14.128
(10 rows)
Neither are ordered by received_timestamp
Can you explain how to get OR
På lørdag 06. august 2016 kl. 20:54:32, skrev Artur Zakirov <
a.zaki...@postgrespro.ru <mailto:a.zaki...@postgrespro.ru>>:
Hello, 2016-08-02 21:08 GMT+03:00 Andreas Joseph Krogh mailto:andr...@visena.com>>: The ORDER BY part seems strange; It seems one
has to find a value &qu
is this correct?
It would be great if the docs explained this.
I really miss the opportunity to include a BIGINT as part of the index, so
that the WHERE-clause could be like this:
WHERE del.fts_all @@ to_tsquery('simple', 'andreas&kr') AND del.folder_id IN (1
,2,3)
Having t
On Mon, Aug 1, 2016 at 5:21 PM, Jeff Janes wrote:
> On Mon, Aug 1, 2016 at 1:32 PM, John McKown
> wrote:
> > On Mon, Aug 1, 2016 at 2:49 PM, Jeff Janes wrote:
> >>
> >> On Mon, Aug 1, 2016 at 11:40 AM, Joseph Kregloh <
> jkreg...@sproutloud.com>
> >
oating the question
anyways in hope of suggestions.
-Joseph
on.
Thanks
Mohammed Abdul Azeem
It would make it easier for us to help you if you asked a specific question.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På mandag 27. juni 2016 kl. 13:20:03, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:
On Fri, Jun 24, 2016 at 2:36 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: Hi.
@PostgresPro; Will there be any updates to the rum git-repo any time soon?
Sure.
I under
s you plan to implement (for
equalty and sorting). Will there be some kind of btree_rum like there is for
btree_gin, to add RUM-support for the types there exists Btree-support for?
Thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com &l
På fredag 17. juni 2016 kl. 15:47:08, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:
On Fri, Jun 17, 2016 at 3:52 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 17. juni 2016 kl. 13:53:34, skrev
Oleg Bartunov mailto:obartu...@gmail.com>>:
On Fr
På fredag 17. juni 2016 kl. 13:53:34, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:
On Fri, Jun 17, 2016 at 2:10 PM, Oleg Bartunov mailto:obartu...@gmail.com>> wrote: On Fri, Jun 17, 2016 at 9:32 AM,
Andreas Joseph Kroghmailto:andr...@visena.com>> wrote: På
torsda
På torsdag 16. juni 2016 kl. 00:50:45, skrev Jeff Janes mailto:jeff.ja...@gmail.com>>:
On Wed, Jun 15, 2016 at 3:56 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: Hi.
First; Is this the correct forum to ask questions about the Postgres Pro's new
RUM-index?
If not
På onsdag 15. juni 2016 kl. 15:27:32, skrev David G. Johnston <
david.g.johns...@gmail.com <mailto:david.g.johns...@gmail.com>>:
On Wed, Jun 15, 2016 at 6:56 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote:
Hi.
First; Is this the correct forum to ask questions about
have "folder_id" as part of the RUM-index so
that I can search inan array of folders using the index, AND have the whole
result sorted by "sent"-timestamp also using the RUM-index.
In the (limited) documentation sorting using timestamp is done like this:
ORDER BY
On Tue, May 31, 2016 at 4:12 PM, Alvaro Herrera
wrote:
> Joseph Kregloh wrote:
> > It is my understanding that if PostgeSQL has log shipping enabled, if for
> > whatever reason it cannot ship the file the master server will hold it.
> But
> > for how long?
>
>
ain in sync when one is restarted I would need
to modify my script to return an error or false to PostgreSQL, this way it
will hold the WAL files until both Slaves are online. Correct?
Thanks,
-Joseph
p of the rum:-)
It's not easy to fix this. We don't want rum depends on btree_gin, so
probably the easiest way is to have separate operator <=> in rum.
+1 for separate operator!
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.co
På mandag 30. mai 2016 kl. 22:27:11, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:
On Sun, May 29, 2016 at 12:59 AM, Oleg Bartunov mailto:obartu...@gmail.com>> wrote: On Thu, May 26, 2016 at 11:26 PM,
Andreas Joseph Kroghmailto:andr...@visena.com>> wrote: Hi.
A
grespro/rum/issues/1
Would be cool to see this fixed so I actually could have a sip of the rum:-)
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På lørdag 28. mai 2016 kl. 23:59:55, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:
On Thu, May 26, 2016 at 11:26 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: Hi.
Any news about when slides for $subject will be available?
I submitted slides to pgcon site, bu
Hi.
Any news about when slides for $subject will be available?
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
På torsdag 12. mai 2016 kl. 10:05:01, skrev Andreas Joseph Krogh <
andr...@visena.com <mailto:andr...@visena.com>>:
[snp] I created this test:
create table ja_jobs(id bigserial primary key, title varchar not null,
clientid bigint not null, time_job bigint not null);
På torsdag 12. mai 2016 kl. 09:57:58, skrev Andreas Joseph Krogh <
andr...@visena.com <mailto:andr...@visena.com>>:
På torsdag 12. mai 2016 kl. 02:30:33, skrev Lucas Possamai <
drum.lu...@gmail.com <mailto:drum.lu...@gmail.com>>:
Hi there!
I've got a simple but s
1 - 100 of 533 matches
Mail list logo
