On 11/14/2017 11:30 PM, hmidi slim wrote:
> I'm trying to use the function to_jsonb and create the name:
> to_jsonb ('{"key1":" ' || 'text1' || '","key2":" ' || 'text2' || '"}');
This query converts a string into a JSON object that consist of that
string. I guess what you intend to accomplish is r
Hi,
On 2017-11-06 09:17, hmidi slim wrote:
> Hi,
> I want to know if I can combine multiple text search configurations when
> I tried to use FTS.
> Is there any options like this:
> *to_tsvector(['english', 'french'], document)*
> *
> *
> Trying to create a new text configuration:
> *Create text
On 2017-11-07 08:27, hmidi slim wrote:
> Hi,
> Thank for your proposition but when to use this query :
> (to_tsvector('english', document) || to_tsvector('french', document)) @@
> (to_tsquery('english', query) || to_tsquery('french', query))
> I think that the performance decrease and not a good
On 2017-11-07 08:27, hmidi slim wrote:
> Hi,
> Thank for your proposition but when to use this query :
> (to_tsvector('english', document) || to_tsvector('french', document)) @@
> (to_tsquery('english', query) || to_tsquery('french', query))
> I think that the performance decrease and not a good
Hi,
On 2017-11-06 09:17, hmidi slim wrote:
> Hi,
> I want to know if I can combine multiple text search configurations when
> I tried to use FTS.
> Is there any options like this:
> *to_tsvector(['english', 'french'], document)*
> *
> *
> Trying to create a new text configuration:
> *Create text
s test the function was
created as superuser).
```sql
CREATE OR REPLACE FUNCTION add_db1_user() returns void language sql
STRICT security definer AS $$
CREATE ROLE db1_testuser login password 'secret';
$$
ERROR: permission denied to create role
Best regards
Johannes
signature.asc
I guess I have seen all video recording from pgconf us 2015 at youtube.
Are there any recording from this year available?
Best regards Johannes
signature.asc
Description: OpenPGP digital signature
Am 09.02.2016 um 00:56 schrieb Vitaly Burovoy:
> On 2/8/16, Johannes wrote:
>> Am 08.02.2016 um 21:50 schrieb Vitaly Burovoy:
>>> On 2/8/16, Johannes wrote:
>>>> Am 08.02.2016 um 21:17 schrieb Vitaly Burovoy:
>>>>> Hmm. Could you clarify why you don
Am 08.02.2016 um 21:50 schrieb Vitaly Burovoy:
> On 2/8/16, Johannes wrote:
>> Am 08.02.2016 um 21:17 schrieb Vitaly Burovoy:
>>> On 2/8/16, Johannes wrote:
>>>> Am 08.02.2016 um 20:15 schrieb David G. Johnston:
>>>>> On Mon, Feb 8, 2016
Am 08.02.2016 um 21:33 schrieb Vitaly Burovoy:
> On 2/8/16, Johannes wrote:
>>
>> Am 08.02.2016 um 20:32 schrieb Vitaly Burovoy:
>>> On 2/8/16, Adrian Klaver wrote:
>>>> Based on rough guess of the above, without seeing actual table schemas:
>>
Am 08.02.2016 um 21:17 schrieb Vitaly Burovoy:
> On 2/8/16, Johannes wrote:
>> Am 08.02.2016 um 20:15 schrieb David G. Johnston:
>>> On Mon, Feb 8, 2016 at 12:05 PM, Johannes wrote:
>>>
>>>> Hi,
>>>>
>>>> is there a best practice
Am 08.02.2016 um 20:32 schrieb Vitaly Burovoy:
> On 2/8/16, Adrian Klaver wrote:
>> On 02/08/2016 11:05 AM, Johannes wrote:
>>> Imaging following situation: I want to receive two result sets from two
>>> tables, referring to a specific id from table t0 AND I tr
Am 08.02.2016 um 20:15 schrieb David G. Johnston:
> On Mon, Feb 8, 2016 at 12:05 PM, Johannes wrote:
>
>> Hi,
>>
>> is there a best practice to share data between two select statements?
>>
>> Imaging following situation: I want to receive two result set
returns multiple rows.
begin;
select id, col1, col2, ... from t0 where id = (select max(id) from t0
where col1 = value1 and col2 = value2 and ...);
select col1 from t1 where t0_id = (select max(id) from t0 where col1 =
value1 and col2 = value2 and ...);
commit;
Best regards Johannes
signature.asc
Am 25.01.2016 um 19:59 schrieb Daniel Verite:
> Johannes wrote:
>
>> \lo_export 12345 /dev/null is completed in 0.86 seconds.
>
> If it's an 11MB file through a 100Mbits/s network, that's
> pretty much the best that can be expected.
>
> I would th
Am 23.01.2016 um 23:38 schrieb John R Pierce:
> On 1/23/2016 2:19 PM, Johannes wrote:
>> I save my images as large object, which afaik is in practise not
>> readable with a binary cursor (we should use the lo_* functions). And of
>> course I already use the LargeObjectMana
Am 23.01.2016 um 01:25 schrieb Daniel Verite:
> Johannes wrote:
>
>> psql
>> select lo_get(12345);
>> +ssl -compression 6.0 sec
>> -ssl 4.4 sec
>
> psql requests results in text format so that SELECT does not
> really test the transfer
Am 21.01.2016 um 08:44 schrieb George Neuner:
> On Wed, 20 Jan 2016 22:29:07 +0100, Johannes wrote:
>
>> I noticed transferring a large object or bytea data between client and
>> server takes a long time.
>> For example: An image with a real size of 11 MB could be read on
6.0 sec
-ssl 4.4 sec
java/jdbc
only while(in.read(buf,0,len))
+ssl -compression 6.0 sec
-ssl 3.0 sec (+ 1.8 sec for new Image())
Here is a link for insecure ssl compression:
https://en.wikipedia.org/wiki/Comparison_of_TLS_implementations#Compression
Best Regargs
Johannes
application more quickly? Or are there planned improvements to
postgresql (transferring the real binary data)?
Best regards
Johannes
signature.asc
Description: OpenPGP digital signature
That solves my problem. Thanks!!
Best regards Johannes
Am 16.11.2015 um 18:19 schrieb Tom Lane:
> Adrian Klaver writes:
>> On 11/16/2015 08:03 AM, Johannes wrote:
>>>> In every loop I execute an update with a where LIKE condition, which
>>>> relates to my curre
A function seams to be atomic for the analyze command (or?)
EXPLAIN ANALYZE select my_function();
returns no inner query plan, just the costs, rows and width
Am 16.11.2015 um 17:57 schrieb Adrian Klaver:
> EXPLAIN ANALYZE select ... your_function(...);
signature.asc
Description: OpenPGP d
No, i did a mistake while simplifying it.
It should be
FOR i IN SELECT id, level, path_names||'%' as path_names from x LOOP
update x set path_ids[i.level] = i.id where path_names like i.path_names;
Sorry.
Best regards Johannes
Am 16.11.2015 um 15:10 schrieb Adrian Klaver:
> On 11/
behind the scenes no join is needed.
Best regards Johannes
Am 16.11.2015 um 15:22 schrieb Thomas Kellerer:
> Johannes schrieb am 16.11.2015 um 14:56:
>> I have problems with a self written function, which does not use the
>> index, which takes very long (500 ms per update).
>>
>
st because
like 'a.b%' uses the index of the path field ( ~ 15 ms ).
Does anyone know how to fix that?
Thanks, Johannes
signature.asc
Description: OpenPGP digital signature
On 13.03.2014 13:02, Magnus Hagander wrote:
> My guess is you're looking in the wrong place in the docs - can you specify
> where you are looking? If you are in the right place then the docs are
> wrong.
Here: http://www.postgresql.org/docs/8.4/static/sql-createtable.html
> Deferrable unique con
Hi list,
I'm having trouble with a UNIQUE constraint that I need to have
DEFERRABLE INITIALLY DEFERRED. On my Dev machine (Postgres 9.1) it works
fine:
alter table foo drop constraint bar;
ALTER TABLE
alter table foo add constraint bar UNIQUE (col1, col2) deferrable
initially deferred;
ALTER TAB
nt dit qu''il y aura peut-être plus
de 10 000 personnes'::text s) x;
select (ts_parse(3722,s)).*, (ts_debug(s)).* from (select 'heu
d''anar-hi'::text s) x;
Best
Johannes
[1] http://doxygen.postgresql.org/wparser__def_8c_source.html
[2] http://www.postgresql.org/d
Hi all,
On 12/11/2012 11:02 AM, Jan Kesten wrote:
>> I would very much appreciate a copy or a link to these slides!
> here they are:
>
> http://www.scribd.com/mobile/doc/61186429
>
thank you very much!
Johannes
--
Sent via pgsql-general mailing list (pgsql-general@postg
Hello Jan, hello List
On 12/11/2012 09:10 AM, Jan Kesten wrote:
> There are some sildes from Sun/Oracle about ZFS, ZIL, SSD and
> PostgreSQL performance (I can look if I find them if needed).
I would very much appreciate a copy or a link to these slides!
Johannes
--
Sent via pgsql-g
ng SEPostgreSQL?
Regards,
Johannes
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 2010-09-15 15:33, Tom Lane wrote:
=?ISO-8859-1?Q?Johannes_=D6berg?= writes:
I've set regex_flavor to ARE, and I've tried prefixing my strings, i.e.
~* E'***:abc' but for some reason postgres treats all my regexps as BRE's.
Well, the symptom as described seems pretty improbable. You didn't
Hi! I'm trying to do an advanced regexp match but postgres doesn't
seem to let me.
I've set regex_flavor to ARE, and I've tried prefixing my strings, i.e.
~* E'***:abc' but for some reason postgres treats all my regexps as BRE's.
Common newbie gotchas? I'm trying it directly from psql.exe bt
the naming follows this rule. Of course I
calculated the number of possible filenames before, but as I said, I was
not sure, that Postgresql follows a guaranteed naming convention of
always increasing WAL filenames.
Anyway, this is now for sure and I will rely on that now.
Regards Johannes
Greg Smith wrote:
On Wed, 13 Jun 2007, Johannes Konert wrote:
If someone corrects the servers computer-time/date to a date before
current time (e.g. set the clock two hours back), then the newer WAL
files will have an older timestamp and will be deleted by accident.
This should never happen
Johannes Konert wrote:
But during the day I came out with an solution: I store the WAL-files
with the time-stamp of archiving in their file-name. Thus I can order
and delete them safely.
Your hint was the one, that helped me to find that solution - so
thanks for that, Greg.and the others
Greg Smith wrote:
He's talking about wiping out the ones on the backup server, so I
think Johannes means erasing the old archived logs on the secondary
here. That can screw up your backup if you do it wrong, but it's not
an all-caps worthy mistake.
yes, that's what I am talkin
esql inner working model.
Regards Johannes
---(end of broadcast)---
TIP 6: explain analyze is your friend
hint. Suids are not working on bash-scripts, but with a
restricted entry in /etc/sudoers now the backup-user can execute a
copy-and-access-script to get the files from within PGDATA-dir.
Regards Johannes
---(end of broadcast)---
TIP 4: Have you sea
Joshua D. Drake wrote:
Johannes Konert wrote:
But that is not my point. The question is where I can change the
enforced chmod 700 postgresql always wants me to set.
You can't.
You can however change the postgresql.conf to put look for files
somewhere besides $PGDATA and thus you would be
/interactive/continuous-archiving.html
section 23.3.2) you can copy the files while postgres is running
(respecting pg_start_backup and pg_stop_backup)
But that is not my point. The question is where I can change the
enforced chmod 700 postgresql always wants me to set.
Regards Johannes
?
Anyway thanks for your help. I'll keep searching for a solution.
Regards Johannes
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that
) ?
Thanks for your short replies. I could not figure it out in the
documentation.
Regards Johannes
postgresql 8.2.4 on ubuntu dapper
(if this question came 100times, I apologize for being unable to find it)
---(end of broadcast)---
TIP 4: Have you
Tom,
thank you! from cvs I copied the latest "strategy" to make the sanity checks
and removed those values which were added after version 8.1.4. Using that patch, I can
compile postgres without any problems. This version runs nicely on several servers.
Best regards,
Johannes
compiling machine, I have (a clean) SuSE 8.2 running, the filesystem is
a xfs file system. The last version, Postgres 8.1.3, compiled nicely some time
ago.
Any ideas how I can fix this?
Best regards,
Johannes Weberhofer
--
|-
| weberhofer GmbH
45 matches
Mail list logo