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
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
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
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
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
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
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
LSN is replayed can be used.
WAITLSN_NO_WAIT '0/693FF800';
Notice: WAITLSN will release on PostmasterDeath or Interruption events
if they come earlier then target LSN or timeout.
Thank you for reading, will be glad to get your feedback.
--
Ivan Kartyshov
Postgres Professional: http://www.
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
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
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
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
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
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
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
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
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 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
«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
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
> 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.))
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
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
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
is there a pointer to the latest summary of goals and design for
parallel query work?
Thanks!
Cheers,
Ivan
On Sep 3, 2013, at 6:56 AM, Karl O. Pinc wrote:
> On 07/31/2013 12:08:12 PM, Ivan Lezhnjov IV wrote:
>
>> Patch filename: backup.sgml-cmd-v003.patch
>>
>> The third version of this patch takes into consideration feedback
>> received after original submission (it
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
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
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 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 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 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 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 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 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
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
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
Alright gentlemen here we go, take two.
backup.sgml-cmd-v002.patch addresses your feedback and offers a better worded
statements that avoid implying that some features are being deprecated when it
isn't the case. We also spent some more time polishing other details, like
making adjustments to t
Hello everyone!
I'd like to thank you for quick replies and for the thoughtful feedback.
I'm working on improving the current wording and I'm going to follow up shortly
with an updated version.
Please, stay tuned.
Ivan
On Feb 11, 2013, at 12:15 AM, Tom Lane wrote:
>
>
this approach.
It is meant for application, and is against master branch.
The patch does pass 'make check' and 'make html' successfully.
PS: this is my first submission ever. So, if I'm missing something or not doing
it as expected, please, do let me know. Thank you.
Ivan
On Sun, 28 Feb 2010 23:02:39 -0500
Robert Haas wrote:
> On Sun, Feb 28, 2010 at 8:43 AM, Ivan Sergio Borgonovo
> wrote:
> > I've no idea what to do next other than asking if someone can
> > give a look to the code and check my comprehension of what a
> > tsquery sho
and no error.
I've no idea what to do next other than asking if someone can give a
look to the code and check my comprehension of what a tsquery should
be in memory.
http://www.webthatworks.it/d1/files/ts_utilities.tar.bz2
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
a small problem. The op is always char = 0x08 (even on
a much simpler function that just retrieve op and return it as a
masked int64.
It seems that
char op = PG_GETARG_CHAR(1);
is not really what I thought it to be.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-hackers m
#x27;, '&', 'ACD'
);
should be turned into
pizza:A & risotto:C & risotto:D & barolo:A & barolo:C
I noticed you actually loop over the tsvector in tsvectorout to
allocate the memory for the string buffer and I was wondering if it
is really worth for my case as well
g to be preferred
during a scan between
'java:1A,2B '::tsvector @@ to_tsquery('java:A | java:B');
vs.
'java:1A,2B '::tsvector @@ to_tsquery('java:AB')
?
they look equivalent. Are they?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgs
On Sun, 31 Jan 2010 22:24:40 +
Mark Cave-Ayland wrote:
> Ivan Sergio Borgonovo wrote:
>
> > Of course I can write a script that can workaround this.
> > It seems that the only thing missing is that pgxs 8.3 used to
> > prefix .so with lib and then rename them at in
On Sun, 31 Jan 2010 02:44:13 -0200
Euler Taveira de Oliveira wrote:
> Ivan Sergio Borgonovo escreveu:
> > I'm pretty sure that what you're pointing at is not going to work
> > unless you specify a bunch of other parameters.
> Ugh? Are you saying there is some
On Sat, 30 Jan 2010 22:25:32 -0200
Euler Taveira de Oliveira wrote:
> Ivan Sergio Borgonovo escreveu:
> > That's pretty expensive.
> >
> Ugh?
>
> > I mean... I just would like my .so end up with the expected name
> > somewhere else.
> It's just t
On Sat, 30 Jan 2010 18:32:58 -0500
Robert Haas wrote:
> On Sat, Jan 30, 2010 at 5:36 PM, Ivan Sergio Borgonovo
> wrote:
> >> For development purposes you would be far better off building a
> >> private version of postgres (with configure --prefix=/path) and
> >>
On Sat, 30 Jan 2010 16:51:44 -0500
Andrew Dunstan wrote:
> Ivan Sergio Borgonovo wrote:
> > It is becoming a more serious issue than what I thought...
> > Debian install everything in
> > /usr/lib/postgresql/8.3/lib/
> > -rw-r--r-- 1 root root
> > so defin
On Sat, 30 Jan 2010 11:06:02 -0500
Tom Lane wrote:
> Ivan Sergio Borgonovo writes:
> > ... I can't make install (provided it works as expected, I
> > didn't try yet) since I sincerely hope that my user doesn't have
> > write right on whatever is pointed by
On Sat, 30 Jan 2010 11:06:02 -0500
Tom Lane wrote:
> Ivan Sergio Borgonovo writes:
> > ... I can't make install (provided it works as expected, I
> > didn't try yet) since I sincerely hope that my user doesn't have
> > write right on whatever is pointed by
l.sql
- sed -e 's/\$libdir/'`pwd`'/g' uninstall_module.sql >
uninstall_module.l.sql
- psql < sometestcode.sql
Not that bad... but if that "someunknownparam" existed it would be
nicer and avoid hard coding the module name in 2 places (Makefile and
bash script)[1]
ArrayType one element at a time
1 seems to require
- creating an array of Datum
- looping over the C array
- assign to each Datum element the "converted" C value
- construct_array the Postgres array
That's a pain. Any other way? macro?
2 Seems the easiest
3 ???
Is there any func
atic values to construct_array since they are
"basic type" array so the size etc... should be known at compile
time, inspite of having to call get_typlenbyvalalign?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-hackers mailing list (pgsql-hackers
On Wed, 27 Jan 2010 22:06:43 +0200
Heikki Linnakangas wrote:
> Ivan Sergio Borgonovo wrote:
> > But then... why do we have all that logic to save the function
> > context if anyway it is more convenient to process everything in
> > one run?
> > It's a pain to
it the first time I wasn't in a condition to
take advantage of it. Now it looks more useful.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ialized mode?
Is there a rule of thumb to chose between one mode or the other?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
; Probably, but I didn't check.
Does this nearly translate to:
"nothing you should care about right now and anyway just functions
that won't return results to SQL"?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-hackers mailing list (pgsql-hac
t; or the like.
Right now I've not enough knowledge to hope my notes get into the
source code. Once I've a working piece of code I'll put the
information I gathered in the process on my web site and if someone
find them worth for a better place I'll release them with a su
On Wed, 27 Jan 2010 14:44:02 +0100
Martijn van Oosterhout wrote:
> On Wed, Jan 27, 2010 at 02:14:36PM +0100, Ivan Sergio Borgonovo
> wrote:
> > I haven't been able to understand the difference between function
> > returning cstring and text and if there is any need
On Mon, 25 Jan 2010 16:36:46 -0600
"Kevin Grittner" wrote:
> Ivan Sergio Borgonovo wrote:
>
> The README files might be a good place to start, then browse code.
Is there a book?
The more I read the source and the few info about it, the more I
have questions that should ha
reference and knowledge of the code base it's pretty hard even to
find prototype/sample code.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sat, 23 Jan 2010 15:54:04 +
Greg Stark wrote:
> On Sat, Jan 23, 2010 at 12:56 PM, Ivan Sergio Borgonovo
> wrote:
> > And if I can... how, why and when... because I didn't find any
> > clear example in the source tree that gives me a clue about when
> >
TEXTOID, -1, 0);
/*
??
Oid oidtypeid, // where can I get a list of OID
int32 typmod,
int attdim)
*/
/* ??? */
funcctx->tuple_desc = BlessTupleDesc(tupdesc);
funcctx->attinmeta = TupleDescGetAttInMetadata(tupdesc);
--
Ivan Sergio Borgonovo
http://ww
On 27/01/2008, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> On Sat, Jan 26, 2008 at 07:32:35PM +0100, Ivan Voras wrote:
> > Andrew Dunstan wrote:
> [...]
> > >Or you could use an hstore (see contrib).
> >
> > Doesn't seem applicable.
>
> Have a
Tom Lane wrote:
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
On 26/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote:
Although this won't work at the SQL level in 8.1, I think you might be
able to accomplish the equivalent within plpgsql by assigning the
rowtype value to a text variable.
you lost n
Andrew Dunstan wrote:
Why not create the audit tables with composite types rather than strings?
create table audit_foo_table as (who text, when timestamptz, old foo,
new foo);
Because this would lead to having a log/shadow/audit table for every
table I wish to log. (or is there an opaque
Pavel Stehule wrote:
Hello,
use plperl.
I'd like something more light-weight to reduce complexity of deployment.
Something in pgplsql would be ideal. Is there a way to simply iterate
over the fields of a row and retrieve field names and values?
PostgreSQL hasn't simple tool for it. Maybe
Hi,
I'd like to implement some simple data logging via triggers on a small
number of infrequently updated tables and I'm wondering if there are
some helpful functions, plugins or idioms that would serialize a row
(received for example in a AFTER INSERT trigger) into a string that I'd
store in
ed just after it finishes with nearest phpPgAdmin
release.
Any feedback is welcome.
Best regards,
Ivan Zolotukhin
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Tom,
Can you please suggest a good practice how to propagate such DB
settings into dumps?
I also suffer from this: my DB currently have 5 schemas and
application strongly depends on the search_path. I cannot dump whole
cluster, I need only 1 specific database. At this moment I use ugly
solution
gt; To participate in the translation effort, please follow the instructions set
> out on that page, or contact me directly if you have further questions.
>
Is there any particular reason why there is no translation in Bulgarian?
If it's only the lack of contributors, you can count m
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
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
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,
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]
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
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
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
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
why there are no operators +-*/ to oid data type ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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:
> >
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
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
>
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
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
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
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
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
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
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
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
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
(-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
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
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
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
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
:
> ivan wrote:
>
> > hi
> >
> > can we change initdb when view pg_user is createing to :
> >
> > CREATE VIEW pg_user AS \
> > SELECT \
> > usename, \
> > usesysid, \
> > usecreatedb, \
> > us
1 - 100 of 139 matches
Mail list logo