:[EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 5:53 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Get diagnistic (row_count) 7.3 vs. 7.4 changes
Maksim Likharev [EMAIL PROTECTED] writes:
consider following code:
CREATE OR REPLACE FUNCTION rowcount_test() RETURNS
Hi,
Just trying 7.4.5 and bumped into a problem.
consider following code:
CREATE OR REPLACE FUNCTION rowcount_test() RETURNS bigint AS '
DECLARE
base_hits bigint;
BEGIN
CREATE TEMP TABLE ltbl_temp AS SELECT 1 AS data;
GET DIAGNOSTICS base_hits = ROW_COUNT;
RETURN base_hits;
You mean
My queries are slow or don't make use of the indexes. Why?
may be better just fix that stone age requirement?
It just ridicules,
could statistic be build during index build, if no statistic available?
-Original Message-
From: Karsten Hilbert [mailto:[EMAIL PROTECTED]
Sent:
Don't think of this as a troll, because I really don't know, even
though I do know that MVS, OpenVMS Solaris can. (I won't even
ask about toys like Windows and FreeBSD.)
What so toy in Windows?
With some experience on huge DBs,
one on Windows ( MS SQL 2K ) works x1.5/2 faster, than one on
If you are talking about everything that lies under so called LATIN-1 (
ISO-8859-1 )
en_US encapsulates ( at least suppose to ) all those sorting rules,
do not remember about accents tho.
-Original Message-
From: Kathy zhu [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 4:43 PM
en_US locale skips? punctuation from sorting index,
so in your case
RM-791
RM-AV2100
RM-PP401
RM-PP402
RM-PP404
RM-V10
RM-V11
RM-V12
RMT-D10
RMT-D108A
RMT-D109A
RMT-D116A
RMT-V402
==
RM791
RMAV2100
RMPP401
RMPP402
RMPP404
RMV10
RMV11
RMV12
RMTD10
RMTD108A
RMTD109A
RMTD116A
RMTV402
and prod.t_results.docid =
r.docid;
BTW, what it's doing in a first place, looks up tuples generated in FROM
clause
against prod.t_results table?
-Original Message-
From: Mike Mascari [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 5:25 PM
To: Maksim Likharev
Cc: Stephan Szabo; pgsql-general
;
is standard SQL-92 update FROM form?
just trying to understand.
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 4:12 PM
To: Maksim Likharev
Cc: pgsql-general
Subject: Re: [GENERAL] Wacky query plan, why?
On Fri, 25 Jul 2003, Maksim Likharev
access.
-Original Message-
From: Luis Magaa [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 2:43 PM
To: Maksim Likharev
Cc: Postgresql General Mail List
Subject: ODBC query problem AGAIN
Hi,
After having moved all of the data to a new database initializaed with
es_MX as locale
It very much looks like a problem I had before
do you have back trace, I will say for sure.
-Original Message-
From: Luis Magaa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:12 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Subject: Re: [GENERAL] ODBC query problem
Forgotten to ask, what is locale for DB cluster?
-Original Message-
From: Luis Magaa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:37 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Subject: Re: [GENERAL] ODBC query problem
I've compiled postgresql in 32bit mode,
Yes it is most likely locale,
if you have core,
try to use on Solaris
pstack you_core_file, should be pretty distinct back trace
-Original Message-
From: Luis Magaa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 11:06 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
, NO NOTHING, just for you information.
Regards.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 3:58 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query, story continues
Maksim Likharev
);
}
pfree(val);
val = xfrmstr;
}
-Original Message-
From: Maksim Likharev
Sent: Tuesday, July 08, 2003 9:35 AM
To: 'Tom Lane'
Cc: [EMAIL PROTECTED]; '[EMAIL PROTECTED]'
Subject: RE: [GENERAL] PG crash on simple query, story continues
After upgrade on 7.3.3 we
,
BTW on Linux it works
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 11:45 AM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query, story continues
Maksim Likharev [EMAIL PROTECTED
Hi,
I just found very interesting situation,
statistic ( n_distinct in particular) records for one of my columns,
greatly under calculated it saying:
49726, but in reality 33409816.
So planer never choose index but rather using table scan, and query
never returns,
is it any way how I can improve
I would referrer dump that gar.xxg, and put PG on Linux,
but this is not up to me.
Thanks for the help.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 3:58 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG
, 2003 3:59 AM
To: Alvaro Herrera; Maksim Likharev
Cc: PostgreSQL List
Subject: Re: [GENERAL] Datatypes and performance
First of all, disable FSYNC... that will speed things up a lot!
/M
- Original Message -
From: Alvaro Herrera [EMAIL PROTECTED]
To: Maksim Likharev [EMAIL PROTECTED]
Cc
main (2, ffbefccc, ffbefcd8, 2e9d88, 0, 0) + 2e4
00032da8 _start (0, 0, 0, 0, 0, 0) + 5c
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 29, 2003 3:25 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query
Maksim
How postgres internally stores text fields, in a separate table?
-Original Message-
From: Andrew Sullivan [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 12:55 PM
To: PostgreSQL List
Subject: Re: [GENERAL] Datatypes and performance
On Fri, Jul 04, 2003 at 09:10:41AM -0700, Jay
with comparing with disk reads/writes.
-Original Message-
From: Andrew Sullivan [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 1:24 PM
To: PostgreSQL List
Subject: Re: [GENERAL] Datatypes and performance
On Fri, Jul 04, 2003 at 01:14:52PM -0700, Maksim Likharev wrote:
How postgres
values, commit transaction.
-Original Message-
From: Jean-Christian Imbeault [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 5:47 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Duplicate key insert question
Maksim Likharev wrote:
Hi,
I have consistent PG crash on some query,
so I was able to isolate a simple query that crash postgres...
SELECT p.docid FROM prod.t_documents AS p
INNER JOIN t_tempdocs AS t
ON p.docid = t.docid
LEFT OUTER JOIN prod.t_refs AS ct
ON ct.docid =
Is there any way to see what really happened?
I mean more exhausted debug info.
It seems like other server running same PG 7.3 and more or less
identical hardware is not affected by that.
Info starts here:
--main table
CREATE TABLE prod.t_documents (
documentid int4 NOT NULL,
docid
Thanks Tom,
works, have to test performance
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 7:36 AM
To: Maksim Likharev
Cc: GENERAL
Subject: Re: [GENERAL] Query plan question
Maksim Likharev [EMAIL PROTECTED] writes:
basically I
25 matches
Mail list logo
