here is function to get client ip address (only ipv4),
server address, and fe/be ports , details inside
www.psycho.pl/public/src/pgsql/ivnet.tar.bz2
please test it in yours systems (i tested on Debian 2.4.21 with grsec.)
2. Whatz up with PG_RETURN_UINT16 ??
and with type uintXX ?
And why do you
functions arguments names $1 .. )
and i tkink thet command EXECUTE should exec not SQL command, but plpgsql
command, Its very good way to create somthing like eval .
Then EXECUTE 'SELECT INTO var 4;'; will be not a problem any more.
and what about my functions to ips addreses and ports ???
hi,
when be meet error send string to fe. Is possible to be will send error
no. with this str, or only errors id ?
I mean, this basic errors, like when be crash, or connecting ...
It would be easyer and faster to check whats happend.
bye
ivan
---(end of broadcast
You can create function with security definer as super user
sth like this
create or replace function func () returns setof pg_stat_activity as '
select * from pg_stat_activity ; ' language SQL SECURITY DEFINER;
and if you want to se only query of session user you need to replace
* to columns from
jet. It will
be a temp table . When i create function [] language SQL there is a error
about non-exists table. So i have proposition to include option to
create function command : WITH / WITHOUT CHECK ... ? or PRECOMPILE ?
What do you think ?
thanks :>
On Wed, 9 Jul 2003, Rod Taylor wrote:
> On Tue, 2003-07-08 at 21:31, ivan wrote:
> > What do you think about :
> >
> > 1. OPTION RETURNS NULL ON NULL INPUT (when function is created) change to
> > RETURNS ON NULL INPUT ???
>
> I personally think
hi, now i writed support for writing and reading files by select.
i created function like in stdio.h iv_fopen (cstring,cstring),
iv_fread , etc
the FILE * struct is replaced by OID value
you can download src from
http://www.psycho.pl/public/src/pgsql/files.tar.bz2
and sample to to have /etc/passw
what do you think about plphp ?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Sat, 12 Jul 2003, Dave Page wrote:
>
>
> > -Original Message-
> > From: ivan [mailto:[EMAIL PROTECTED]
> > Sent: 12 July 2003 22:34
> > To: [EMAIL PROTECTED]
> > Subject: [HACKERS] php with postgres
> >
> >
> >
> > what d
what aoubt stream ?
in plpgsql you can just write command INSERT ... or DELETE
if you want sht like this in php you need to correct zend i think .
in php all var is declared as variant type but we need look at realy type.
I have other view, to first write php interpreter to postgres, and then
wri
someone looked at my files function ??
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
hi,
why when i revoke all on scheme pg_catalog from all (with public)
i can make select from pg_ tables and views as ordinary user ??
I can usage this scheme so why i can makeing select ?
Then i remove SELECT perm from PUBLIC on pg_ tables and then i cant
makeing select from this tables , but i c
above
-- replaced search_path ??
i tryed it witj transaction block , but it was this same result
thx :>
bye , ivan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
nay be not all, but only select from same function.
Is there sht like umask
On Wed, 16 Jul 2003, Tom Lane wrote:
> ivan <[EMAIL PROTECTED]> writes:
> > In my project i need close everything even most of pg_catalog.
> > User shoudl exec only special func. and not mor
functions to open,read,write etc files
On Mon, 21 Jul 2003, Bruce Momjian wrote:
>
> What functions are they?
>
> ---
>
> ivan wrote:
> >
> > someo
if you want to see this , there is the src :
http://www.psycho.pl/public/src/pgsql/files.tar.bz2
and sample
On Mon, 21 Jul 2003, Bruce Momjian wrote:
>
> I haven't seen those myself.
>
> -----
hi
what do you tink about :
COPY [ namespace1. ] table [ STRUCT ONLY ] TO [namespace2.] table2;
MOVE [ namepsace1. ] table TO [namespace2.] table2;
and this same whit types, functions etc
and :
ALERT FUNCTION func (ARGS) SET OWNER new_owner;
and :
CREATE TYPE new_type AS table;
this can by r
think that should be only opction.
Just like detecting client ip
On Tue, 22 Jul 2003, Bruce Momjian wrote:
>
> This allows functions to read/write operating system files. Is this of
> interest to anyone?
>
> -
When ie function is whitout any grant == public have grant to execute it.
public or user who have grant to usage on this func. namepsace.
I think when i create function , the default grant should be only for
owner. specialy when function have security definer .
or , i dont know about sth like um
default grant in runtime settings
??
On Wed, 23 Jul 2003, Tom Lane wrote:
> ivan <[EMAIL PROTECTED]> writes:
> > I think when i create function , the default grant should be only for
> > owner. specialy when function have security definer .
>
> We did it that way to beg
hi :>
i wrote function to change array to setof record, because better is
working with tuples .
http://www.psycho.pl/public/src/pgsql/array.tar.bz2
i will very glade when you check this , because im afraid thed i make same
mistakes .. (if its good ist could be added to contrib/array as one more
in psql , file command.c : 1473 there is a query to check state for
superuser, and this query is in begin/end transaction.
When user dont have perm to read pg_user its fail but transation is never
end, and ist make some confusion because user have to write "END;" or
"ROLLBACK;" themself. I just re
On Sun, 27 Jul 2003, Tom Lane wrote:
> ivan <[EMAIL PROTECTED]> writes:
> > declaration is setof record array_to_setof ( anyarray);
>
> > i trayed created it like "any" array_to_setof( anyarray) but i had problem
> > with select. i also trying write
not have the ability to read pg_user? The query is
> gone in 7.4 anyway.
>
> ---
>
> ivan wrote:
> >
> > in psql , file command.c : 1473 there is a query to check state for
> > superuser, and t
hi, i have more problems with cache :( i wrote about it latter , but there
was no answer. Because when i drop same relation its should be clean cache
too, but postgres dont do it . Ist sad because i cant do reload db , i
have errors :( what should i do ?
---(end of broadca
drop relation = drop table or drop sequence etc
I tryed RelationForgetRelation() but i dont working :(
On Mon, 4 Aug 2003, Alvaro Herrera wrote:
> On Mon, Aug 04, 2003 at 09:24:49PM +0200, ivan wrote:
> >
> > hi, i have more problems with cache :( i wrote about it latter , but t
could be \dn for describe namespace for ei : \dn pg_catalog,
or only \dn to list all namespaces
?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Can you add LIKE TO CREATE TYPE too ?
There could be also CREATE TYPE ble AS ( LIKE ) , and each colmnu from compose
type will be add to table "ble" with static (NOT) NULL, and without
defaults.
what do you think ?
---(end of broadcast)---
TIP 3:
Why when i create domain like :
CREATE DOMAIN alias_to_int AS INT;
and then function like :
CREATE FUNCTION func() RETURNS alist_to_int AS ' select 2::int; ' LANGUAGE
SQL;
and pg can not convert int to aliast_to_int, so i need to create cast for
all this same types ?
but in real alias_to_int is equal to int, only with other name;
its should be like typedef from c/c++ ?
On Sun, 17 Aug 2003, Rod Taylor wrote:
> On Sun, 2003-08-17 at 12:34, ivan wrote:
> > Why when i create domain like :
> >
> > CREATE DOMAIN alias_to_int AS INT;
> >
in pg is function to_hex () , but there is no function to_dec,
but there could be auto conversion like in c/c++ and others lang.
select 0x64;
select 0312;
( and like in asm select 01010101b; :-)
and also :
select char(0x64);
or conversion :
select '0x64' :: int;
need to change parser ?
---
ok, but in this use, but when i need to create datatype,
which i use in other tables (to be sure that always is this same)
i need to always writing casting to convert int to int ?
On Sun, 17 Aug 2003, Rod Taylor wrote:
> On Sun, 2003-08-17 at 14:30, ivan wrote:
> > but in real alias_
hi,
ist possible to compile postgres (after same small modification) to shared
so, or dll , and usr it like normal postgres , but without any server and
so on. Its whould be work like simple database (with all funciton in one
lib), which dont need any others additionals like (network,other proces
most simple version of postgres to lib(s), its also could be like
porting ??
On Mon, 8 Sep 2003, Tom Lane wrote:
> Doug McNaught <[EMAIL PROTECTED]> writes:
> > ivan <[EMAIL PROTECTED]> writes:
> >> ist possible to compile postgres (after same small modification) t
can you create second md5 function like TEXT md5(TEXT string, VARCHAR
salt); ? , This is using in shadow passwords and give more combination of
this same password.
thanks, bye
ivan
---(end of broadcast)---
TIP 9: the planner will ignore your
hi,
we can create table using LIKE syntax , so i think we could create type
with LIKE, its quite this same, ??
bye
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi
In SQLite or MySQL there is a statement INSERT OR REPLACE , is something
like this in postgres , or could be ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
hi
where can i set min/max number of process which are waiting for
connections from clients ?
bye
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
hi,
i have a problem with selecting function :
db=# select auxilium.exists('arx.mods', 'r');
exists
t
(1 row)
db=# select exists('arx.mods', 'r');
ERROR: syntax error at or near "'arx.mods'" at character 15
db=# show search_path;
search_path
---
auxi
Hi, How can i check how many tules has my declared cursor ?
I can set absolute position in cursor , but i dont know how far can i go ?
I need it also to set size of my scroll .
One more question , when i use declare cursor to show select on grid,
better is to use cursor in BEGIN/END WORK, or WITH
hi,
how put password to psql, pg_dump etc by same shell script (for ie by
crontab) , because there are option -W but passwd is reading from /dev/tty
not from stdin , so i can not use | :(
---(end of broadcast)---
TIP 6: Have you searched our list
pg_dump: handler procedure for procedural language "plpgsql" not found
pg_dumpall: pg_dump failed on database "db", exiting
why ?
i create this language by script createlang as superuser for this database
so, ?
:)
---(end of broadcast)---
TIP 7:
hi
can we change initdb when view pg_user is createing to :
CREATE VIEW pg_user AS \
SELECT \
usename, \
usesysid, \
usecreatedb, \
usesuper, \
usecatupd, \
''::text as passwd, \
valuntil, \
useconfig \
FROM pg_shado
:
> ivan wrote:
>
> > hi
> >
> > can we change initdb when view pg_user is createing to :
> >
> > CREATE VIEW pg_user AS \
> > SELECT \
> > usename, \
> > usesysid, \
> > usecreatedb, \
> > us
hi
i need to connect to by my database more then 100 connections,
but after ~20-30 conn, postmaster says me "Resource temporarily
unavailable", what are this resource ?
im using debain with kernel 2.4.23-pre7, on P4 , (postgres 7.4.1)
what can be wrong ?
---(end of bro
max_connections=200
shared_buffers=2000
ram = 500M + 300M swap
hdd = infinite
On Fri, 26 Dec 2003, Joshua D. Drake wrote:
>
> >hi
> >
> >i need to connect to by my database more then 100 connections,
> >but after ~20-30 conn, postmaster says me "Resource temporarily
> >
> >
> >unavailable", wh
gt;
> Joshua D. Drake
>
>
> ivan wrote:
>
> >max_connections=200
> >shared_buffers=2000
> >
> >ram = 500M + 300M swap
> >hdd = infinite
> >
> >
> >On Fri, 26 Dec 2003, Joshua D. Drake wrote:
> >
> >
> >
> >>>h
ulimit -u = 256 ,
it's ok, ?
On Fri, 26 Dec 2003, Tom Lane wrote:
> ivan <[EMAIL PROTECTED]> writes:
> > i need to connect to by my database more then 100 connections,
> > but after ~20-30 conn, postmaster says me "Resource temporarily
> > unavailable&quo
(-u) 400
virtual memory(kbytes, -v) unlimited
On Fri, 26 Dec 2003, Tom Lane wrote:
> ivan <[EMAIL PROTECTED]> writes:
> > the error is : could not fork new process for connection: Resource
> > temporarily unavailable
>
> We could have saved some time if you&#
is there same easy way to turn on translation bettwen client and server
from linux new-line style (0x0A) to windows style (0x0A0D?)
(something like conversions) ?
---(end of broadcast)---
TIP 8: explain analyze is your friend
its must be in run time, server should has text with linux new line,
and if clinet is windows, postgres would convert \n to \n\r
but when clinet is also linux postgresa can do nothing about it
:)
any idea ?
On Sat, 27 Dec 2003, [iso-8859-1] Jürgen Cappel wrote:
> Hi Ivan,
>
> mayb
hi
how to do select from same table to get only unique values from same
column(s) ?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
as new know plpgsql has special cache which remember too long (event
non-existing tables (i mean old oid)) so i suggest to create same function
only in plpgsql which would clear this cache, or sth like this ?
for ie, where i drop table i would do plpgsql_clear_cache ();
and when i will create on
etc in function, but using only EXECUTE ..
there must be same solution .. no ?
On Wed, 31 Dec 2003, Jan Wieck wrote:
> ivan wrote:
>
> >as new know plpgsql has special cache which remember too long (event
> >non-existing tables (i mean old oid)) so i suggest to create same f
i didnt find gethostbyaddr, could be this in default implementation ?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
but , all in all, do you think that now it is ok ?
On Wed, 31 Dec 2003, Jan Wieck wrote:
> ivan wrote:
> > why all backend can not using one cache, which would be always
>
> Variable sized shared memory with garbage collection for SPI plans?
>
> > in real state ... or
how can i change default time format because now i have for example
2004-01-01 16:51:46.995927 but i want only 2004-01-01 16:51:46, with out
millisec. a tryed with Data-Style but there arent custom style :/
---(end of broadcast)---
TIP 6: Have yo
message, not just trigger
(i said trigger only to show scheme of acction)
ehheh this idea is also wrong ?
On Wed, 31 Dec 2003, Jan Wieck wrote:
> ivan wrote:
> > why all backend can not using one cache, which would be always
>
> Variable sized shared memory with garbage collectio
but what about default style ?
first time when i saw DateStyle i thought that i can use it like C/C++
function strftime. I would be not bad idea to have custom data style :)
On Fri, 2 Jan 2004, Christopher Kings-Lynne wrote:
> Create table with type TIMESTAMP(0)
>
> Chris
>
ok, bat each time where i want to do select .. a nie tu use to_char,
but it should be in function timestamp_out to convert time to string
it would be easer and faster.
On Sat, 3 Jan 2004, Kurt Roeckx wrote:
> On Sat, Jan 03, 2004 at 09:25:14AM +0100, ivan wrote:
> >
> > but wha
i know, but i talking about default time output, it would be for
time, date and date with time, not formating all the time.
On Sun, 4 Jan 2004, Tom Lane wrote:
> Martin Marques <[EMAIL PROTECTED]> writes:
> > Look deeper into what Christopher said and use casting to get the right
> > output:
> >
why there are no operators +-*/ to oid data type ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
there can be same problems with back convering, but its would be only
when select is going out, to cstring form, and all its depend on user,
but this is ok :)
On Mon, 5 Jan 2004, Karel Zak wrote:
> On Sat, Jan 03, 2004 at 10:20:57PM +0100, ivan wrote:
> >
> > ok, bat each time
hi,
is there same packets (or sources to compile) only for client-systems
( headers and libs like libpq, and so on) ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
but on postgres ftps mirrors are only full-packet, -base, -dosc, -opt, and
-test , where can be -devel or -libs ? ( use -base ? )
On Mon, 1 Mar 2004, Martin Marques wrote:
> El Lun 01 Mar 2004 11:11, ivan escribió:
> > hi,
> >
> > is there same packets (or sources to com
gging purposes.
--
Ivan Kartyshov
Postgres Professional: www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
«GetXLogOldestLSNPtr» [-Wmissing-prototypes]
GetXLogOldestLSNPtr(void)
Thanks.
Hi Yury,
thank for valuable remark.
Changes applied
--
Ivan Kartyshov
Postgres Professional: www.postgrespro.com
Russian Postgres Company
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index f9eea76..f774233
On 27.02.2016 16:09, Michael Paquier wrote:
On Sat, Feb 27, 2016 at 3:52 PM, Kartyshov Ivan
wrote:
Maybe i wasn't too accurate in terms, because I newbie, but:
We can get information about xlog, using big amout of support function
(pg_current_xlog_location(), pg_current_xlog_insert_loc
On 28.02.2016 11:36, Michael Paquier wrote:
On Sun, Feb 28, 2016 at 4:40 PM, Kartyshov Ivan wrote:
It will not satisfy our purposes and our administrators for three reasons.
1) DBA set me task to get the oldest number that present in WAL, not last
Yeah I got that.
2) Surely we can choose
On 11.03.2016 16:33, Kartyshov Ivan wrote:
On 28.02.2016 11:36, Michael Paquier wrote:
On Sun, Feb 28, 2016 at 4:40 PM, Kartyshov Ivan wrote:
It will not satisfy our purposes and our administrators for three
reasons.
1) DBA set me task to get the oldest number that present in WAL, not
The following review has been posted through the commitfest application:
make installcheck-world: tested, failed
Implements feature: tested, failed
Spec compliant: tested, failed
Documentation:tested, failed
Applied this patch, it works well, make what it expected corr
The following review has been posted through the commitfest application:
make installcheck-world: tested, failed
Implements feature: tested, failed
Spec compliant: tested, failed
Documentation:tested, failed
Tested, I think it`s rather important to make cleanup work on
case.
Best regards,
--
Ivan Kartyshov
Postgres Professional: www.postgrespro.com
Russian Postgres Company
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index f9eea76..f774233 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -16908,6 +16908,8 @@ SELECT set_c
> Why does it say "tested, failed" for all points above there? ;-)
Hi, I just used Web reviewer form on https://commitfest.postgresql.org to make
review on patch, but form doesn't work properly unlike the patch.))
Suppose we have some table
create table cnt(
usr_id int primary key,
usr_doc_ref text not null,
cnt int,
sum int
);
And going to run some insert on conflict update on it (pgbench script):
\setrandom id 1 50
insert into cnt as c(usr_id,usr_doc_ref, cnt) values(:id, '#'||:id, 1) on
con
ished with success (without NOTICE message)
The WAITLSN as expected wait LSN, and interrupts on PostmasterDeath,
interrupts or timeout.
Your feedback is welcome!
---
Ivan Kartyshov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
diff --git a/doc/src/sgml/ref/allfi
d to see your feedback!
---
Ivan Kartyshov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
diff --git a/contrib/pg_buffercache/Makefile b/contrib/pg_buffercache/Makefile
index 065d3d6..8813c50 100644
--- a/contrib/pg_buffercache/Makefile
+++ b/contrib/pg_bufferc
g.
On 09/02/2016 06:30 AM, Peter Geoghegan wrote:
> I would like to be able to run pg_buffercache in production from time
> to time.
Yes, in our experience the usage of fully consistent pg_buffercache in
production is quite a courageous decision.
---
Ivan Kartyshov
Postgres Professiona
hirdly, it is slower because it locks the partitions of shared memory
in a different way than in consistent or nonconsistent methods.
The semi-consistent strategy implies that only one buffer is locked at a
time. Therefor has no significant effect on the system, but it takes
more time.
---
Iva
run queries on it" ? Or something else?
Yes you are right, I want to ensure data consistency on downstream
before running queries on it. Our clients would use it as a part of
background worker and maybe directly in apps too.
---
Ivan Kartyshov
Postgres Professional: http://www.postgre
to be
a LSN would still allow for progress in transaction management. For
example, making PostgreSQL distributed will likely want timestamp
and/or vector clock based visibility rules.
I'm sorry I did not understand exactly what you meant.
Please explain this in more detail.
--
Ivan Kart
New little cleanup code changes
--
Ivan Kartyshov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Companycommit 217f842726531edb1b0056a5c5727ab01bab7f9b
Author: i.kartyshov
Date: Mon Oct 23 12:08:59 2017 +0300
Cherry picked and ported 11dev
diff --git a/doc/src
Alexander Korotkov писал 2017-10-23 13:19:
Despite code cleanup, you still have some random empty lines removals
in your patch.
I reconfigured my IDE to avoid this in the future.
--
Ivan Kartyshov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Companydiff --git a/doc
grow)
--
Ivan Kartyshov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Companydiff --git a/src/backend/catalog/storage.c b/src/backend/catalog/storage.c
index 9a5fde0..68decab 100644
--- a/src/backend/catalog/storage.c
+++ b/src/backend/catalog/storage.c
@@ -31,6
Ants Aasma писал 2017-10-26 17:29:
On Mon, Oct 23, 2017 at 12:29 PM, Ivan Kartyshov
wrote:
Ants Aasma писал 2017-09-26 13:00:
Exposing this interface as WAITLSN will encode that visibility order
matches LSN order. This removes any chance of fixing for example
visibility order of async/vs
obvious to me that there's any point in taking the lock
on the buffer mapping partition; I'm thinking that doesn't really do
anything unless we lock them all, and we all seem to agree that's
going too far.
Replace consistent method with semiconsistent (that lock buffer he
ce: select pg_waitlsn will release on PostmasterDeath or
Interruption events if they come earlier then target LSN or timeout.
--
Ivan Kartyshov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
diff --git a/contrib/pg_waitlsn/Makefile b/contrib/pg_waitlsn/Makefile
n
v_v3 (core feature)
I will leave the choice of implementation (core/contrib) to the
discretion of the community.
Will be glad to hear your suggestion about syntax, code and patch.
--
Ivan Kartyshov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
diff --g
is there a pointer to the latest summary of goals and design for
parallel query work?
Thanks!
Cheers,
Ivan
Hi, guys! I made a quick patch to support floating number in
connect_timeout param for libpq. This will treat floating number as
seconds so this is backwards-compatible. I don't usually write in C,
so there may be mistakes. Could you review it and give me some
feedback?
--
Regards, Ian Babrou
http
timeouts matter.
On 5 July 2013 22:20, Tom Lane wrote:
> ivan babrou writes:
>> Hi, guys! I made a quick patch to support floating number in
>> connect_timeout param for libpq.
>
> What exactly is the use case for that? It seems like extra complication
> for something with
On 5 July 2013 23:26, Tom Lane wrote:
> ivan babrou writes:
>> If you can figure out that postgresql is overloaded then you may
>> decide what to do faster. In our app we have very strict limit for
>> connect time to mysql, redis and other services, but postgresql has
&g
On 5 July 2013 23:47, ivan babrou wrote:
> On 5 July 2013 23:26, Tom Lane wrote:
>> ivan babrou writes:
>>> If you can figure out that postgresql is overloaded then you may
>>> decide what to do faster. In our app we have very strict limit for
>>> connect tim
On 8 July 2013 20:40, David E. Wheeler wrote:
> On Jul 8, 2013, at 7:44 AM, ivan babrou wrote:
>
>>> Can you tell me why having ability to specify more accurate connect
>>> timeout is a bad idea?
>>
>> Nobody answered my question yet.
>
> From an earlier
On 9 July 2013 11:05, Markus Wanner wrote:
> On 07/08/2013 08:31 PM, ivan babrou wrote:
>> Seriously, I don't get why running 150 poolers is easier.
>
> Did you consider running pgbouncer on the database servers?
>
> Regards
>
> Markus Wanner
Database server lost
On 9 July 2013 12:20, Markus Wanner wrote:
> On 07/09/2013 09:15 AM, ivan babrou wrote:
>> Database server lost network — boom, 2 seconds delay. What's the point then?
>
> Oh, I see. Good point. It could still improve connection time during
> normal operation, though.
On 9 July 2013 17:59, Markus Wanner wrote:
> Ian,
>
> On 07/05/2013 07:28 PM, ivan babrou wrote:
>> - /*
>> - * Rounding could cause connection to fail; need at
>> least 2 secs
>> - */
>
> Y
On 9 July 2013 19:17, Dmitriy Igrishin wrote:
>
>
>
> 2013/7/9 Merlin Moncure
>>
>> On Fri, Jul 5, 2013 at 12:28 PM, ivan babrou wrote:
>> > Hi, guys! I made a quick patch to support floating number in
>> > connect_timeout param for libpq. This will tre
On 9 July 2013 18:43, Andres Freund wrote:
> On 2013-07-05 21:28:59 +0400, ivan babrou wrote:
>> Hi, guys! I made a quick patch to support floating number in
>> connect_timeout param for libpq. This will treat floating number as
>> seconds so this is backwards-compatible. I d
Is there any hope to see it in libpq? If so, can anyone review latest
version of my patch?
On 10 July 2013 11:49, ivan babrou wrote:
> On 9 July 2013 18:43, Andres Freund wrote:
>> On 2013-07-05 21:28:59 +0400, ivan babrou wrote:
>>> Hi, guys! I made a quick patch to support
1 - 100 of 139 matches
Mail list logo
