istribution dependend 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
Madingle
work_mem| 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 for Astronomy, Cambridge UK /Sternberg Astronomical
ks all right.
Do you think that this should be fixed ?
Sergey
***********
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-hack
when I was using PG 8.4 for the same data, I was used to
do explain select * to get the number of rows 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
*
ters with large 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
e this bug(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
and produce the same 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 I
configure flags:
./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
************
n't help...
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
ests.
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: [
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_sea
n the very
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-5
rgey
PS I'm sorry for the wrong information about 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
I did a manual vacuum of one of the tables in which
the data is inserted. But I have no idea whether that's really a cause or
just a coincidence.
Regards,
S.
***
Sergey E. Koposov, PhD
Institute for Astronomy, Cambridg
x600e3410
pid = 0
__func__ = "BackendStartup"
#12 0x406d1700 in ServerLoop () at postmaster.c:1283
port = (Port *) 0x6000000e3d40
i = 0
rmask = {fds_bits = {16, 0 }}
selres = 1
readmask = {fds_bits = {16, 0
nyone have ideas what could be the reason for the bug ?
Thanks in advance.
Regards,
Sergey
***************
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
Tel: +49-6
/* fill the im->data
...
*/
PG_RETURN_POINTER(im);
Regards,
Sergey
***********
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg
Astronomical Institute
| 0
(1 row)
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.s
ergey
***
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]
---(e
ergey
***
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 broa
, I'm not completely sure that refusing 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
*************
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
rking. 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-62
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 rem
ergey
***
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 broa
edit files, copy them etc...
And that solution should be definitely better than the filesystem quota
for the PostgreSQL user for example.
regards,
Sergey
***********
Sergey E. Koposov
Max Planck Institute for Astronomy/Cambridge Insti
y little memory 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 Astr
ql.org/pgsql-hackers/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 Astronom
,
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
n one
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 Astr
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
?
Because I always used it in that function to return bigints (to not have
the additional overhead of PG_RETURN_INT64), and that's the first time a
see the bug due to that.
Thank you in advance,
Regards,
Sergey
**
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
o do better tests, feel free...
I 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
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
the
functions unusable...
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]
| 0.934251406665077 | 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
swd *) 0xb7f66cc0
pw_name_persist = 0xb7e6e000 "\\}\021"
Any ideas ? Or I should try to narrower the problem ?... (it is not very easy
for my application)...
Initially I thought that the problem can be due to JDBC, but it doesn't
seem so... In any case, since JDBC for PG
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. Ge
n (argc=3, argv=0x182) at
postmaster.c:950
i=Info: symbol i is defined but not allocated (optimized away)
opt=Info: symbol opt is defined but not allocated (optimized away)
status=Info: symbol status is defined but not allocated (optimized away)
u
e __OPTIMIZE__ preproc. symbol 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/S
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
[EMAIL PROTECTED]:~/test$ gcc -O3 -std=c99 -DSTRING='""' -DN="1" -o x x.c y.c strlcpy.c ; ./x
NONE:937878 us
MEMCPY: 3439101 us
STRNCPY:3188791 us
STRLCPY: 750437 us
LENCPY: 2751238 us
Regards,
Sergey
**
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
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
ehaviour...
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 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 mig
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 mig
ng, table_name character varying | cas_admin | sql | SELECT id FROM table_list WHERE name = $2 AND catalog_id = cas_get_catalog_id($1) |
(1 row)
-
7) The query was executed from JDBC in large transaction
8) PG have been compiled with following flags:
CONFIGURE = '--enable-cassert' '--with-perl' '--with-python'
'--prefix=/opt/pgsql8.2' 'CFLAGS=-g'
9) the only change in the posgresql.conf was
log_min_duration_statement -1 --> 0
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 of broadcast)---
TIP 6: explain analyze is your friend
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
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' );
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
htt
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 befo
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_mes
.100060928.16 rows=316
width=48)
-> Materialize (cost=12428.69..13568.41 rows=113972 width=48)
-> Seq Scan on q3c_subset uu (cost=1.00..12314.72
rows=113972 width=48)
(5 rows)
I tried this queries on 7.4.6 and 8.0.1 and th
TO TO
I 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
pix - 1000)) AND
(q3c.ipix <= ("outer".ipix - 993)))
Total runtime: 76413.737 ms
(12 rows)
Last note: all those queries were run in fully cached regime on P4 2.8Ghz.
I used the yesterday's CVS snapshot.
Are those performance results expected for the bitmap index
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)))
>
> >
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
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 thi
gt; The specs of this machine are:
> > OS: Windows / Server 2003 SP1
> > Arch: i686
> > Comp: gcc / 3.4.2
> >
> > For more information, see
> > http://www.pgbuildfarm.org/cgi-bin/show_history.pl?nm=snake&br=HEAD
> >
> >
> >
>
&
patched version of compatible_tupdesc() which now take
care of deleted columns).
So, did I make the right conclusions ? What can be the right fix of that ?
Comments ?
Sorry if I was not very clear, it's the first time I'm looking so deeply
in Postgres.
Regards,
Sergey
**
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
one line at a time. Ideally all
> statements
> 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 e
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. Koposo
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 ?
>
> II
tatus: linking ./src/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/~
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 wh
(passes all the regression tests) using both gcc (3.2.1), and
sun compiler 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 Inst
by itself.
>> \x3п
>> \.
test=# select length(xx) from test0;
length
2
(1 row)
I'm 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,
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 creepi
do so ? It should not be very 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-
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
n.htm
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)---
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
Sternb
> > 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
> damag
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 li
> 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 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 columns in
> "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 *ab
80 matches
Mail list logo
