ngly
favoring the latter, as if it hadn't its own problems.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
PGPASSWORD
environment variable, avoiding creating .pgpass in any form?
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
ase that other databases in the new
instance have consumed OIDs and some happen to be equal to the ones
you want to import in a new database, that doesn't matter: similar OIDs
won't conflict if they're in different databases or even the same
database but different tables.
Be
Aside from that, inherited connections can't be used
simultaneously by parent and child process.
In general, a child process should open and close
its own connection.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-gene
" with payload "bar" received from
server process with PID 20033.
which just needs to be piped into another step that runs your custom
action.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general m
Hi Andreas,
in my pgbouncer configured as:
;auth_file=/test/user.txt
auth_query = SELECT usename, passwd FROM pg_shadow WHERE usename=$1
Of course. When try connect with command " psql -p postgres -U dba"
Print erro in screen.
psql: ERROR: No such user: dba
But, exists user and passwd in
?
Yes. Aside from fetching from a binary cursor, I don't think there
is any other way to get binary results from a PQexec() call.
In particular, bytea columns come back encoded as text
according to the bytea_output setting.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.
in binary format.
The point is that using PQexec() does not strictly mean that the results
are in text, as it depends on the query itself. This might be
significant if there's a requirement that your code has to work
with any query.
Best regards,
--
Daniel Vérité
PostgreSQL-powe
Recently, I've been doing a research about data warehouse optimizations and
techniques. For example, Oracle uses parallel queries, materialized views
with different refresh modes, star transformations in queries, etc. Since
I've never worked with PostgreSQL in an OLAP environment, I thought maybe
t
>How could an application which gets written from scratch use PostgreSQL to
>implement
>row based permissions?
Are you looking for this?
https://www.postgresql.org/docs/9.6/static/ddl-rowsecurity.html
Regards
Daniel
n filters, dropped zero bytes, dropped high
bits, or parity changes.)
...
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
And if it was a transient read error, a second run of the import
could even work. I don't quite see from your posts whether that
particular file to import was tried and failed only once or retried
and failed again.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.man
ng.
If that's the case and only byte is wrong in the whole file, you could
theorically fix it by finding the offset of the offending length and patch
the wrong byte with a 0xff value.
[1]
https://en.wikipedia.org/wiki/Hard_disk_drive#Error_rates_and_handling
Best regards,
--
Daniel
th to enhance the documentation for this, at least for
synchronous_commit=true? The asynchronous behavior is well documented here:
https://www.postgresql.org/docs/current/static/wal-async-commit.html.
Again, thanks David and Adrian for your help
Kind Regards
Daniel
>On 06/23/2017 05:50 AM, Daniel Westermann wrote:
>> Hi all,
>>
>> as I did not find the answer in the documentation: Which background
>> process is actually doing the writes/flushes to the WAL? In the docs
>> ( https://www.postgresql.org/docs/10/stat
-processes-explained/)
this seems not to be true, right? Why do I need the wal_writer at all then when
synchronous_commit is set to something else than off?
Thanks for your help
Daniel
cess/user/command
deletes the file and when would be obtained with:
# ausearch -k pgpid
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
\lo_import command and see how much time it takes?
That would give a baseline to compare against.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
please share what issues you had when upgrading and maybe how you
solved it? I'd love to include as much information as possible.
Thanks in advance
Daniel
7;s PQconnectdb().
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ave only Apache use /var/pgsql ?
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lesystem-root of that process with
# ls -ld /proc/$PID/root
It should show a soft link to the directory that corresponds to
the root from the point of view of the $PID process.
But again, most people would use host=localhost in this setup.
Best regards,
--
Daniel Vérité
PostgreSQL-powered maile
GSQL.5432"?
If apache is chrooted, or secured by other means with the similar result
that it cannot access the full filesystem, that's expected.
In this case, connecting to localhost with TCP/IP rather than a Unix domain
socket looks like the simpler solution.
Best regards,
--
D
the httpd service lives in another namespace,
e.g. it's chrooted. What if you try:
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
; Note that this also applies to the other two conf files.
When using the abovementioned commands you don't need or want
to do that, because /etc/postgresql// is the
only place they're going to be in.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-
Daniel Westermann writes:
>> Thank you, Merlin. As said I know that "not in" is not a good choice in this
>> case but I still do not get what is going here. Why does the >> repeatedly search for NULL values when I decrease work_mem and why not when
>> increas
2017-04-05 10:33 GMT+02:00 Daniel Westermann <
daniel.westerm...@dbi-services.com > :
2017-04-05 10:13 GMT+02:00 Daniel Westermann <
daniel.westerm...@dbi-services.com > :
BQ_BEGIN
2017-04-05 9:28 GMT+02:00 Daniel Westermann <
daniel.westerm...@dbi-services.com > :
B
2017-04-05 10:13 GMT+02:00 Daniel Westermann <
daniel.westerm...@dbi-services.com > :
2017-04-05 9:28 GMT+02:00 Daniel Westermann <
daniel.westerm...@dbi-services.com > :
BQ_BEGIN
>>what is result of EXPLAIN statement for slow and fast cases?
>>
>>regar
2017-04-05 9:28 GMT+02:00 Daniel Westermann <
daniel.westerm...@dbi-services.com > :
>>what is result of EXPLAIN statement for slow and fast cases?
>>
>>regards
>>
>>Pavel
For work_mem=32MB
explain (analyze,verbose,buffers) select count(user_
>>what is result of EXPLAIN statement for slow and fast cases?
>>
>>regards
>>
>>Pavel
For work_mem=32MB
explain (analyze,verbose,buffers) select count(user_id) from users where
user_id not in ( select id from ids);
QUERY PLAN
-
le to search for
>the presence of null values. Try converting the query to NOT EXISTS.
Thank you, Merlin. As said I know that "not in" is not a good choice in this
case but I still do not get what is going here. Why does the server repeatedly
search for NULL values when I decrease work_mem and why not when increasing
work_mem?
Regards
Daniel
gsql_tmp/pgsql_tmp17817.2
What do I miss here? Shouldn't this complete with 16MB work_mem as well, even
when slower, but in less than one hour? Or is this expected?
Thanks for your help
Daniel
documentation but not in the help output
Regards
Daniel
store to connect to some
>database, >whereas there's no big deal with psql connecting to a default
>database.
Ok, makes sense. Thanks all for your answers
Regards
Daniel
ingful message at least:
postgres@pgbox:/home/postgres/ [PG961] pg_restore -h localhost -p === -d
postgres -F d -C /var/tmp/exp/
pg_restore: [archiver (db)] connection to database "postgres" failed: invalid
port number: "==="
Maybe it is only me, but this is not consistent behavior, is it?
Regards
Daniel
It does
Sent from my Phone
> On 21 Dec 2016, at 18:40, Andreas Kretschmer wrote:
>
>
>
>> Am 21.12.2016 um 18:22 schrieb Daniel Westermann:
>>
>>
>> Now I try to import into 9.6.1 => the instance is not running but the
>> environment is set:
any port to pg_restore and it just seems to be fine.
Even this seems to working (the copy from stdin is displayed on the screen):
postgres@pgbox:/home/postgres/ [PG961] pg_restore -h localhost -p === -F d
-C /var/tmp/exp/
Thanks
Daniel
term command/mode that provides a
more sophisticated screen emulation into which paging seems
to work exactly like in a normal terminal and the emacs key bindings
are turned off.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
elect pg_typeof(count(1));
pg_typeof
---
bigint
(1 row)
Can you check if your code does work when the query is simply
SELECT 1::bigint ?
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list
ithic pg_largeobject
would likely be problematic.
Ideally there should be an extension implementing something like
DATALINK (SQL99), with external storage. I wonder if an extension
could provide custom WAL records replicating content changes to the
external storage of a standby. That would be awesom
Hi,
just noticed that the links from 6.3 to 7.1 are broken here:
https://www.postgresql.org/docs/manuals/archive/
Regards
Daniel
agewise through text files
SYNOPSIS
pg [-number] [-p string] [-cefnrs] [+line] [+/pattern/] [file...]
...
Also, the same Debian/Ubuntu systems don't have initdb or pg_ctl
in the default $PATH, as these commands are superseded
by different distro-specific pg_* commands . This is also
somet
Hi Ankit,
You might have specific requirements to need PG 9.6. But if 9.5 is
sufficient, it will be easier to simply do a rpm/yum install.
Regards,
Daniel
On Tue, Oct 25, 2016 at 4:08 AM, Ankit Sablok wrote:
> Thanks for replying Tom and Asif, I think the issue was that libpq.so
> pres
Try this:
select distinct vendor_no, vendor_name
from ap_vendors
where vendor_no in (
select vendor_no from ap_vendors
group by vendor_no
having array_agg(company_code) @> ARRAY['BUR','EBC','SNJ'])
On Wed, Oct 5, 2016 at 1:31 PM, Bret Stern wrote:
> Good evening,
> I'm curious about a
about, but why would the above formula
underestimate the number of object locks actually available
to a transaction? Isn't it supposed to be a hard cap for such
locks?
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via p
ber. Ensure you are still skipping
indexes.
Once the table is clean, drop the sequence column again and re-index.
Hope this helps,
Daniel
On Fri, Sep 2, 2016 at 11:06 PM, Albe Laurenz
wrote:
> Jonas Tehler wrote:
> > We’re running Postgresql 9.4.5 on Amazon RDS. One of our tables looks
Thanks David,
Lateral did the trick:
CREATE VIEW with_keywords AS
SELECT x,y,z, keywords.a, keywords.b, keywords.c
FROM large_table l, LATERAL extract_keywords(l.*) keywords(a,b,c)
Regards,
Daniel
On Wed, Aug 31, 2016 at 6:46 AM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
&g
I should penalize the function with a high
cost. But I don't see how this has any benefit in this case other than mess
up the rest of my query plan.
Thanks,
Daniel
rsed in the [0..1e7] range or
equally well dispersed in the [0..2**32] range, the probability of a newly
inserted value to compare greater or lower to any previous values of the list
should be the same, so shouldn't the page splits be the same, statistically
speaking?
Best regards,
--
Daniel Véri
https://wiki.postgresql.org/wiki/XTEA
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
join, your query returns no
records for the given data.
David J.
Look at the above documentation (7.2.1.1) on full join
https://www.postgresql.org/docs/9.3/static/queries-table-expressions.html
select coalesce(dx,dx1)as dt, n, nx1
from test full join test1 on dx=dx1;
Daniel
statement_timeout=1000
-c geqo=off'"
psql (9.3.13)
Type "help" for help.
test=> show statement_timeout ;
statement_timeout
---
1s
(1 row)
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
OK, I file a bug report.
-Ursprüngliche Nachricht-
Von: Julien Rouhaud [mailto:julien.rouh...@dalibo.com]
Gesendet: Samstag, 11. Juni 2016 11:28
An: Daniel Migowski ; pgsql-general@postgresql.org
Betreff: Re: [GENERAL] Why are no NEGATORS defined in the standard operators
Hello
On 11
, why there is no NEGATOR clause defined here?
According to the docs it should help to add
NEGATOR = <>
In query optimization. Is there some reason for it? Or is it a Bug in pgAdmin
III that the negator is not shown?
Regards,
Daniel Migowski
>> Alex Ignatov started a new thread was started on this topic as well...
>>
>> https://www.postgresql.org/message-id/c571dfc5-91b0-0df2-4e3f-45bc94c11...@postgrespro.ru
>>
>>
>>I posted a link to this thread on his new one as well.
>>
>>David J.
for completeness: same issue with data c
>>>
>>>On Mon, 30 May 2016 17:35:34 +0200 (CEST), Daniel Westermann
>>>(daniel.westerm...@dbi-services.com) wrote about "[GENERAL] Deleting a
>>>table file does not raise an error when the table is touched
>>>afterwards, why?" (in
-linux-gnu, compiled by gcc (GCC)
4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit
Thanks in advance
Daniel
equests should go to the pgsql-www@ mailinglist,
remember to include your community username in the email.
cheers ./daniel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
>>
>>Provide a link to the source document where you found the link you have
>>posted
its the homepage
http://www.postgresql.org
just to let you know:
This link is broken:
http://www.postgresql.org/docs/9./static/release-9-6.html
The description on the website is wrong:
PostgreSQL 9.6 Beta 1, 9.5.2, 9.4.7, 9.3.12, 9.2.16 and 9.1.21 Released!
Shoud be 9.5.3, shouldn't it?
Cheers,
Daniel
>> postgres@pgreporting:/home/postgres/ [PGREP] cat /etc/centos-release
>> CentOS Linux release 7.2.1511 (Core)
>>
>> Any ideas?
>File an issue here:
>https://github.com/tds-fdw/tds_fdw/issues
Thanks, issue created
, Level: 0
2016-04-24 14:43:56.268 CEST - 4 - 24539 - [local] - postgres@postgres NOTICE:
DB-Library notice: Msg #: 5703, Msg state: 1, Msg: Changed language setting to
us_english., Server: WSCORE\SQL2014, Process: , Line: 1, Level: 0
The OS is (64bit):
postgres@pgreporting:/home/postgres/ [PGREP] cat /etc/centos-release
CentOS Linux release 7.2.1511 (Core)
Any ideas?
Thanks in advance
Daniel
I am inclined to go with Francisco's solution
Daniel
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Francisco Olarte
Sent: April-25-16 10:46
To: Babak Alipour
Cc: Adrian Klaver; pgsql-general@postgresql.org
Subjec
On Wed, Apr 13, 2016 at 12:35 PM, Tom Lane wrote:
> Jim Nasby writes:
>> Actually, after looking at the code for interval_lt, all that needs to
>> happen to add this support is to expose interval_cmp_internal() as a
>> strict function. It already does exactly what you want.
>
> interval_cmp() is
Hi all,
Is there a good reason why the SIGN() function does not work with the
INTERVAL type? (It is only defined for numeric types.)
(http://www.postgresql.org/docs/9.5/static/functions-math.html)
select sign(-3); -- okay
select sign(interval '4 years'); -- ERROR: function sign(interval)
does not
code to the lo_* client-side and server-side functions that it needs.
But that's a relatively easy work for a programmer, especially if the blobs
happen to be immutable, as is often the case.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @Danie
r all.
Regards,
Daniel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
thanks a lot David
2016-02-25 15:08 GMT-03:00 David G. Johnston :
> On Thu, Feb 25, 2016 at 11:01 AM, dangal
> wrote:
>
>> In Oracle i have something like this:
>>
>> -- Create profile
>> create profile PROFILE_Query limit
>> sessions_per_user 25
>> cpu_per_call 3
>> connect_time
Dear , I would like to make a query , I plan to create a user in my
database , but only to make inquires , I would also like to have limits
such as connection time, idle time , logical reads , is this possible?
Thank you very much for your time
ite a PL/Perl or PL/Python trigger function that
>would populate the tsvector column on every INSERT or UPDATE.
Thanks to all for your input
Daniel
>>Daniel Westermann schrieb am 19.02.2016 um 11:53:
>>> if I'd need to implement/replace Oracle Text
>>> (ww.oracle.com/technetwork/testcontent/index-098492.html).
>>>> What choices do I have in PostgreSQL (9.5+) ?
>Postgres also has a full text
Hi,
if I'd need to implement/replace Oracle Text
(ww.oracle.com/technetwork/testcontent/index-098492.html). What choices do I
have in PostgreSQL (9.5+) ?
Regards
Daniel
html
Thanks in advance
Daniel
and you
don't have details of the lightning talks yet. Do you still need
speakers for full talks or lightning talks?
Also, I notice pgDay Asia is missing from the events list on the
postgresql.org main page:
http://www.postgresql.org/about/events/
Regards,
Daniel
1. http://2016.pgday.a
already
exists before trying to create it and move along if it's already there?
Thanks a lot!
On Fri, Jan 22, 2016 at 6:57 AM Craig Ringer wrote:
> On 21 January 2016 at 20:46, (Daniel Stolf) wrote:
>
>
>> So here's what I don't ge
ttp://www.postgresql.org/docs/current/static/protocol-flow.html#AEN108750
and the result comes back as binary.
Presumably the JDBC LargeObjectManager uses that method.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-genera
t potential for retrieving them
efficiently, as opposed to "SELECT lo_get(oid)" which looks like
it could trigger the undesirable round-trip to the text format.
You may want to test that or bring it up as a question to JDBC folks.
Best regards,
--
Daniel Vérité
PostgreSQL-powered m
n | restart_lsn
---++---++--++--+--+-
(0 rows)
On Thu, Jan 21, 2016 at 10:46 AM (Daniel Stolf) wrote:
> Ok, I'm at work now and I have access to my lab...
>
> * On Node 1: *
> bdrdemo=# select bdr.bdr_get_local_nodei
#x27;t they need the if of
node3 on their name?
2) If node3 has the same name and if as node1, won't that introduce a
conflic? Don't I need to clean that up before node3 can join the
replication group?
Regards,
Daniel Stolf
On Thu, Jan 21, 2016 at 8:34 AM (Daniel Stolf) wrote:
> Hi Cr
brought up the copy, if I try get local node name, it says
node1, which is the node I got the copy from, ... Wouldn't I also have to
do something about that? Like, delete the previous information on bdr
database that went along?
Em qui, 21 de jan de 2016 00:50, Craig Ringer
escreveu:
> On
Hello there...
I'm new to postgres and I'm trying out BDR replication...
I know that when I issue the bdr.bdr_group_join command, it will copy the
entire database from the host I specify on parameter 'join_using_dsn' and
this may take a while depending on the network and the size of the
database.
Hello there...
I'm new to postgres and I'm trying out BDR replication...
I know that when I issue the bdr.bdr_group_join command, it will copy the
entire database from the host I specify on parameter 'join_using_dsn' and
this may take a while depending on the network and the size of the
database.
AM, John R Pierce wrote:
>>>
>>
>> sys and dbo are Oracle schemas, is this the Oracle compatible server
>> eDB sells? contact their paid support, thats not really postgres
>> anymore.
>let me correct that, its not the community version of postgres that this
>mail list supports.
sure, thanks
daniel
talog, sys, dbo
search_path on the target is:
xx=# show search_path;
search_path
"$user",public
(1 row)
Any ideas?
Thanks,
Daniel
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of deepak
Sent: November-25-15 17:07
To: John R Pierce
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Error creating Tablespace on Windows
I chose temp only for illustration purposes. Actually
omas Kellerer writes:
>> Doiron, Daniel schrieb am 12.11.2015 um 23:21:
>>> I¹m troubleshooting a schema and found this:
>>>
>>> Indexes:
>>> "pk_patient_diagnoses" PRIMARY KEY, btree (id)
>>> "index
I’m troubleshooting a schema and found this:
Indexes:
"pk_patient_diagnoses" PRIMARY KEY, btree (id)
"index_4341548" UNIQUE, btree (id)
"idx_patient_diagnoses_deleted" btree (deleted)
"idx_patient_diagnoses_diagnosis_type_id" btree (diagnosis_type_id)
"idx_patient_diagnoses_icd
, which corresponds to PGSQL_TRANSACTION_INTRANS
as expected.
OTOH if commenting the call to pg_get_result($dbcnx), then
it ouputs 1 (PGSQL_TRANSACTION_ACTIVE) as you mentioned.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsq
something like that make sense?
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2.5 seconds to digest
a 100 MB audio file already in cache. An independant Perl script
doing the equiavlent processing on the same data takes 0.4s .
It's not because of Digest::MD5 or loread(), it seems that it's the
pipe in-between with the text->bytea decoding that eats most of the
CPU
Thank Adrian, it makes sense. I'll adapt the calling procedures Daniel
> Subject: Re: [GENERAL] Unexpected query result
> To: jfd...@hotmail.com; pgsql-general@postgresql.org
> From: adrian.kla...@aklaver.com
> Date: Mon, 5 Oct 2015 06:17:33 -0700
>
> On 10/05/2015 05:02
In order to process a large amount of data I need to run a procedure using
parallel batch processes. The query I run in each process is expected to ...
1- select a bunch of id (500) in a table (wait4processing) containing the list
of all records to process2- remove selected records from wait4pro
Does anyone running PostgreSQL 9.3 on Windows 7 has upgraded to Windows 10?
Successfully or not.
Daniel
set
shared_buffers = 128MB with an effective_cache_size = 12GB
Daniel
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Venkata Balaji N
Sent: September-22-15 21:33
To: pgsql-general
Subject: [GENERAL] Advise on memory usage limitation by
of patching the entire body of a function without a fully-fledged
parser that is dead on arrival.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
TE FUNCTION,
DECLARE would become DECLBRE and so on.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
hat pg_database_size() can report.
Maybe at some point all these will be 128 bits, but that's years ahead.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Sent via pgsql-general mailing list (pgsql-general@post
ious to guess what is the next one,
so malicious people could claim access codes or vouchers
they don't own.
The constraint is that such codes must be reasonably short, but
someone who tries to make up one must have a near-zero chance
of guessing one that actually exists.
Best regards,
--
Da
ovement in ease of use. And presumably in
performance too.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @ManitouMail
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Anyway it's not clear what you expect. PG doesn't support UTF-16,
and even if it did, it wouldn't accept such strings when the current
encoding is UTF-8.
If Active Directory wants UTF-16LE, you have to do that conversion, but
don't pass the result back to postgres in this format.
1 - 100 of 743 matches
Mail list logo
