/include/port/solaris.h to
src/include/pg_config_os
config.status: linking ./src/makefiles/Makefile.solaris to
src/Makefile.port
*
Sergey E. Koposov
Max-Planck Institut fuer Astronomie
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL
On Mon, 29 Aug 2005, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
So, are the shared memory requirements increased for 8.1 ?
Yes; mostly from 2PC support I think. Try reducing
max_prepared_transactions. (We might want to debate whether the default
setting should be smaller
cc (Forte Developer 7 C 5.4). (despite SunOS is not supported
platform following the documentation).
With Best regards,
Sergey
*
Sergey E. Koposov
Max-Planck Institut fuer Astronomie
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL
not sure that everybody will see that code properly due to encoding
differences. But the idea is just feed postgres with \x3 and one
character with the code 128.
Regards,
Sergey
*
Sergey E. Koposov
Max-Planck Institut fuer Astronomie
On Thu, 1 Sep 2005, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
2660c2660
if (isdigit(hex))
---
if (isdigit((unsigned char)hex))
Sigh. We keep fixing these, and they keep creeping back in. I wish
there were a way to get some more-mainstream compiler
difficult to optimize it to one call,
isn't it ?
With Best Regards,
Sergey
PS I tested this example with including in C code of test_func1 the static
counter of calls.
*
Sergey E. Koposov
Max-Planck Institut fuer Astronomie
Web
Hello Tom,
Slackware 10.0, kernel 2.6.12, x86, gcc 3.3.4
All 98 tests passed.
Sergey
*
Sergey E. Koposov
Max-Planck Institut fuer Astronomie
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end
With Best Regards,
Sergey
*
Sergey E. Koposov
Max-Planck Institut fuer Astronomie
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3
.
Sergey
PS
I have tried my code replacing the declaration
rec record; by rec TABLE_NAME%ROWTYPE, and it worked for both (big and
small table), but I don't understand, why it doesn't work with the type
record.
Sergey E. Koposov
Sternberg
For the real functions which I use, instead of
query = ''SELECT * FROM usno'';
I have
query = my_C_function(some_args);
Oh? I'd make a small side bet that the underlying error is in your C
function --- possibly it's tromping on some data structure and the
damage doesn't have
On Wed, 16 Feb 2005, Richard Huxton wrote:
This is just a shot in the dark, but I don't suppose you've dropped or
modified any columns in usno have you?
I seem to remember some subtle problems with dropped columns and plpgsql
functions - could be one of those still left. It'd look like
Does starting a new backend session make the problem go away?
No
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Wed, 16 Feb 2005, Tom Lane wrote:
Richard Huxton dev@archonet.com writes:
I seem to remember some subtle problems with dropped columns and plpgsql
functions - could be one of those still left.
It looks like the code that handles returning a RECORD variable doesn't
cope with dropped
Sergey E. Koposov [EMAIL PROTECTED] writes:
LOOP
FETCH cur into rec;
RETURN NEXT rec;
EXIT WHEN NOT FOUND;
END LOOP;
RETURN;
Don't you think you should have the EXIT *above* the RETURN NEXT?
I would expect this to emit a bogus row of nulls after the last
you in advance.
Sergey
Sergey E. Koposov
Sternberg Astronomical Institute, Moscow University (Russia)
Max-Planck Institute for Astronomy (Germany)
Internet: [EMAIL PROTECTED], http://lnfm1.sai.msu.su/~math
understand that this is a bit stupid and not very useful example, but
still this is probably not an expected behaviour.
With Best Regards,
Sergey
PS In Postgres 7.4.6 there is no such problem.
Sergey E. Koposov
Sergey E. Koposov
Sternberg Astronomical Institute, Moscow University (Russia)
Max-Planck Institute for Astronomy (Germany)
Internet: [EMAIL PROTECTED], http://lnfm1.sai.msu.su/~math/
---(end of broadcast)---
TIP 8: explain analyze
On Fri, 29 Apr 2005, Tom Lane wrote:
- Index Scan using ipix_idx on q3c (cost=0.01..9686.37 rows=35
width=48) (actual time=0.006..0.006 rows=0 loops=300)
Index Cond: ((q3c.ipix = (outer.ipix - 1000)) AND (q3c.ipix =
(outer.ipix - 993)))
- Bitmap
On Wed, 4 May 2005, Tom Lane wrote:
I figured out part of the problem: I had made nodeBitmapIndexscan
re-open the index on each call, thinking that that would save amrescan
calls. But an amrescan is a whole lot cheaper than index open/close,
so that was a bad tradeoff.
This seems to
On Thu, 5 May 2005, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
And I coadded the flat profiles of first two (index scan) queries and
compared it with the flat profile of bitmap scan:
Thanks, I had been thinking of doing that same calculation but hadn't
got round
://www.pgbuildfarm.org/cgi-bin/show_history.pl?nm=snakebr=HEAD
---(end of broadcast)---
TIP 6: explain analyze is your friend
*
Sergey E. Koposov
Max Planck Institute for Astronomy
Web: http://lnfm1
of that ?
Comments ?
Sorry if I was not very clear, it's the first time I'm looking so deeply
in Postgres.
Regards,
Sergey
*
Sergey E. Koposov
Max Planck Institute for Astronomy
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED
On Mon, 20 Feb 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
I've recently proposed a patch
http://archives.postgresql.org/pgsql-patches/2006-02/msg00165.php
to fix an old problem with dropped columns, but recently
http://archives.postgresql.org/pgsql-patches/2006
would be saved like \e does.
Sergey E. Koposov
Maybe it's just that I'm too used to the old behavior, but I don't like
anything about the way it works now. As an example, the new behavior is
extremely unfriendly to backslash commands. I just got done typing a
long command
, but is it
possible to allow to do things like that :
CREATE AGGREGATE new_2arg_agg ( BASETYPE = (int,int) , )
to create the two-arg. aggregates ?
I'd like to hear any comments/advices/objections...
Regards,
Sergey
*
Sergey E. Koposov
Max
On Thu, 13 Apr 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
... Nothing else and nothing internal need not to be changed to
insert new two-arg. aggregate functions into the core.
Am I right in this ?
IIRC the main issues are the syntax of CREATE AGGREGATE
,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end of broadcast
On Mon, 24 Jul 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
Since the feature freeze is in a few days, I'm sending the first iteration
of my patch implementing the multi-argument aggregates (PolyArgAgg) (SOC
project)
This patch is nowhere near ready for submission
will try to write some better tests and send a patch.
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL
On Sat, 29 Jul 2006, Peter Eisentraut wrote:
Sergey E. Koposov wrote:
I think since we are supporting the numeric type as a special
high-precision type, Postgres must have the high-precision
versions of all computational functions. Just my opinion.
Another way to look at it is whether you
,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end of broadcast
| 0.292522935332974
(2 rows)
Is that a bug, or I'm missing something ?
PG version is 8.1.4 or 8.2dev.
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http
and is using libpq,
Posgres shouldn't crash.
Thanks,
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail
On Sat, 12 Aug 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
I recently have seen the segfault with Postgres 8.1.4.
I'm betting that portal-sourceText has already been deallocated when
exec_execute_message tries to print the log message. Getting an actual
segfault from
,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end of broadcast
of icc doesn't allow to
distinguish between different optimization levels. (only between -O0 and
anything else).
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel
input arguments (Tom)
should be
* Aggregate functions now support multiple input arguments (Sergey Koposov, Tom)
instead
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
: 750437 us
LENCPY: 2751238 us
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED
On Mon, 2 Oct 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
Just the test on IA64 (Itanium2, 1.6Ghz, 8Gb memory). The results seem to
be quite different:
What libc are you using exactly? Can you try it with the unrolled
strlcpy I posted?
glibc 2.3.5 , gcc 3.4.4
my
is undefined.
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end of broadcast
On Tue, 3 Oct 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
Having recently tried to build 7.4, and 8.0 branches on Itanium2 with ICC
7.4 is not going to work with ICC anyway without considerably more
extensive changes (eg, configure hacking). It might make sense
On Tue, 3 Oct 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
Having recently tried to build 7.4, and 8.0 branches on Itanium2 with ICC
7.4 is not going to work with ICC anyway without considerably more
extensive changes (eg, configure hacking). It might make sense
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end
On Sat, 7 Oct 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
I've found a bug with 8.2beta1:
Can you put together a self-contained test case for this? The planner
I'll try, but it will be quite hard.
is evidently generating an incorrect plan from that messy view
On Sat, 7 Oct 2006, Sergey E. Koposov wrote:
cas=# explain UPDATE table_list SET description = 'tag{image
SRC=/vizier/new2.gif}3rd release of DENIS (2005Sep)' WHERE id =
cas_get_table_id ('cas_data_sega','b_denis_denis5' );
QUERY PLAN
On Sat, 7 Oct 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
Will it be enough to provide the testcase for just that 'expain UPDATE' ?
Whatever makes it crash ;-)
So, the database schema with little data and a few functions is here
http://lnfm1.sai.msu.ru/~math
On Sat, 7 Oct 2006, Sergey E. Koposov wrote:
And the java program crashing the backend is attached. (it is generally
one prepared statement , which i didn't succeded to crash from psql) (it's
possible to rewrite it in C with libpq, but I cannot do that very easily).
As I did before, I send
On Sat, 7 Oct 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
And the java program crashing the backend is attached. (it is generally
one prepared statement , which i didn't succeded to crash from psql)
Right, because the bug was in exec_bind_message, which you can't invoke
.
Regards,
S.
***
Sergey E. Koposov, PhD
Institute for Astronomy, Cambridge, UK
Tel: +44-1223-337-551
Web: http://lnfm1.sai.msu.ru/~math
E-mail: m...@sai.msu.ru
--
Sent via pgsql-hackers mailing list (pgsql-hackers
(if it is ICC fault). But to
do that, I need some advices/help, how to do it better...
regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
code as with
'-fno-alias' flag (described in ICC manuals).
regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web
:
./configure --enable-cassert --enable-depend --enable-debug --enable-nls
--enable-integer-datetimes --with-libxml LDFLAGS='-lirc -limf'
--enable-depend --prefix=/home/math/cvs/install/ CC=ic
Regards,
Sergey
***
Sergey E. Koposov
Max
,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED
,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED
On Tue, 11 Sep 2007, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
On Tue, 11 Sep 2007, Tom Lane wrote:
NOTICE: database contrib_regression does not exist, skipping
ERROR: too many active hash_seq_search scans
ERROR: too many active hash_seq_search scans
ERROR: too many
separate from the buildfarm place. That logs were mixed there.
regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web
anti-aliasing flags for ICC.
I was obviously confused by the ICC docs.
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web: http
in advance.
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL
...
*/
PG_RETURN_POINTER(im);
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web
,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end
__func__ = PostmasterMain
#14 0x40533e50 in main (argc=6, argv=0x600c0d20) at main.c:188
No locals.
-
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end of broadcast
the call of the mdextend
function in the case of quota excess won't lead to any corruption ? (in
the case of Btree splits for example ).
Any comments ?
Thank you.
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute
On Wed, 28 Feb 2007, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
1) The main idea is to implement the per-user quota (not per tablespace
for example). So, during the creation of the new user some quota can be
specified, and after that the size of all the relations *owned
. And I remember user requests for quotas in the mailing lists ...
regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
On Wed, 28 Feb 2007, Joshua D. Drake wrote:
Sergey E. Koposov wrote:
On Wed, 28 Feb 2007, Joshua D. Drake wrote:
Per user AND per database (as Tom noted). But I dont see what's odd in
it... It exists in Oracle, and I need quotas in the project on which I'm
working. And I remember user
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED]
---(end of broadcast
be definitely better than the filesystem quota
for the PostgreSQL user for example.
regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49
and/or shared memory. You can work,
but you can easily hit these limits, and than something will not work...
regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
/2004-07/msg00392.php
I remember that thread, but I think there was no patch at all, at least I
didn't see it.
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical
,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: [EMAIL PROTECTED
directory. And since all the PG tablespaces will be owned by postgres
user, I dont think the FS quotas can do the job.
regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy
On Thu, 1 Mar 2007, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
I still don't understand how FS quotas can help with DB quotas. ..
All the FS quotas are setup for limiting the space for specific user and
specific mount point. AFAIK They do not allow to limit the space in one
| 1GB
effective_io_concurrency| 0
shared_buffers | 4GB
Any ideas what can be wrong? Any info I can provide ?
Thanks in advance,
Sergey
***
Sergey E. Koposov, PhD
Institute
***
Sergey E. Koposov, PhD
Institute for Astronomy, Cambridge/Sternberg Astronomical Institute
Web: http://lnfm1.sai.msu.ru/~math
E-mail: m...@sai.msu.ru
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
in the tables, instead of
count(*) (my tables are very large), now it seems that there is a huge
discrepancy between the numbers.
Thanks,
Sergey
***
Sergey E. Koposov, PhD
Institute for Astronomy, Cambridge/Sternberg
tables...
S
***
Sergey E. Koposov, PhD
Institute for Astronomy, Cambridge/Sternberg Astronomical Institute
Web: http://lnfm1.sai.msu.ru/~math
E-mail: m...@sai.msu.ru
--
Sent via pgsql-hackers mailing list (pgsql-hackers
and
statistic dependent.
Cheers,
Sergey
PS I'm not a statistician, but I use statistics a lot
***
Sergey E. Koposov, PhD, Research Associate
Institute of Astronomy, University of Cambridge
Madingley road, CB3 0HA, Cambridge, UK
80 matches
Mail list logo